title: How to insert data to temp Table in stored procedure with another procedure?
body: <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>