HELP. multipart identifier could not be bound

Question

Post reply

HELP. multipart identifier could not be bound

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

This is still going to give you trouble:

And (tEx.EventResults LIKE %)

needs to be

And (tEx.EventResults LIKE '%')

at very least

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 2

Maybe I'm just not looking deep enough but does anyone actually see anything in the dynamic SQL that actually requires it to be dynamic?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 3

You are right Jeff. Even i don't think the query needs to be dynamic. Making it simple might solve the whole problem.

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

Though it does seem to me that what this is really supposed to do is to just drop the NULL-valued clauses completely from the dynamic sql, rather than executing them, which probably would make it perform better.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Aloha SSC-Addicted Points: 450 More actions · Answer 5

I simplified the stored procedure and it works now.

Thank you all for your help.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

Glad we could help.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]