Home Forums SQL Server 2008 T-SQL (SS2K8) Assign next aviliable column values RE: Assign next aviliable column values

  • October 2, 2014 at 8:58 am

    #1749703

    Maybe...

    SELECTCity,

    StuStatus,

    CurrentValue,

    COALESCE(NULLIF(week1,0), NULLIF(week2,0), NULLIF(week3,0), NULLIF(week4,0)) AS Week1,

    COALESCE(NULLIF(week2,0), NULLIF(week3,0), NULLIF(week4,0)) AS Week2,

    COALESCE(NULLIF(week3,0), NULLIF(week4,0)) AS Week3,

    Week4

    FROM #StuDetails;