I use the T4 template processor provided freely in VisualSudio for this. It is much more flexible and easier to read. Also, I can point it to a whole database...

My hobby is drumming and I would without a doubt love to play drums for a living and do database stuff as a hobby. But I have to have both.

Thank you all for some great ideas. The output clause is soooo close to what I need, but not quite. Of the solutions offered:

1) I can't use the switch because...