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

Would you please provide more information about what you're trying to achieve?

Selects created in the SP are returned back to the caller.