Posted by markc600 on 05/08/06 17:36

SQL Server 2005 doesn't support SUM()..OVER(ORDER BY..ROWS 4 PRECEDING)
However, you can do this


select FULL_CLASS_ID,STUDENT_ID,SESSION_ID,'Dropped'
from (
select FULL_CLASS_ID,
STUDENT_ID,
SESSION_ID,
MEETING - RANK() OVER(PARTITION BY
FULL_CLASS_ID,STUDENT_ID,SESSION_ID
ORDER BY MEETING) as Rn
from clsatt
where PRESENT='1') X
group by FULL_CLASS_ID,STUDENT_ID,SESSION_ID,Rn
having count(*)>= 4


Regards

Mark

• Next in forum: TRANSACTIONS in a WHILE LOOP. Flow Question
• Prev in forum: Using ADO AddNew and my simple trigger won't execute
• Thread view: Re: how to find conditions across rows (attendance)

[Reply to this message]