I have 3 tables im updating inside my sproc. My 3rd table has a foreign key relationship to the primary key in my second table. The primary key in the second table is an identity column so sql server creates it. I need to get that value and add it to my xml file in passing in. Im using an xml file cause there will be multiple records i will be adding in the 3rd table. I need to modify the xml doc to add in the primary key value read from table 2.