>>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?
>
>You can create temp. table before you run dynamic SQL which in turn will store result recordset into that temp. table.
I see.
create table ...
call SecondLevelSP with this table as output cursor
If it's not broken, fix it until it is.
My Blog