I'm using a trigger on insert (Table1) (i.e. 300 records) to insert records into table2 used for reporting. On the same table (table1) I have another trigger on insert that will calculate a value & insert that value along with some other field values into table3. Is there a way to only fire the 2nd trigger on table1 upon completion of the first trigger on table1. For example, on the first insert to table1 there are 300 records. Does trigger 2 fire when all the records inserted to table1 are copied to table2? or does it fire after each record is inserted. I need trigger 2 to only fire after all 300 records are finished processing on table2.

Comments.

Hi there..

if you always want to fire trigger 2 after trigger 1... why not use the same trigger to do the two things?? once you finish with trigger 1 code, execute trigger 2 code...

HTH

Gonzalo

well, will that ensure that all the records inserted into the first table are processed?

the trigger will fire for every insert statement you execute.. if you just execute one for the 300 records it will execute only once.. if you execute 300 inserts it will execute 300 times, but the code for the second one will execute after the code for the first one always...

HTH

Gonzalo

Thanks for your prompt response. Very much appreciated.
The process that is inserting the records to table1 is being done behind the scene. So it appears that the trigger is firing for each record. Is there a way to execute a trigger or some other means (UDF, sproc)to execute trigger2. Maybe the logic i'm using is wrong.