Script Download: Deleteduplicaterows.ziphttp://gallery.technet.microsoft.com/scriptcenter/Delete-duplicate-m-1-rows-ab1c9525
Some people ask for a script to delete duplicate rows and keep only one row in a table. This T-SQL script sample will show you by creating a new table TestTable to imitate your table and a temporary table #TempTable. All the duplicate data will be stored in the temporary table. After executed, it will generate 2 tables, one to show you the duplicate data and a table to show the final result.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery