Gail's blog recommends using dynamic SQL
but our boss doesn't like it at all.
Is your boss SQL Server professional or just an idiot with a lot of ambitions?
For what you're trying to achieve, dynamic SQL is the best option!
So just tell your boss, if he wants good code, you better to follow the right direction, not the one you boss like or dislike. Sounds like kindergarten to me!