[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