SELECT DISTINCT *
INTO #TempTable
FROM OriginalTable
TRUNCATE OriginalTable
INSERT INTO OriginalTable
SELECT * FROM #TempTable
Not knowing the structure of the table, but you may need to break this into pieces, or use a third staging table.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/