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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-15 : 12:09:32
|
| Don writes "I am trying to create a stored procedure that uses a paramter with multiple values. The parameter is then used in a selet statement. The data I am passing into the parameter is a string type. I then want to use that parameter with a "IN" clause. What is the best way to go about doing this? It looks like I need to send an array of data as the parameter . I get lost after that. I tried building a string separated with commas, but that did not work. I have searched books online and your site but found nothing so far.Example of sp...psp_GetClassIDs@ClassIDs varchar(1000)select Rights from ClassIDs where ClassID in(@ClassIDs)Thanks in advance.Don" |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Using using multiple values in a parameter 