Must agree with Sean and Dwain.

Either pass in separated values and split the strings to a temporary table/table variable and join to that, or if you feel comfortable pass in a tvp and use it directly in the join.

IN righfully sucks with parameters.... IN also with large quantities of values tends to suck on performance.

IN is nothing more than shorthand for multiple OR = 's tests.... enough of those will choke a query.