title: Find changes from an audit table
body: <p>I have data in an audit table like below. <a href="http://sqlfiddle.com/#!18/08d90/1" rel="nofollow noreferrer">Fiddle 1</a>, <a href="http://rextester.com/JKJNHO97527" rel="nofollow noreferrer">Fiddle 2</a></p>
  <p><a href="https://i.stack.imgur.com/skjiU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/skjiU.png" alt="Audit Table" /></a></p>
  <p>I need to get updated columns and data details from this table.</p>
  <p>Expected Results is:</p>
  <blockquote>
  <p>Employee Name : from Jone to Jhone</p>
  <p>Employee Age : from 25 to 20</p>
  <p>Employee Name : from Jhonny to Jone, Employee Age : from 18 to 25</p>
  </blockquote>
  <p>How could I achieve this?</p>
  <p><strong>UPDATE</strong></p>
  <p>When a record get updated, I am inserting two rows in to audit table. First record as <code>Old(auditDataState)</code> with data before the update and Second record as <code>New(auditDataState)</code> with updated data.</p>
  <p>So each update has two records in audit table as <strong>Old</strong> and <strong>New</strong> with old and new values.</p>
  <p>I need to get updated data from the audit table based on <code>updateColumns</code> in audit table.(I am storing what columns get updated in updateColumns column).</p>
  <p>I don't need to first row to be <code>Employee Name : from Jone to Jhone</code>. Just need to identify updated values.</p>