Home Forums SQL Server 2008 SQL Server 2008 - General app to match clients in the different databases RE: app to match clients in the different databases

  • October 1, 2014 at 2:08 pm

    #1749530

    onixsoft (10/1/2014)

    Lowell (10/1/2014)

    you are overthinking this if you think you need an app for that.

    no "app" is needed for this, as the data entry for any app that tried to do this

    is the same effort required for deciding the mapping criteria for as the query

    Thanks for SQL query, but it will not work, since name can be spelled with errors, or in different ways, i.e. Alex, Aleks, Alexandr, Alexander.

    For Alex vs Aleks we can use SOUNDEX, but not for Alex vs Alexander.

    don't join on names. try SSN and date of birth, or just SSN, and ignore names.

    if you have nay otehr columns that uniquely idnetify a person(email, drivers license number, etc) use that.

    don't bother trying to join on names.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!