Insert Data in temparary Table Throw execute Sp inside sp

Question

Hello
I have insert data into temperary table throw execute another stored procedure,

--exec SP_Test_Table 1
ALTER procedure SP_Test_Table
@ID bigint
as

create table #Temp(id int,name varchar(10),contactNo varchar(100),pincode varchar(100), city varchar(100))

select * into #temp from exec SP_Test_Table2 @ID

select * from #Temp

Felipe Ramos · Answer

I would suggest to use a variable table instead and instead of doing select * into DECLARE @VTable TABLE ( id int name varchar(10) etc. ) Insert Into @VTable (Exec exec SP_Test_Table2 @ID)