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).