"Dynamic Stored Procedures" is a Stored Procedure that uses dynamic sql instead of traditional tsql. You have to be careful here because you may not be as effective in retrieving data. Should you choose to use dynamic sql you should use the sp_executesql function, as it allows parameters and execution plan reuse.