Home Forums SQL Server 2008 SQL Server 2008 - General The multi-part identifier "Members.MemberID_" could not be bound. RE: The multi-part identifier "Members.MemberID_" could not be bound.

  • May 16, 2013 at 9:18 am

    #1615864

    philip.davy (5/16/2013)

    Sorry, afraid not

    thanks

    If you are still interested in working it through, there are folks here willing to help.

    There are two or three remaining issues with the query;

    you have a reference to a table lyrCompletedRecips, in a join, which isn't in the FROMlist

    table lyrLookupCompletionStatus isn't joined to any tables in the FROMlist which will result in a cartesian product (too many rows)

    the aggregate probably won't generate the result you are expecting.

    “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