Great article, thanks for sharing. I've used similar constructs for flexible SSRS reports. I learned a few nice tricks, I particularly like the @debug and the line numbers, very nice.

Based on Celko's war on dynamic SQL, I wonder if you'll get a response here too. Surely that would be a mark of success 😉