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