>>>
>>>
>>>It's possible for any combination of parameters to be passed. How do I change the WHERE clause to handle this?
>>>
>>>Thanks
>>
>>Loop through the parms collection and build the where clause dynamically...
>
>I don't think running dynamic SQL is a good idea. If there are few parameters, using NULIF or ISNULL functions I would expect to be quicker.


If you read the question carefully, you'll see the following statement: It's possible for any combination of parameters to be passed. How do I change the WHERE clause to handle this?

Notice the "its possible for ANY COMBINATION OF PARAMETERS". How do you account for getting 1 or 5 or 15?