Passing a list to a TSQL 2008 Stored Procedure

Question

In MSSQL Server 2008 is there a way to construct the flowing as a stored procedure where the ... is passed in as a parameter. And not have to have a "separating" stored procedure or function which splits a csv and returns a table?

select *
from 
    atable
where 
    atable.id in (...)

Answer 1

Use a table valued parameter. Here's how to use them from ADO.NET.