Home Forums SQL Server 2005 SQL Server Newbies Query to get Last month's data and current month's data RE: Query to get Last month's data and current month's data

  • December 10, 2014 at 8:56 am

    #1763821

    It's a crosstab:

    SELECT SUM(CASE WHEN prt_created = lastMonth THEN 1 ELSE 0 END) as lastMonthData,

    SUM(CASE WHEN prt_created = currentMonth THEN 1 ELSE 0 END) as currentMonthData

    FROM PARTICIPLES

    Hope this helps

    -- Gianluca Sartori