title: Is it possible to execute nested stored procedure without waiting for return?
body: <p>I need to create nested stored procedure. In the following matter.</p>
  
  <pre><code>Create proc MyVoidProc 
  as
  Begin
      Waitfor Delay '00:00:05'
      Print 'This has been executed'
  End
  
  GO;
  
  Create Proc TestNestedSP
  as
  Begin
      Select * From sys.tables --Some select statement that needs to be returned
  
      Exec MyVoidProc  --This does not return anything.
  End
  </code></pre>
  
  <p>Is it possible to return the select statement from the <code>TestNestedSP</code> without waiting for <code>MyVoidProc</code> to be executed. <code>MyVoidProc</code> does not return anything but needs to be executed at the end of <code>TestNestedSP</code> because it needs to capture elements from the procedure that it is called from. <code>MyVoidProc</code> will take different time to execute, therefore I don't wait to wait for it. Just return what is important back to the user and finish processing the procedure without user knowing about it.</p>