>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?
The original question only lists 3 parameters in an SP. How you're going to loop parameters in T-SQL?
If it's not broken, fix it until it is.
My Blog