Hello There,
You may check this article that provides detailed examples of how to remove duplicate records.
http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx
It combines several values from several records into one good record.
Regards,
Doron
The Farber Consulting Group, Inc.