title: Output additional headers in SQL SELECT statement
body: <p>Is there an more elegant solution to add certain headers to a SQL <code>SELECT</code> statement?</p>
  
  <p>For example, I have a dataset with the following:</p>
  
  <pre><code>A | B | C | D
  =============
  Y | 5 | 8 | Z
  X | 4 | 8 | Z
  </code></pre>
  
  <p>etc...</p>
  
  <p>In this case, the data isn't too important per se, however I would like to add related headers to the dataset, so the final output to look like:</p>
  
  <pre><code>Date Created: 1/1/11
  Date Ran: 12/1/11
  File Version: 123
  A | B | C | D
  =============
  Y | 5 | 8 | Z
  X | 4 | 8 | Z
  </code></pre>
  
  <p>All these will be internal tracking values already in the database, but I'd like to output them all as a single recordset to the final consumer.</p>
  
  <p>I've done something a bit like it with some <code>UNION ALL</code>'s but it's far from great.</p>