Previous,Cummulative,Current month data in SQL

See more:

SQL-Server

SQL-Server-2008

, +

Hi Guy's..

I executed my SP , one of the column returns the values like below..

Material_Qty	Planned_Date
100	        2012-11-13 00:00:00.000
100	        2012-12-13 00:00:00.000
100	        2013-01-24 00:00:00.000
100	        2013-02-13 00:00:00.000
100	        2013-03-21 00:00:00.000
100	        2013-04-18 00:00:00.000

Now, my question i want to add 3 more column's like previousmonth, CummilativProgress upto previous month & current month..

I want to display the quantities related that 3 column's.

EX:

Previous_month Qty------100 2013-01-24 00:00:00.000
cummunlativeprogress--- 300 11,12,01 month's
currentmonth ----- 100 2013-02-13 00:00:00.000



How to achieve this can any help regarding this ....