Click here to Skip to main content
15,870,297 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Proj    ID Desc  Plan_date    Qty  Prev_Month   Cumulative    Prev_Cumulative    Curr_Mon 
O11001   1 Pile  NULL         NULL  NULL          NULL           NULL             NULL 
O11001   1 Pile  2013-01-01   200   0             700            700               0 
 
O11001   1 Pile  2013-02-01  -100  -100           600            600               0 
O11001   1 Pile  2013-03-01   100   0             700             0               100


this is my result set i want to display prev month details , and current month details and cumulative upto prev month.

Observe the 2 & 3 rd line of result set i have a cumulative upto prev_month is 600...

How to display this ,

In some case's i don't have feb-13 records in that case i want to display the jan-13 records ...

How to achieve this ....

Any help out of this ....

thanks in Advance....
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900