Hello All, I'm trying to find a method that will run on Data-sets of 100K rows to a million efficiently and have a relatively good match output. I know that nothing will be 100% but the more accurate the better.
Have you thought about buying a package, like Melissa Data, to do this task? Why re-invent the wheel?
Please post DDL and follow ANSI/ISO standards when asking for help.