title: Generic procedure to perform SCD in sql
body: <p>I have 2 tables in mssql server.I can perform scd through custom insert/update/delete and also through Merge statement.</p>
  
  <ul>
  <li><a href="http://chrisjarrintaylor.co.uk/2012/07/03/ssis-scd-vs-merge-statement-performance-comparison/" rel="nofollow">Awesome Merge</a></li>
  </ul>
  
  <p>I want to know that is there any generic procedure that could  server the purpose. we just pass it 2 tables and it should porform the SCD. any option in SQL server 2008?
  Thanks</p>