Row_Number() function in SQL Server 2005 – Part II

(Muthusamy Anantha Kumar) In part I of this article, we saw how to generate row numbers and delete a simple single duplicate row. This article walks you through how to delete multiple duplicate rows. This article uses the new feature Row_Number() function, common table expression and the ANSI co-rel

Read More - Register for Free Membership