ok..one more question.

How do I keep logging all the updates into temporary table.

the 1st update should be the first row of the temp table,

the 2nd update the 2nd row &...

Hey, thanks for the quick response.

The trigger is supposed to fire after all the salary elements have been updated like the basic salary, housing allowance, transportation allowance etc...& a mail...