If you experience some difficulties with a stored proc that contains some dynamic SQL, or if you intend to design such a procedure that will be executed by BizTalk (or more generally the WCF-SQL adapter), maybe this article can help : http://geekswithblogs.net/S