Home Forums SQL Server 2005 T-SQL (SS2K5) Get Monthly total in sp RE: Get Monthly total in sp

  • December 18, 2010 at 4:00 pm

    #1264406

    parthi-1705 (12/17/2010)

    ruwanwickrama (12/16/2010)

    I want to select all columns and get monthly total in my table.

    how am i do this...

    plz help me...

    Is this you are looking for

    Select Project ,Location,Itemtype,Sum(Amount) From mytable Group by Project ,Location,Itemtype,MONTH(Date)

    Thanks

    Parthi

    This will work as long as your data does not span more than 12 consecutive months.