Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

The multi-part identifier "Members.MemberID_" could not be bound. Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 9:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 6,781, Visits: 12,888
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
Exploring Recursive CTEs by Example Dwain Camps
Post #1453620
Posted Friday, May 17, 2013 7:54 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, September 29, 2013 1:24 AM
Points: 429, Visits: 1,721
Maybe I'm missing something but perhaps all this procedure needs is to make sure the table and column names are enclosed in brackets ([]) due to the odd naming convention.

 
Post #1454017
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse