Dear All,

Could anybody tell me how to fire a trigger while inserting bulk data inside
1 table.
for e.g I have 2 table A & B

query will be

insert into A select x,y,z from B (there are 10 records)
now I have written one trigger on insert and my trigger will insert another
5 records inside 3rd table lets assume C.
so,
A --> B (10 records)
on this insert, trigger will fire and it will insert i.e 10 * 5 = 50 records
inside C table.

Currently its not happening.
Trigger is getting fire only for 1st insert and not for all 10 inserts.

Pls tell me the solution.

ASAP.

Thanks and Regards,
Vikram G.


The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.

Contact your Administrator for further information.

MS Sql Server LazyDBA home page