16 Dec 2013 by Maciej Los
Have a look at example:DECLARE @tmp TABLE(ID INT IDENTITY(1,1), PaymentIn INT, PaymentOut INT)INSERT INTO @tmp (PaymentIn, PaymentOut)VALUES(50000, 0), (0, 2000), (0, 3000), (0, 2500), (0, 2500), (0, 3000), (0, 3000), (0, 2000), (0, 1000), (0, 2000)SELECT t1.ID,...