>And run it using EXECUTE() or sp_executesql. Remember that it'll be separate batch so it wouldn't be able to see any sproc variables.
How should I access the result? Should I output to a table? I want to have multiple output recordsets. What should I do?
If it's not broken, fix it until it is.
My Blog 
