How to use a result set returned by another stored procedure in a stored procedure

The most common processing process: 1. Creates a temporary table #tmp that is compatible with the return result set of the target stored procedure procedure_name (compatible, not necessarily the same). CREATE TABLE #tmp ([Columns_list]) 2. Executes the stored procedure and inserts the return result set of the stored procedure into the temporary table. INSERT into #tmp EXEC procedure_name @parameters_var
3. You can now use (filter, change, or retrieve) #tmp了. ^_^ SELECT @querystring = columns_list from #tmp
4. Don't forget to clear the temporary table at the end. DROP TABLE #tmp Original address: http://www.2cto.com/database/201210/162009.html