Want to add rows values to show in a new row

Hi Anurag

Try to use following concept
It will give you proper result

SELECT a.SrNo as Srno ,a.Months as Months, SUM(a.value) as Value into #temp FROM Tablename a WITH(NOLOCK)
GROUP BY a.SrNo, a.Months

Select aaa.srno, aaa.Months, SUM(b.total) as value from #temp aaa join #temp bbb on bbb.srno<=aaa.srno
group by aaa.srno, aaa.Months

Thanks
Please click on "Accept Answer" if it helps you

Thanks for the help Nayab.

But my problem changes suddenly

Want to add row data and GROUP the data by using SrNo and Months.

         SrNo        Months        Value
          1           Jan-2010        2
          1           Jan-2010        5
          2           Feb-2010        1
          2           Feb-2010        6
          2           Feb-2010        2
          3           Mar-2010        7
          3           Mar-2010        4

The result set should be like this:

    SrNo    Months         Value 
     1      Jan-2010         7     (Sum of Jan-2010 value)
     2      Feb-2010        16     (Jan-2010  + Feb-2010)
     3      Mar-2010        27     (Jan-2010 + Feb-2010 + Mar-2010)

Help on urgent basis.Ur help will highly appreciated
Thanks in advance

Regards
Anurag

hi Anurag,

is there a ID column which we can consider?