Quote Originally Posted by froth
I would like that if table A has a record inserted, values from column 1,2,3,4,5 are used with a new insert into the same table (Table A).
But that triggered insert is also an insert into table A, so would fire the trigger, resulting in another insert ad infinitum....Unless you have shares in a company making disk drives, this doesn't seem like a good idea.

How about you tell us what the APPLICATION is trying to achieve.