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,...