For me every name is just random with fake address....

>Hi,
>
>I can't help wondering why the name 'Terry Thurber' crops up in the sample data ?
>
>>Hi All,
>>
>>Here is another way of how to remove duplicate records in a smart way in MS SQL. Once you have found your duplicate records, you face the problem of merging multiple records into one without losing any data.
>>
>>This article takes care of this problem:
>>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx
>>
>>Regards,
>>
>>Doron
>>
>>http://www.dfarber.com