how to calculate running balance

Question

SELECT              
CONVERT (VARCHAR,GLTR_PSTNG_DATETIME,101) AS   GLTR_PSTNG_DATE,           
GLTR_DOC_CODE,             
GLTR_OUR_DOC_NO,     
CONVERT (VARCHAR,GLTR_DOC_DATETIME,101) AS   GLTR_DOC_DATETIME,           
GLTR_TRAN_AMT,
GLTR_FC_CODE,            
GLTR_FC_AMT          
FROM            
GLAS_GL_TRANSACTIONS            
WHERE            
GLTR_COMP_CODE = '1' 
AND GLTR_ACCT_CODE= SUBSTRING('1110011',4,4)            
AND GLTR_PSTNG_DATETIME  BETWEEN '05/13/2008' AND '11/26/2009'          
AND ISNULL('bv',GLTR_DOC_CODE) = GLTR_DOC_CODE
group by   GLTR_PSTNG_DATEtime

this query i am fetching from the database to the grid here my secanrio is when the transamt reterives it should calculate the running balance amount and it should be display it should show like this (running balance is not a database field item)

gltr_tran_amt  running balance
-480.000        -480.000
 480.000         0
-2540.500       -2540.500
 2540.500        0
-3800.000       -3800.00
 3800.000        0
 500             500
 1000            1500

it should retrieve and show like this

Answer 1

OK, as the comment stated, you should state you your question a little better. Also, providing a schema would have helped a lot more.

I think I know what you want to do, and this should help you into the correct direction

DECLARE @Table TABLE(
     ID INT IDENTITY(1,1),
     DateVal DATETIME,
     Amount FLOAT
)

INSERT INTO @Table (DateVal,Amount) SELECT '01 Jan 2009', -480
INSERT INTO @Table (DateVal,Amount) SELECT '01 Jan 2009', 480
INSERT INTO @Table (DateVal,Amount) SELECT '02 Jan 2009', -2540.500
INSERT INTO @Table (DateVal,Amount) SELECT '02 Jan 2009', 2540.500
INSERT INTO @Table (DateVal,Amount) SELECT '02 Jan 2009', -3800.000
INSERT INTO @Table (DateVal,Amount) SELECT '03 Jan 2009', 3800.000
INSERT INTO @Table (DateVal,Amount) SELECT '04 Jan 2009', 500
INSERT INTO @Table (DateVal,Amount) SELECT '05 Jan 2009', 1000

SELECT  * ,
     (SELECT SUM(Amount) FROM @Table WHERE ID <= t.ID) RunningTotal
FROM    @Table t