title: SQL Server add auto serial id to additional field during insert
body: <p>I have an insert statement in a stored procedure who's primary key is a serial id. I want to be able to populate an additional field in the same table during the same insert statement with the serial id used for the primary key. Is this possible? </p>
  
  <p>Unfortunately this is a solution already in place... I just have to implement it. </p>
  
  <p>Regards</p>