Share data between stored procedures

SQL Add comments

CREATE TABLE #tmp (…)
INSERT #tmp (…) EXEC @err = some_sp @par1, @par2 …

In your 2nd stored procedure, create a temporary table with the same column definitions of the output from 1st stored procedure, insert the output from 1st stored procedure into the temp table in the 2nd stored procedure and use it as you wish.

For more information…

Leave a Reply

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in