Dynamic SQL: Yea or Nay?

I’ve always been on the side of stored procedures in the classic debate over the merits of dynamic SQL.¬† In reality, I can only think of one good scenario where dynamic SQL at the application layer¬†should be used: programmatic batch...