So, I've got a bit of a conundrum that I cannot for the life of me figure out.
Here's what I need to do :
In column PO_I, look for column ITEM with lowest # in column Seq_I.
If column Ship_Q < Qty_Ordered, look for Ship_Qty within ITEM with next largest Seq_I, and sum the Ship_Qtys. Continue this until all Ship_Qs of the ITEM in the same PO_I have been summed.
Is this possible to do in SQL?