Thanks to everyone who commented on parameterization in TSQL. It was a pretty eye-opening experience to see the lack of "extended" parameterization (beyond simple runtime values) being such a pain point for the users. I'll make sure your voices are heard when new language features are planned.

This posting is provided "AS IS" with no warranties, and confers no rights.