Question

[Brandon E Hofmann]

Is it possible to have one stored procedure reference a result set
generated by another stored procedure that it called?

For example:

sp_2 calls sp_1 to put a result set in a temporary table

sp_2 then does a join with the same temporary table created by sp_1 for a
final result set

I have a common stored procedure that determines access security and is
used by subsequent stored procedures.

Please let me know.

Thanks,

Brandon