i am trying to figure out the following:
i need to insert a row to table b where the customer_number can be the same as well as the order_number
the item_number will always be different (a spoon (item 123, a cup 345 can be part of the same order)
but if the ship date is the same (no time portion) then I just need to insert one row for this order.
this is table a
id order_number Customer_id item_number customer_name shipping_date
673 6176716 21608490 LP1279299 AMY BANNER 2008-02-08 11:07:01.000
674 6176716 21608490 LP1279298 AMY BANNER 2008-02-08 11:07:36.000
any suggestions will be great, thank you.