SQL Server : Insert second result table of a stored procedure into dynamic temp table

Viewed 94

For everyone understanding, I am explaining my requirement simply

I have a stored procedure called 'REC_VENDOR_SELECT'. It returns two tables as result.

Now, I want to insert the second table rows (returned by stored procedure) into a dynamic temp table.

I could see some solutions but those are for inserting the first table into temp table. But I want to insert the second or nth table of the stored procedure result.

0 Answers
Related