SQL Server 2005 -Удаление дубликатов

Вот нашел сегодня такой бесценный код:

;
WITH numbered
AS ( SELECT data, row_number() OVER ( PARTITION BY data ORDER BY data ) AS nr FROM @duplicateTable4
)
DELETE FROM numbered
WHERE nr > 1