Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove duplicate records in a smart way in MS SQL server
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01531890
Message ID:
01531931
Views:
47
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform