hmmm maybe over-engineered? Surely variable checking should be at presentation tier?

I've grown allergic to dynamic-SQL, tended to find it such a performance killer and generator of bugs in its own right.

While always recompiling may deliver better performance, would have thought this would be the exception rather than the rule.

I've arrived at the point of only using dynamic-SQL as an absolute last resort (and that equates to never at the moment )

Thanks for insight into another approach though 🙂