title: SQL Server: display differences in columns between 2 rows
body: <p>I have a very large table (200+ columns) with 1000's of rows. I need to display differences in columns between 2 rows. I can load the 2 rows I need into a temp table, but I'm not sure how to proceed from there. </p>
  
  <p>For example (I’ll only use 5 rows here and just use generic names)</p>
  
  <pre><code>ID        | GName       | SName    | Add1         | Add2
  360111    | Billy       | Bob      | 1 Happy St   | Sydney
  360111    | Billy       | Bob      | 6 Sunny St   | Melbourne
  </code></pre>
  
  <p>What I want to be displayed is</p>
  
  <pre><code>Add1       | Add2
  1 Happy St | Sydney
  6 Sunny St | Melbourne
  </code></pre>
  
  <p>As these are the only differences between the 2 rows. Other times there will be no difference, or many</p>
  
  <p>Cheers</p>