I hate Dynamic SQL. It's as lame as in-line SQL. So I lose sleep when I'm 'forced' to use Dynamic-SQL to solve problems. Oh... I'll use it in an absolute pinch, but after the 'pinch' is over I try flipping the problem on its head over and over to see if I can come up with a non-cheesy solution. That being said, a common place many people ...

define:idiom "An expression whose meanings cannot be inferred from the meanings of the words that make it up." In his Guru Book devoted to SQL Server Stored Proceedures (and other goodies), Ken Henderson addresses the practicality of using design patterns in SQL Server. As part of his introduction to the legitimate use of design ...