I have a table that 2 seperate triggers. one is an insert trigger, and one is an update trigger.
I need to perform an action only on insert, and I need to alter the inserted records.
I did update the base table within the insert trigger, but that fired the update trigger. I don't wan't the update trigger to fire during the process