DECLARE @sample TABLE
        (
         id INT,
         amt MONEY
        )

INSERT  @sample (id, amt)
        SELECT  1, 2
        UNION
        SELECT  2, -1
        UNION
        SELECT  3, -3
        UNION
        SELECT  4, -2
        UNION
        SELECT  5, 5
        UNION
        SELECT  6, 1
        UNION
        SELECT  7, 0
        UNION
        SELECT  8, 0;

/*
ids are sequential:
id 1 underpaid by $2.  Outstanding: $2
id 2 overpaid by $1.   Outstanding: $1
id 3 overpaid by $3.   Outstanding: $0
id 4 overpaid by $2.   Outstanding: $0
id 5 underpaid by $5.  Outstanding: $5
id 6 underpaid by $1.  Outstanding: $6
id 7 paid minimum.     Outstanding: $6
id 8 paid minimum.     Outstanding: $6
*/

quote:

---

Originally posted by vijayisonly

What is your expected output...and how did you calculate outstanding amount?

---

DECLARE @solution TABLE
(
  id INT,
  amt MONEY,
  outstanding MONEY
)

DECLARE @id INT

SET @id = 1

WHILE EXISTS ( SELECT 1
               FROM   @sample
               WHERE  id >= @id )
  BEGIN

    INSERT  @solution ( id, amt, outstanding )
            SELECT  s1.id,
                    s1.amt,
                    CASE WHEN ( s1.amt + ISNULL(s2.outstanding, 0) ) < 0
                         THEN 0
                         ELSE s1.amt + ISNULL(s2.outstanding, 0)
                    END
            FROM    @sample s1
            LEFT JOIN @solution s2
                    ON s1.id = s2.id + 1
            WHERE   s1.id = @id

    SET @id = @id + 1

  END

SELECT  *
FROM    @solution