Removing Duplicates
MS SQLEvery once in a while I'll load a temporary table up with data before I load it into a production table so I can do some manipulation of the data if needed. Today I was in the process of loading data into the production table when I noticed there were some duplicate entries in the data I was loading. In fact there were many duplicates. I did some searching and I found this code, it removes the duplicate records, leaving just one entry.
The code code was found at SQL Server Magazine's web site at the address below.
http://www.sqlmag.com/Article/ArticleID/21704/sql_server_21704.html
Hope this helps, I know I'll use it again.
Good Day,
Ryan
Loading....