Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 CSV in Sproc for WHERE IN Clause

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-01 : 07:33:50
James writes "I've read your two posts on passing CSVs to Procs, but I only need to pass a CVS list to do a WHERE IN Query. Do I really have to go to all that trouble (parsing an array) when I just want it to look in the varchar string I send it?"

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-07-01 : 10:19:24
Did you read this entire thread?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830

The "trouble" is a creating a 1-time UDF that you can re-use over and over in all of your databases, and using it is pretty simple.

- Jeff
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-01 : 10:49:17
Thanks Jeff, I couldn't find...have to bookmark it...



Brett

8-)
Go to Top of Page
   

- Advertisement -