Thanks! Exactly what I was looking for!

Sean Lange (6/14/2012)

---

There are a few ways to do this. Here is one of them.

select * from

(

select *, ROW_NUMBER() over(partition by ID order by ModifiedDate desc) as RowNum from @test-2

)...

Anyone?

Thanks!

Only need to know one more thing, which of the "duplicate" records do you want to retain? For instance of the first two records, which is the one to...