How to find duplicate rows in SQL Server

Richard Lewis
I ran into this problem the other day at work with duplicate rows while trying to merge data from two separate tables into the same table. I couldn’t remember so I just ran a quick search using Google and came across the solution on a Microsoft knowledge base page. col1 col2 1 1 2

Happy Birthday Gogorichie.com

Richard Lewis
On July 9th 2002 Gogorichie.com was born. Here are some stats recorded during the last year. 3,318 unique visitors came to the site, as determined by typical behavior of browsers with a non-rotating IP address and including a projection of the true number of visitors with rotating IP addresses. The web site received 5,693 visits. A typical visitor examined 17.19 distinct files before leaving the site. A typical visit lasted for 6.