>>The dynamic SQL is 2 times faster than the SP. Can you guys confirm this?
>
>The benchmark rings a bell, but I have no link / reference at the moment. AFAIR the gist was, that on identical dynamic queries (at least) the whole execution plan is cached, whereas with SP the parameter is always "inserted" - but they wanted to optimize further. So perhaps a different [better?] test would be to have lnPercentage change inside the loop.
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.
> And since when are you mDotting the left side of assignments as in
>m.lnPercentage = 30
>m.lnElapsed = seconds() - m.a
??
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.