http://blogs.msdn.com/b/conor_cunningham_msft/archive/2009/06/03/conor-vs-dynamic-sql-vs-procedures-vs-plan-quality-for-parameterized-queries.aspxI received a question from a customer today about query plan choice for a parameterized query - specifically that different plans get picked based on where the plan is located, and sometimes one might be better than another.&#160; Apparently, for theiren-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/conor_cunningham_msft/archive/2009/06/03/conor-vs-dynamic-sql-vs-procedures-vs-plan-quality-for-parameterized-queries.aspx#9699353Thu, 04 Jun 2009 14:54:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:9699353Brian Tkatch<p>How about some samples Conner? Err.... the long version? :)</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9699353" width="1" height="1">