>>>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
I'm not familiar with "table as output cursor" in SQL Server.
INSERT INTO #temptable SELECT FROM ...
--sb--