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 4:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:15 AM
Points: 11, Visits: 22
Hi

When runing queries I keep geting the above error.

Does anyone know how to resolve this pls?

thanks
Post #1453409
Posted Thursday, May 16, 2013 4:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:10 AM
Points: 2,792, Visits: 4,874
philip.davy (5/16/2013)
Hi

When runing queries I keep geting the above error.

Does anyone know how to resolve this pls?

thanks


Can you post the code you are running?
Somewhere in this code you are using "Members.MemberID_", but your table Members (or table refereed by this alias) has no "MemberID_" column.


_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1453416
Posted Thursday, May 16, 2013 5:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:15 AM
Points: 11, Visits: 22
select
List_,
Description,
count(month(TimeClicked)) as MonthTimeClicked
from clicktracking_ with (nolock)
inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_
inner join lyrLookupCompletionStatus on lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID
group by
List_,
Description
Post #1453443
Posted Thursday, May 16, 2013 5:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:10 AM
Points: 2,792, Visits: 4,874
philip.davy (5/16/2013)
select
List_,
Description,
count(month(TimeClicked)) as MonthTimeClicked
from clicktracking_ with (nolock)
inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_
inner join lyrLookupCompletionStatus on lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID
group by
List_,
Description


Query you posted refers to the table with name "Members_"
Error shows "Members" - no underscore at the end.

Actually, you have a very strange naming convention...
Why do you add underscore at the end of some table and its columns names?




_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1453452
Posted Thursday, May 16, 2013 6:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 6,783, Visits: 12,893
philip.davy (5/16/2013)
select
List_,
Description,
count(month(TimeClicked)) as MonthTimeClicked
from clicktracking_ with (nolock)
inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_
inner join lyrLookupCompletionStatus on lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID
group by
List_,
Description


lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID

This will fail unless you have lyrCompletedRecips in your FROM list.


“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 #1453479
Posted Thursday, May 16, 2013 8:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:15 AM
Points: 11, Visits: 22
The naming convention was decided by someone else
Post #1453600
Posted Thursday, May 16, 2013 9:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 6,783, Visits: 12,893
philip.davy (5/16/2013)
The naming convention was decided by someone else


Have you figured out the query issues, Philip?


“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 #1453607
Posted Thursday, May 16, 2013 9:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:15 AM
Points: 11, Visits: 22
Sorry, afraid not

thanks
Post #1453612
Posted Thursday, May 16, 2013 9:11 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 6:29 PM
Points: 32,834, Visits: 14,975
I don't see it in the query, but as Eugene suggested, the error implies you had members.memberid_ in the query somewhere.

I'd double check that.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1453614
Posted Thursday, May 16, 2013 9:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 9:15 AM
Points: 11, Visits: 22
Yes I've corrected that
Post #1453618
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse