title: How to enforce particular order in UNION query
body: <p>What I'm after:</p>
  
  <pre><code>--heading--
  xxx 111
  xxx 222
  xxx 333
  yyy 111
  yyy 222
  yyy 333
  </code></pre>
  
  <p>The heading is a constant value and it needs to stay at the top. The numbers (111, 222, 333) are values selected from a table. The letters (xxx, yyy) are constant values. What I need is to have 3 'x' rows in a row, and then 3 'y' rows in a row. When I use UNION ALL I'm getting:</p>
  
  <pre><code>--heading--
  xxx 111
  yyy 111
  xxx 222
  yyy 222
  xxx 333
  yyy 333
  </code></pre>
  
  <p>This is what I have so far:</p>
  
  <pre><code>SELECT '--heading--' + 
  UNION ALL 
  SELECT 'xxx ' + Column1
  FROM Table1
  UNION ALL 
  SELECT 'yyy ' + Column1
  FROM Table1
  </code></pre>