title: Dynamic SQL results into temp table in SQL Stored procedure
body: <p>The code is as follows: </p>
  
  <pre><code>ALTER PROCEDURE dbo.pdpd_DynamicCall 
  @SQLString varchar(4096) = null
  
  AS
  
  Begin
  
      create TABLE #T1 ( column_1 varchar(10) , column_2 varchar(100) )
  
      insert into #T1 
          execute ('execute ' + @SQLString )
  
      select * from #T1 
  
  End
  </code></pre>
  
  <p>The problem is that I want to call different procedures that can give back different columns.
  Therefore I would have to define the table #T1 generically.
  But I don't know how.</p>
  
  <p>Can anyone help me on this problem?</p>