capnhector (10/8/2012)
Well i have an answer but im going to ask what have you tried?
so far, i did
SELECT
*
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)
but when i try to wrote delete syntax then i got an error
so please help me to do this