Menu
I have a stored procedure that, ending with a SELECT, returns a recordset. I can call it within anoher stored procedure like this:
EXEC procedure @param How to get the returning recordset? Thanks
438
If you are trying to call the procedure get_manager_details inside test_procedure then you first need to create the test procedure. Add create or replace procedure test_procedure . Then after creating the test_procedure you can execute it in an anonymous block which will call the get_manager_details procedure.
You can create a temp table and then use INSERT INTO #MyTable EXEC procedure @param.
There are some other techniques listed here.
141
AFAIK, you can't. What you probably want to do is use a function for your first (or both) procedures. Functions can only return one thing, but they can return a table. Stored procedures can return multiple results, but not to other functions/stored procedures.
e.g.:
CREATE FUNCTION [dbo].[fn_GetSubordinates] ( @sPersonID VARCHAR(10), @nLevels INT ) RETURNS @tblSubordinates TABLE ( Person_Id VARCHAR(10), Surname char(25), Firstname char(25) ) AS BEGIN ... If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
