>Would the execution plan not be cached if the parameter changed? Remember I'm being told the exact opposite. That the SP would be faster no matter what. I know complex SPs may be faster.

I definitely remember reading once that SP can be slower compared to unchanged dynamic queries. SInce I read a lot, it may be just coincidence and it might have been a false text anyway...
>
>Trust me. I know how to apply m. I'm doing it that way just for consistency. It's my style, if you could call it that.

I do - that is what makes me ask. So I cannot cite you for my "style" of mDotting only when reading / passing variables. On closer viewing: even mDotting a local statement! Style Police! Get Him! <bg>

regards

thomas