Home Forums SQL Server 2005 Development Delete Duplicates from table with no identity column RE: Delete Duplicates from table with no identity column

  • September 25, 2009 at 8:43 am

    #1058496

    you need to use the ROW_NUMBER() function

    by using the ROW_Number function every row will have a different row id.

    I personally never used it but I saw my ex-colleague use it.