title: TSQL: union results from two selects (procedures?)
body: <p>I have two procedures - two huge sets of selects with several sub-select and unions.
  I need to union results from these procedures and I still need them to exists separately.</p>
  
  <p>Something like that:</p>
  
  <pre><code>if @Param = 1 Then 
      PROCEDURE1
  if @Param = 2 THEN 
      PROCEDURE2
  if @Param = 3 Then
      PROCEDURE1 union PROCEDURE2
  </code></pre>
  
  <p>I read that it's impossible to have union on procedures and I can't use temporary tables.</p>
  
  <p>Any idea?</p>