Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove duplicate records in a smart way in MS SQL server
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01531890
Message ID:
01531931
Vues:
48
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform