title: Comparing two T-SQL tables for diffs
body: <p>I have two instances of the same database.  The first db represents data from today, the second data from 6 months ago.  I need to find differences for a subset of entries in a specific table.</p>
  
  <p>For entries with ids that are in both tables, I'd like to find a way to view only the rows that aren't identical.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks</p>