I have a table "Atts" which holds a few values, there maybe duplicate entries. I need a stored procedure that will remove any duplicate entries.
This is the table
SELECT AttsId ,
Ordernumatts FROM dbo.Atts
any records which are identical after running the SP only one should remain, any records without duplicates should stay as is.