in clause in stored procedures

How to pass arguments to in clause in sql server stored procedures?

Search for: How to pass arguments to in clause in sql server stored procedures?

Here is some discussion on stack overflow

Suggestion is to use the split function into a temp table and use the temp table as the target of in clause. Now I remember. It has been a while.