CODEWITHSUNDEEP
sqlsql-serversql-server-2005stored-procedures
Anshul
Anshul

Reputation: 645

How to get the stored procedure result set value

I create a stored proc A that calls another proc B, which returns a list of the result set.

How I can use these result set values in my proc A as I have to use this result set value one by one to pass to other part of the proc A.

Upvotes: 2

Views: 1190

Answers (1)

Prutswonder
Prutswonder

Reputation: 10064

You can perform an INSERT INTO to insert the results of the stored procedure into a (temporary) table. You can then use a select statement to process these results.

INSERT INTO SomeTableThatMatchesTheSproc
EXEC YourStoredProcedure;

SELECT * FROM YourTable;

Upvotes: 1

Related Questions