Nah. My knowledge of T-SQL ends with "SELECT * FROM tablename" :-}
Happy New Year.....


>Otherwise do you have any other questions for the article? <s>
>
>>Can't accept that :-}
>>"Susan Smith", "Joe Smith" , "Alex Walker" - OK.
>>"Uri Pearl" - hmm, maybe.
>>"Terry Thurber" - No (since he is a real [presumably] person who used to post on this forum) ?
>>
>>>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