Hi,
How to get following output in SqlServer 2000.
My table is bellow
Create Table dailystock (
Date datetime,
Production numeric,
Sale numeric)
Required Output :
A B A+B C (A+B)-C
Date Op.Bal Production Total Sale Closing
-----------------------------------------------------------
01-04-02 Nil 35 35 10 25
02-04-02 25 55 80 80
03-04-02 80 66 146 20 126
04-04-02 126 10 136 136
05-04-02 136 10 146 10 136
06-04-02 136 136 15 121
Thanks.