I had a need to remove duplicate rows from a SQL Server table this morning and found this incredibly easy way to do so on the SQL Team site:
select distinct *
truncate table dup_authors
drop table #holding
SQL Team is a great site for finding solutions for those unusual queries that pop up from time to time.
Dan HounshellWeb geek, nerd, amateur maker. Likes: apis, node, motorcycles, sports, chickens, watches, food, Nashville, Savannah, Cincinnati and family.Dan Hounshell on Twitter