question

You can't create a procedure with dynamic parameters. A stored procedure's parameters are defined at the moment you create it and they can't change except by recreating the procedure. From the sounds of things, you need a dynamic t-sql statement. In order to use parameters with dynamic t-sql you're best bet is to use sp_executesql. [Here's a link to the documentation on it][1]. This would allow you to build a t-sql statement with parameters, defined on the fly, and execute it. This way, you have a chance at some plan reuse when running your statements. [1]: http://msdn.microsoft.com/en-us/library/ms188001.aspx