Can you use UDF instead? If not then you'll have to craete atemporary table in the calling SP and populate it in the called SP.

>how to have a #cursor return from executing anthor stored procedure.
>
>Thanks