We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

create proc p1 
as 
begin
  create table #tP (a int)
  exec p2
  select * from #tP
end
go 

create proc p2
as
begin
    insert #tP select 11111
end 
go 

exec p1
go