quote:

---

Originally posted by Joshrinn

Yes I have an ordering standard that I will follow. It will b on the basis of date an few other fields.

---

------------------------------------------------------------
-- using a cte
------------------------------------------------------------
;WITH cte AS
(
	SELECT *,COALESCE(Amount,0)-COALESCE(Balance,0) AS NewRemainingBalance
	FROM YourTable
	WHERE
		YourOrderingColumnValue = 1
	UNION ALL
	SELECT
		y.*, c.NewRemainingBalance - c.Balance 
	FROM
		YourTable y
		INNER JOIN cte c ON
			c.YourOrderingColumnValue+1 = y.YourOrderingColumnValue
)
SELECT * FROM cte;

------------------------------------------------------------
-- using a subquery
------------------------------------------------------------
SELECT
	y.*,
	c.NewRemainingBalance
FROM
	YourTable y
	CROSS APPLY
	(
		SELECT SUM(COALESCE(c.Amount,0))-SUM(COALESCE(c.Balance,0)) AS NewRemainingBalance
		FROM YourTable c
		WHERE c.YourOrderingColumnValue <= y.YourOrderingColumnValue
	) c;