title: How do I suppress the results from a stored procedure from within a stored procedure?
body: <p>I've got a stored procedure (we'll call it A) that calls another stored procedure (we'll call this one B). B includes a SELECT that I do not want to send back to the caller of A.</p>
  
  <p>Here is some really rough pseudocode, but it should get the idea across.</p>
  
  <pre><code>PROCEDURE A
      CURSOR
          CALL B -- I WANT TO SUPPRESS THE RESULTS FROM B
      END
      SELECT *
  END
  PROCEDURE B
      Do some interesting things
      SELECT *
  END
  </code></pre>
  
  <p>As you can see above, A calls B and B does some things that I want and returns results that I don't care about. Once A is done, it returns its own set of results.</p>
  
  <p>How do I suppress the results from B in A? I'm using SQL Server 2005. I would prefer not to make changes to B because it is working and more complex than I want to mess with.</p>