• 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!

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]