Home Forums SQL Server 2008 SQL Server 2008 - General Record linkage advice required– Long read (YOU HAVE BEEN WARNED!) RE: Record linkage advice required– Long read (YOU HAVE BEEN WARNED!)

  • August 1, 2012 at 1:42 am

    #1520112

    Abu Dina (7/31/2012)

    Northwest UK yes 🙂 I will PM you.. seriously you deserve drinks for all this help!!!!!

    I've made the change and the function is working better now. 🙂

    Going to play around with this more and will report back again tomorrow.

    Once again, thanks so much for your efforts I really appreciate it.

    Have a good evening.

    p.s.

    Sorry I must have PMed you 3 times already by mistake. The sent folder doesn't get updated with sent messages then :rolleyes:

    We're all volunteers here, but thanks!

    When you're ready you will probably need an explanation of how this function works - a good place to start would be one of Jeff Moden's tally table articles.

    “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