>>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?

I didn't say that created recordset(s) will be affected and they are not.