• I wanted to say that you can not have trigger called only once for many insert statements.

    I think u could have done this for the below statement-

    insert into Table1 (col1, col2) Select col1,col2 from Table2

    Here trigger is fired only once.