>While, I would agree. In our case, we are query columns like ZipCodes. There maybe many dozen of them. Besides, the SP are used only once every month or two.
>
>But thanks for the feedback.
If you have a chance to re-write this code, I suggest you to do this. Because even if this is used once in a month, when it's used, it is doing too much extra stuff and slow this query down significantly.
If it's not broken, fix it until it is.
My Blog