Best Method to update FK from IDENTITY(1,1) PK table after insert

OUTPUT is the best way to capture IDENTITY insert values:

http://www.sqlusa.com/bestpractices2005/outputidentitycapture/

---

Kalman Toth Database & OLAP Architect sqlusa.com

New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012