title: How do I suppress results from multiple stored procedures
body: <p>I have a stored procedure sp_1 that calls another stored procedure sp_1_1.  </p>
  
  <p>I know how to suppress the results from sp_1_1 using <a href="https://stackoverflow.com/q/571670/67249">this trick</a>.  </p>
  
  <p>The real problem is that sp_1_1 itself also call another stored procedure sp_1_1_1 which ALSO returns it's results to sp_1_1!! </p>
  
  <p>I may not change either sp_1_1 or sp_1_1_1, and can only change sp_1.  </p>
  
  <p>The results returned to sp_1 are 2 recordsets, with the first from sp_1_1 and the second from sp_1_1_1.</p>
  
  <p><strong>SUMMARY:</strong>  </p>
  
  <p>sp_1  (Needs to suppress two recordsets returned from below)</p>
  
  <p>+---- sp_1_1 (returns its own results, then results from below)  </p>
  
  <p>+----------sp_1_1_1  (returns results)</p>