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

I didn't imply, you did :) But how should I access the result set? If I want to join it with another resultset in the upper level SP?