Deduping DB

Jun 17, 2004

I have an Sql database with several tables. It has about 75,000 records in it but also has a lot of dupes. Can anyone help me with a script to isolate the most possible dupes? One of the most common things I'm seeing is mispelled names.
Thanks.

View 5 Replies


ADVERTISEMENT

Deduping 20 Files In Certain Order

Sep 30, 2013

I have 20 files to dedupe in a certain order, I was going to build a match key based on surname and 6 characters of address line 1 but any script to run the dedupe based on the match key and by a unique keycode for each file?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved