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
Loading
Felipe RamosPosted May 17, 2011, 10:43 AM
DECLARE @VTable TABLE
(
id int,
name varchar(10),
etc.
)
Insert Into @VTable
(Exec exec SP_Test_Table2 @ID)