http://www.sqlservercentral.com/Content tagged T-SQL, Advanced Querying, Stored Procedures, Performance Tuning and Scaling posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring! http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/makingdynamicqueriesstatic/672/2002/05/02http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/makingdynamicqueriesstatic/672/