Christine Sun (8/11/2010)

---

I copied the code from your post and tried to run to better understand your logic.

However, I was stuck in the first piece (the loop version).

It seems you...

Eric Russell 13013 (8/11/2010)

---

When I am developing a stored procedure for reporting purposes, something that is driven by one or more sets of parameters, the parameters are typically contained in...

Jay Hopping (8/11/2010)

---

oh, I was never pushing xml so much as saying it is possible in 2k. The only point I made about the article was that you could...

Jay Hopping (8/11/2010)

---

dbuendiab (8/10/2010)

---

Hi, Jay:

You're right, I didn't remember OPENXML. Still I would not switch to a XML-formed parameter passing for several reasons - being the main the way users...

Patibandla (8/11/2010)

---

Really a very nice article to spare with. But , In case of tables containing large amounts of data , i think it's not a good practice to use...

Jeff Moden (8/10/2010)

---

You know, it's really odd that you say that. It's really odd that ANYONE would say...

For me an important point is to protect the user and the data and that lack of validation certainly does nothing to teach the user of his/her mistake nor protect...

CirquedeSQLeil (8/10/2010)

---

Thanks for the article.

I think one must be careful about the string parsing method used. I don't believe there is a one size fits all method for all...

jhood (8/10/2010)

---

I see what you are saying Jeff, but would you want to do validation if the application did not allow the end user to send invalid data? perhaps using...

Jay Hopping (8/10/2010)

---

dbuendiab (8/10/2010)

---

jcboyer-1091017 (8/10/2010)

---

I have been using an XML string to achieve the same results. Not sure that it is faster, but it is quite flexible as:

EXEC sp_xml_preparedocument @idoc...

janusz pazgier (8/10/2010)

---

Nice article to provide help for parsing delimited values, but I like better XML version provided by some user in the comments which is simpler but maybe more...

I'm a devote from Erland's work, and it makes me happy to admit I personally had his help...

Yes, but as far...

jcboyer-1091017 (8/10/2010)

---

I have been using an XML string to achieve the same results. Not sure that it is faster, but it is quite flexible as:

EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLParameters

insert into...

steveplate (8/10/2010)

---

I wonder how this performs if the table you are searching is 20K+ rows. It seems that this might be faster only for really small tables such as...