• There have been a couple of threads recently where a set of values is passed in via a single parameter. The query then does a charindex() in order to "parse" those separate values. That should work and you won't have to worry about extraneous parameters you won't necessarily use.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley