title: Copy a primary key from a target table as a foreign key on the source table during an insert
body: <p><strong>The Situation:</strong><br>
  I am inserting information from one table to another, a source and target. When the information is inserted into the target, a primary key is created. (In this case it is an integer.) I then need to be able to tie back to the source table. However, based on the data being moved, I am not able to reliably get the 1:1 match between the target and source tables.</p>
  
  <p><strong>The Question:</strong><br>
  Is there a way to copy the primary key that was created for record(x) in the target table and copy it as a foreign key to that same record(x) in the source table as the bulk insert is happening?</p>
  
  <p><strong>Details:</strong><br>
  I am trying to get this done in SQL. I have a work-around to this problem but I figure there has to be a way to do what I'm asking.</p>