You might want to read through this post.

I found it helpful.

On the second page Jane posted an excellent standards document.

http://www.sqlservercentral.com/Forums/Topic566838-146-2.aspx

Why is it wrong to convert it to a table?

OK. That works. But it's still a lot slower. For four elements it was 16 ms. Joining to the table was 3 ms.

upperbognor (10/23/2008)

---

I've also seen this approach taken when looking for GUID's in a input list of GUIDs. This method looks up every value in the table in your list...

You can use a function to split the CSV parameter into a table, and then join to that table.

There are many different functions out there that will perform the split....

That is quite a generalization. If you are reporting off of...

It really...

Garadin (10/16/2008)

---

There definitely wouldn't be any manual typing in. It would all be check boxes or drop downs. However, because it's on the internet, I'm not necessarily happy...

Garadin (10/13/2008)

---

I was kinda hoping you'd come to that conclusion :P.

We'll likely be generating a dynamic column list for the final select, as...

Thanks! That clarified a lot.

I'm still a little confused about how the query plan works.

Here's what I thought:

There is one query plan per stored procedure. When the query is run an execution context is...

GilaMonster (10/16/2008)

---

Sure. This is the classic example

CREATE PROCEDURE AllOrSearch (

@SomeCode VARCHAR(30) = NULL

)

AS

IF @ID is null

SELECT * FROM SomeTable

ELSE

SELECT * FROM SomeTable WHERE SomeColumn = @SomeCode

If...

Can you please elaborate on this? When...

You mentioned earlier that you had tried to create a cross tab report, but were unsuccessful.

Can you post that code here?

Also, are you allowed to use dynamic SQL from inside...

That's strange. I copied & pasted the code straight from the forum. It's not giving me...