SQL Server SP - Pass parameter for "IN" array list?

Question

Is there a way to pass the array of values to the IN section of a SP as a single paramter for SQL Server 2005?

Ex: Select * from MyTable where ID IN(@MyValueArray)

Answer 1

see here: http://www.sommarskog.se/arrays-in-sql-2005.html#CSV