By tag: PARTITION
Ban this user: Options
Please provide a reason for deleting this story
T-SQL query in Sql Server 2005 to Remove Duplicate Rows on table with/without primary key
The RANK and PARTITION features in 2005 are simply amazing. They make so many "classic" SQL problems very easy to solve.