[
From SQL Server Magazine]
In the real world, you rarely need to know about only a portion of a set of data. If you want to look at data from a more complex angle, you'll need to use multivalued parameters.
This article demonstrates an approach for integrating multivalued parameters with SQL Server stored procedures.
The article continues at
http://www.sqlmag.com/Articles/ArticleID/102389/102389.html?Ad=1