How to insert data to temp Table in stored procedure with another procedure?
<p>I want insert data to procedure 2 AddTempData from procedure 1 AddID1. But i can't do it. </p>

<pre><code>create proc AddID1
as
begin
declare @TempData table
(
    ID int
)
insert into @TempData select P.Id from Product as P 
select * from @TempData
end

create proc AddTempData
as
begin
declare @TempDataID table
(
  IDTemp int
)
insert into @TempDataID exec AddID1 
select * from @TempDataID
end
</code></pre>