J-F Bergeron (6/3/2010)

---

Good, you might want to post the parcel of code if someone else is looking for the same answer?

And we might review some of it, maybe it can...

GOT IT TO WORK!!! I set it up to pass the parameters rather than appending them to the string. It works like a champ!

Thanks for your help, everyone!

J-F -- yes, this is helpful! Before I read your post, I actually did manage to get my SP working properly using dynamic SQL. However, as you mentioned,...

I just found sp_executesql in BOL.

I'm going to mess around with this a little. If I get anywhere with it, I'll be sure to post whatever solution I conjure...

J-F Bergeron (6/3/2010)

---

I really think you should use Dynamic SQL, for handling those special cases. And by the way, you will get a better performance than when using a "Catch...

nabidavid (6/3/2010)

---

Try this:

select * from #NameList

where (ISNULL(@BySpecID, '') <> '' AND ISNULL(@ByOfficeID, '') <> '' AND Name like @ByName and City like @ByCity and County like @ByCounty)

or (ID =...

nabidavid (6/3/2010)

---

Am I misunderstanding you, or would this not work:

select * from #NameList

where (ISNULL(@ByID, '') <> '' AND ISNULL(@BySpecID, '') <> '' AND ISNULL(@ByOfficeID, '') <> '' AND Name...

As promised, here's the link to my new thread.

I thought about that, but that could get messy.

I'm working on putting...

Thanks for the assist; unfortunately, it didn't work for me. (Sorry, I should have been a little more specific; my fault.)

Here's my scenario: I wrote a SP, and I'm...

Wow, two major stories on the same day: perfection lost on a blown call, and a future Hall of Famer calls it a career.

Hey Dan, anything to report on this?

Haven't heard from you in a while, so I was just wondering!

Against Tampa Bay, no less. Looks like the Rays are...

Here's another commentary by Doug Glanville[/url]. This one might even be somewhat appropriate for SSC, since he talks about information overload.

I actually thought this was a great question, because it made me think. I looked at my choices and said to myself, "okay, let's say I'm processing this. ...