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. ...

Very nice. Great sentiment.

Alas, there was another baseball related death today . . .

Robin Roberts Dies at 83; Led Phillies’ Whiz...

R.I.P. Ernie Harwell

I get the impression that Ozzie Guillen would like to do the same to his leadoff hitters! 😀