While We're on the Subject...

4 Guys from Rolla has a really great way of finding and deleting duplicate rows in a table. It doesn't require the use of temporary tables or long-winded procedures like some of the more common methods. If you run into this problem, remember who told you about the fix!

Read: http://www.4guysfromrolla.com/webtech/sqlguru/q051200-2.shtml