Use resultset from sproc in select statement or in another sproc

[Ole Gammelgaard Poulsen]

Hi,
I have a stored procedure, sproc1, that returns a resultset by issuing a SELECT. I'm now making another sproc that needs some of the data produced by sproc1. How can I obtain that data returned as a resultset from sproc1?

I've tried things like

SELECT 'testing', (CALL sproc1(123));

But it doesn't work and omitting the CALL does neither as it's not a function but a procedure.

I would really like to avoid using a temp table and changing sproc1.

What can I do?



Edited 1 time(s). Last edit at 04/04/2008 04:30PM by Ole Gammelgaard Poulsen.