Hi,
Check the following Sample....
IF OBJECT_ID('TempDB..#TestSample') IS NOT NULL DROP TABLE #TestSample
CREATE TABLE #TestSample(Sno INT,Opening INT,Deposit INT,Withdraw INT,Closing INT,TransactionDate DATETIME)
INSERT INTO #TestSample(Sno, Opening, Deposit, Withdraw, Closing, TransactionDate)
VALUES(1, 0, 1000, 0, 0, '2013/02/21'),(2, 0, 0, 300, 0, '2013/02/22'),(3, 0, 5000, 0, 0, '2013/02/23')
SELECT T.Sno, (ISNULL((SELECT SUM((Opening+Deposit-Withdraw))
FROM #TestSample
WHERE Sno < T.Sno),0)) 'OpeningBalance',
T.Deposit, T.Withdraw,
(ISNULL((SELECT SUM((Opening+Deposit-Withdraw))
FROM #TestSample
WHERE Sno < T.Sno),0) + T.Deposit - T.Withdraw) 'ClosingBalance',
T.TransactionDate
FROM #TestSample T