title: Get the change log report from SQL Server
body: <p>I'm using this query :</p>
  
  <pre><code>SELECT 
      CT.SYS_CHANGE_VERSION, 
      CT.SYS_CHANGE_OPERATION, 
      EM.* 
  FROM
      CHANGETABLE (CHANGES [A_Table], 0) AS CT 
  JOIN 
      [dbo].[A_Table] EM ON CT.A_Primary_KEY1 = EM.A_Primary_KEY1 
                         AND CT.A_Primary_KEY2 = EM.A_Primary_KEY2 
                         AND CT.A_Primary_KEY3 = EM.A_Primary_KEY3
  ORDER BY 
      SYS_CHANGE_VERSION
  </code></pre>
  
  <p>I'm getting only the version which is changed to the table. I need to get the previous version and current version of the changed record(before changing and after changing of the record). Please do help me. TIA</p>