>>>I see I have to write the SP completely. Ok.
>>>
>>>I certainly appreciate your input, but you didn't write the SP - I did, and both versions of it. You simply pointed out some mistakes, and I am gratefull for it. I didn't ask you or anyone else to write anything for me. Only to help me understand what was wrong. If you're not intersted in helping, then don't. Again, thanks for your input.
>>
>>Wow. I did point to your mistakes. The problem is you didn't understand me, so I had to correct what you wrote completely.
>
>Naomi, you having a bad day today? In Kevin's defense, your responses did come off pithy and pedantic. Please don't penalize me for saying that, this board (and my questions in particular :) ) need your responses and knowledge.
>
>Thanks for all your help in the past and in the future.

I thought my original response on the question was all that needed. Then I thought I explained that we don't need to pass constant parameters to the dynamic query and I guess it was not clear explained.

When I found that my last response was not yet enough, I did figure out the best way is to fix the whole code.