title: Split Multiple Columns into Multiple Rows
body: <p>I have a table with this structure.</p>
  
  <pre><code>UserID  | UserName  | AnswerToQuestion1 | AnswerToQuestion2 | AnswerToQuestion3
  1       | John      | 1                 | 0                 | 1
  2       | Mary      | 1                 | 1                 | 0
  </code></pre>
  
  <p>I can't figure out what SQL query I would use to get a result set like this:</p>
  
  <pre><code>UserID  | UserName  | QuestionName      | Response
  1       | John      | AnswerToQuestion1 | 1
  1       | John      | AnswerToQuestion2 | 0
  1       | John      | AnswerToQuestion3 | 1
  2       | Mary      | AnswerToQuestion1 | 1
  2       | Mary      | AnswerToQuestion2 | 1
  2       | Mary      | AnswerToQuestion3 | 0
  </code></pre>
  
  <p>I'm trying to split the three columns into three separate rows. Is this possible?</p>