Looking for some help to create an update statement in SQL 2005 --
Basically we have an order details table that contains, ShipUnit, Item and Quantity
I need to know how many ShipUnit locations get the same Item and Quantity so our warehouse can
stage the items - We call this grouping like shipments.
In SQL I have tried cursors, inner joins, exists, in, not exists - even the new PIVOT command from
SQL 2005 -- kinda stuck here
All items in a MasterPO must go in the same box, - a shipment may contain multiple MasterPo's
Attached is the sample csv file, which is a snapshot of the SQL table.