Home Forums SQL Server 2008 SQL Server Newbies SELECT question RE: SELECT question

  • December 11, 2013 at 6:54 am

    #1672608

    gary.morey (12/11/2013)

    The SSN is stored as a MD5 hashed value.

    The combination of SSN, PKT and FICE_NBR in table A does not have a match on the combination of SSN, PKT and FICE_NBR in table B.

    You were probably expecting matches, Gary. Can you post the query you used?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden