nabajyoti.b
SSCrazy
Points: 2177
More actions
July 1, 2010 at 12:00 pm
#74071
can we have a piece of statement to delete all the duplicate rows for tables?
Many thanks..
Dan.Humphries
SSChampion
Points: 12125
July 1, 2010 at 12:50 pm
#1187858
Here is an article with many different solutions for duplicate records. it is hard to say which is the one you are looking for.
http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply