Passing Multivalued Parameters in SQL Server 2008
One year after submitting this small article, SQL Server Magazine has finally published it. This article demonstrates how you can use table-value parameters (TVPs), a new feature in SQL Server 2008, to let you pass multivalued parameters from a report to a stored procedure.
The code can be downloaded from the SQL Server Magazine site or from here.