Re: Running total query.

These things have to be done eiher by a stored procedure or by the report generator.

Michael Rothwell wrote:

> Has anyone come up with an easy solution to get running balances in a
> query?
>
> If I have a table tA that has columns c1 number (pk), c2 number, c3
> number
>
> I would like a query that returns the prime key ( c1 ) , c2, c3, and a
> running total of prior running total + c2 - c3
>
> c1 c2 c3 running total
> ------- -------- --------- ---------------
> 1 500.00 0.00 500.00 ( 500 + 0 = 500 )
>
> 2 0.00 450.00 50.00 ( 500 + 0 - 450
> = 50 )
> 3 200.00 150.00 100.00 ( 50 + 200 - 150 =
> 100 )
>
> Thanks for any input.
>
> Michael

--
-------------------------------------
Mike Schuler
http://www.dbsurfer.com
sponsors of http://www.sqlschool.org
Voice (604)926-2676