capnhector (10/8/2012)
Well i have an answer but im going to ask what have you tried?
I got it
DELETE temp
FROM (
SELECT
ROW_NUMBER() OVER(PARTITION BY x.cStudentId,x.dtEnrollmentDate ORDER BY dtEnrollmentDate asc ) AS DSeq,
x.*
FROM #temp1 x) temp
WHERE DSeq not in (5,10,15)