<div>
note: <br />
the EXEC() method of doing looks simpler, BUT has some side effects you should be aware of:<br />
* permissions to the tables used will need to be granted to the caller of the procedure and not the owner of the procedure<br />
* the execution plan might not be the same one<br />

</div>


note:
the EXEC() method of doing looks simpler, BUT has some side effects you should be aware of:
* permissions to the tables used will need to be granted to the caller of the procedure and not the owner of the procedure
* the execution plan might not be the same one


<div>
2 solutions in one! Angellllllllll's works very well and is more what I am looking for due to it not using dynamic sql. I have split the points across the two answers weighted on the one more useful to me. 
</div>


2 solutions in one! Angellllllllll's works very well and is more what I am looking for due to it not using dynamic sql. I have split the points across the two answers weighted on the one more useful to me.

<div>
<div class="content wysiwyg-content">
I have the list of elements seperated by commas that I am passing to a stored procedure that I want to pass in to an 'In' clause for the where statement. I have done this by hand before ' Where clientsid In (7,8,9)' etc but am stuck at trying to do this dynamically. I can pass the elements over in a string, say '7,8,9', but then I need to convert this to an integer. Is it possible to pass over the contents of an In clause dynamically? I 
</div>
</div>


I have the list of elements seperated by commas that I am passing to a stored procedure that I want to pass in to an 'In' clause for the where statement. I have done this by hand before ' Where clientsid In (7,8,9)' etc but am stuck at trying to do this dynamically. I can pass the elements over in a string, say '7,8,9', but then I need to convert this to an integer. Is it possible to pass over the contents of an In clause dynamically? I 

Passing the value for an IN clause to a stored procedure

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.