title: Combining Result Sets that Use Unions
body: <p>I have queries that use unions and I want to combine the queries into one result set.  Here is the sample query.  It returns two results sets.  I want to combine them into one.  Thanks!</p>
  
  <p>QUERY 1</p>
  
  <pre><code>SELECT COUNT(*) as 'Have you taken an interest/vocational assessment - Pre'
    FROM YESSCAYouth
  WHERE Assess2Pre1 = 1
  UNION
  SELECT COUNT(*)
    FROM YESSCAYouth
   WHERE Assess2Pre1 = 2
  UNION
  SELECT COUNT(*)
    FROM YESSCAYouth
   WHERE Assess2Pre1 = 3
  UNION
  SELECT COUNT(*)
    FROM YESSCAYouth
   WHERE Assess2Pre1 = 1 or Assess2Pre1 = 2 or Assess2Pre1 = 3
     AND Assess2PreDate BETWEEN CAST('01/01/2012' AS DATETIME) AND CAST('12/31/2012' AS DATETIME)
  </code></pre>
  
  <p>QUERY 2</p>
  
  <pre><code>SELECT COUNT(*) as 'Have you taken an interest/vocational assessment - Post'
    FROM YESSCAYouth
   WHERE Assess2Post1 = 1
  UNION
  SELECT COUNT(*) 
    FROM YESSCAYouth
   WHERE Assess2Post1 = 2
  UNION
  SELECT COUNT(*)
    FROM YESSCAYouth
   WHERE Assess2Post1 = 3
  UNION
  SELECT COUNT(*) 
    FROM YESSCAYouth
   WHERE Assess2Post1 = 1 or Assess2Post1 = 2 or Assess2Post1 = 3
     AND Assess2PostDate BETWEEN CAST('01/01/2012' AS DATETIME) AND CAST('12/31/2012' AS DATETIME)
  </code></pre>