Jitendra Patel

Jitendra Patel

  • NA
  • 149
  • 0

Insert Data in temparary Table Throw execute Sp inside sp

May 17 2011 10:18 AM
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




Answers (1)