Comments by foxyland (Top 2 by date)

I don't know about hard to debug, but in my case, I have a rule that if I found any SP too complex to follow/debug (say sp_One), than I've made it too general. Meaning that I have to create another SP to handle some 'jobs' that actually could've been handled by sp_One.

IMHO, as long as the programmer keep focus on the problem and not tempted to create a general-purpose-all-accepted-sp, Dynamic SQL is a powerful tool. As always with every power tool in the world, there is a message: "Use it wisely" :)


hth,
foxy