title: SQL Column and value to key & value
body: <p>I want to turn the record from an SQL query that looks like this...</p>
  
  <pre><code>FirstName   Amount  PostalCode      LastName    AccountNumber
  John        2.4     ZH1E4A          Fork        857685
  </code></pre>
  
  <p>to a key value pair that looks like this...</p>
  
  <pre><code>Key              Value
  
  FirstName        John  
  Amount           2.4
  PostalCode       ZH1E4A    
  LastName         Fork        
  AccountNumber    857685
  </code></pre>
  
  <p>And I want to do it all within SQL.  I have looked at the pivot example but I am not sure that it will work for this.  I know I could use temp tables, union but I am hoping for a more elegant solution.  Anyone have a suggestion?</p>
  
  <p>Thank you,
  Paul</p>