The second D record for 33 should not be picked. The prior C record was match with a single D creating the offsets.

Thanks Jeff

I have a SQL Server 2008 table called invoices. I’m trying to use an UPDATE SQL command to perform the following column compares within a single invoice table. Example below. Tried numerous attempts, but do not get the results as expected in the offset column. Any help would be much appreciated – thanks Jeff.

Challenge 1:
UPDATE the below invoice table to identify the offsetting credits and SET offset=’x’ WHERE:...