title: An insert exec statement cannot be nested
body: <p>Hello I have a proc called <code>Test_ProcA</code> and I want to call <code>Test_ProcB</code>. I created a temp table called <code>#temp</code> with matching names and data types returned by <code>Test_ProcB</code>.</p>
  
  <p>How do I insert the result set returned by <code>Test_ProcB</code> into <code>#temp</code>. When I try doing that I keep getting this error:</p>
  
  <blockquote>
    <p>An <code>INSERT EXEC</code> statement cannot be nested.</p>
  </blockquote>
  
  <p>Any ideas and suggestions on what needs to be done.</p>