Home Forums SQL Server 2008 SQL Server 2008 - General Retrieve Data with condition RE: Retrieve Data with condition

  • November 5, 2012 at 5:14 am

    #1555982

    What about

    SELECT USERID, 'Monthly' as [PERIOD], SUM([MONTHLY] As [PERIOD_TOTAL]

    UNION

    SELECT USERID, 'Quaterly' as [PERIOD], SUM([Quaterly] As [PERIOD_TOTAL]

    UNION

    SELECT USERID, 'HealfYearly' as [PERIOD], SUM([HalfYearly] As [PERIOD_TOTAL]

    UNION

    SELECT USERID, 'Yearly' as [PERIOD], SUM([Yearly] As [PERIOD_TOTAL]

    HTH,

    B