AFAIK, you cannot do this. If I am wrong, please correct me.
Maybe you should look at passing in a CSV or XML list as a single VARCHAR parameter, parsing the values, putting them in a temporary table, and joining.
Wow, deja vu. I just typed this same response about 15 minutes ago.
>What is the proper way to pass a list of values via parameter to an IN operator? We have tried the following as a query in the management studio with no luck. The error message returned is as follows:
>
>Msg 102, Level 15, State 1, Line 3
>Incorrect syntax near ','.
>
>
>
>
>declare @joblist as varchar(100)
>
>set @joblist ='006291','006411'
>SELECT * FROM jcprod where cjobno in (@joblist)
>
>
>
>
>Thanks In Advance
>
>Jeff Hibbs
>The Blencowe Group