SELECT Q1,[Hour]
FROM
(
SELECT Q1,ROW_NUMBER() OVER (PARTITION BY DATEPART(hh, SurveyDate) ORDER BY SurveyDate) AS Seq,
DATEPART(hh, SurveyDate) AS 'Hour'
FROM hrc_survey_results_2
WHERE (businessline = 4)
)t
WHERE Seq<=5
ORDER BY DATEADD(dd,DATEDIFF(dd,0,SurveyDate),0), [Hour],Seq

quote:

---

Originally posted by sergeant_time

@visakh16,

Irecieved this error code when I ran it. I am using SSRS 2008

The OVER SQL construct or statement is not supported.

---