In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go.

Try putting "SET NOCOUNT OFF" at the beginning of your stored proc (after the "AS"). The will prevent SQL Server from returning the number of rows returned by each SELECT statement.