I have a table with 3 fields A,B,C. Field A is a primary key and the field is not an auto generated number. I retrive the unique key from another table. When using BCP let&#039s say with 10 records the value for field A needs to be generated inside a trigger on insert. I have the routine that will give me the unique number for each record inside the logical inserted table but I want to know how you assigned that value to the logical inserted table that holds the data when evaluating the trigger I know that you can&#039t call an update query on the inserted table to update it? Other wise when the insertion takes place it will failed because of no value for Field A will be provided. If anybody has ran across the scenerio I would greatly appreciate your help. Thanks.