title: Comparing two rows in SQL Server
body: <p><strong>Scenario</strong></p>
  
  <p>A very large size query returns a lot of fields from multiple joined tables.
  Some records seem to be duplicated.
  You accomplish some checks, some grouping. You focus on a couple of records for further investigation.
  Still, there are too much fields to check each value.</p>
  
  <p><strong>Question</strong></p>
  
  <p>Is there any built-in function that compares two records, returning TRUE if the records match, otherwise FALSE and the set of not matching fields?</p>