Tuesday, July 30, 2013

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

so do i insert the OUTPUT into a temp table and then update my Person table? The problem is i am not inserting the PersonSourceId or the SourceId into my Person table because those are stored in my PersonMapping table. All i am inserting is the persons name with some other misc. data.

No comments:

Post a Comment