title: UNION the results of multiple stored procedures
body: <p>I have a stored procedure I need to call several different times passing in different paramaters each time. I would like to collect the results as a single dataset. Is something like this possible ...</p>
  
  <pre><code>exec MyStoredProcedure 1
  UNION
  exec MyStoredProcedure 2
  UNION
  exec MyStoredProcedure 3
  </code></pre>
  
  <p>I tried using the syntax above but got the error ...</p>
  
  <pre><code>Incorrect syntax near the keyword 'UNION'
  </code></pre>
  
  <p>The stored procedures I am dealing with are pretty complex and sort of a "black box" to me, so I cannot get into the definition of the stored procedure and change anything. Any suggestions on how to gather the results together?</p>
  
  <p>I am using SQL Server 2008 R2. Thanks for any help.</p>