Hi,
You can insert result of a stored procedure to temp table using below way:
Insert into #Temp
(
Col1,
Col2,
Col3
)
Exec A
Please make sure to have matched number of columns in stored procedure result and columns which are there inside insert statement.
If you execute on the above way and if stored procedure "A" will return 3 tables then it will combine result of all the 3 tables.
I am not sure is it possible to insert only second table of the result. I think it is not possible.
Please let me know if you have any concern or query on this.
Thanks
Advay Pandya