Home Forums SQL Server 2012 SQL Server 2012 - T-SQL how to get this year and last year totals in tow separate columns RE: how to get this year and last year totals in tow separate columns

  • June 19, 2014 at 8:12 pm

    #1723450

    SELECT SUM(CASE WHEN fd.CalendarYear = '2013' THEN [Sales (LCY)]) 2013,

    SUM(CASE WHEN fd.CalendarYear = '2014' THEN [Sales (LCY)])2014

    FROM [$Cust_ Ledger Entry] cle

    LEFT OUTER JOIN dw.dim.FiscalDate fd

    ON fd.CalendarDate = cle.[Posting Date]

    WHERE [Customer No_] = '10135'

    AND fd.CalendarYear IN( '2013','2014')

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server