title: Dynamic Table Insert TSQL: Insert records into another table where schemas are Mismatched
body: <p>In an effort to efficiently move records from one table to another I'm struggling to write a T-SQL stored procedure to accomplish this task in a generic manner.</p>
  <blockquote>
  <p><strong>Requirements</strong>:</p>
  <ol>
  <li>Needs to be generic so that the specific columns are NOT hard coded into the Stored Procedure.</li>
  <li>The only input parameters should be the names of the Source Table and Destination Table.</li>
  <li>All Records from Source are Inserted Into Destination</li>
  <li>For a given record we map over only the data from the matching columns from both tables</li>
  <li>Columns missing from the source table will receive their Default Values in the Destination Table.</li>
  <li>Data from any columns missing from the Destination table will simply be ignored</li>
  </ol>
  </blockquote>
  <p><a href="https://stackoverflow.com/questions/7401419/dynamic-table-insert-tsql">There is one stackoverflow question similar to this</a>, but they were trying to insert into staging tables based on the value of some datetime.  I felt it was necessary to post this as an original question since this would be a completely generic solution with no special conditions attached.</p>
  <p>I know the solution will involve using Insert Into, any help is greatly appreciated.  Thank you.</p>