title: MS SQL: Use a stored procedures result set in another query?
body: <p>I have a stored procedure I don't want to modify. It's rather large and complex, and I don't want to add any more confusion to it. </p>
  
  <p>So what I would like to do is have another store procedure that calls on the big one, and uses the result set to perform further selects / joins etc. </p>