title: SQL Server 2008 R2 split one row of results into two rows
body: <p>In simple terms the table (t1) looks like this:</p>
  <pre><code>id     hours    dollars
  -----------------------
  abc     4         40
  </code></pre>
  <p>I'd like to get results from the table that looks like this:</p>
  <pre><code>abcHours      4      0
  abcDollars    0      40
  </code></pre>
  <p>Thanks</p>