title: Rotate one row with column names
body: <p>I have the following problem: I have one row of data, and I would like to rotate it with then names of the colums.</p>
  
  <pre><code>Collnames:     a    b   c    d
                 0   NULL 1    0
  </code></pre>
  
  <p>And i woluld like to have The folowing:</p>
  
  <pre><code>Collnames  Data
  a          0
  b          Null
  c          1
  d          0
  </code></pre>
  
  <p>I made a solution for this, but its using dynamic SQL with a cursor, and I'm not proud of it. Is there a more elegat way to solve this problem?</p>
  
  <p>Thx</p>