Home Forums Testing Center SQL Server Security Skills sum all records over 35 weeks Stored procedure or SSRS RE: sum all records over 35 weeks Stored procedure or SSRS

  • October 20, 2009 at 4:06 am

    #1068051

    I've tried to simply it...but get an error saying Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near the keyword 'CASE'.

    SELECT COUNT(NHSNo) AS [patientvol]

    CASE WHEN DATEDIFF(Week, ReferDt, GETDATE()) - PLoW > 35 THEN '35+' else '' End

    FROM [18WeekPTL]

    WHERE (Spec = 'ophthalmology') AND (Event IN ('WaitTimeOngoingWL', 'WaitListSOT')) AND (ClockPause <> 'Yes') AND (DATEDIFF(Week, ReferDt, GETDATE()) - PLoW > 35)