AmolNaik (6/13/2011)
Smart technique. But beware SET ROWCOUNT is set to be deprecated in the future releases, instead you could use TOP 1.An alternate method to remove duplicates is to use ROW_NUMBER() technique, basically ordering the resultset over the column phone number and then deleting row where row_number > 1, this will make sure that only 1 resultset is retained and any other repeating instances are deleted.
Thanks!
It'll also be much faster than the looping method. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.