• If you don't need to use dynamic SQL, don't use it.  It adds complexity and can be difficult to debug when there are problems.  This comes from experience as I find myself writing quite a bit of dynamic SQL where I work by the nature of the database and its design (or lack there of).