trigger not fire when import data from another table

• raj acharya

  SSCrazy

  Points: 2805

  More actions

  March 9, 2009 at 6:04 am

  #201216

  hi i have created one trigger for example on table1

  trigger is for insert and after insert i m doing some calculation on that data

  so when i m inserting one by one data into table1 trigger runs completely

  but when imporing data from another table than it bypass this trigger or trigger not fire ....

  anybody know abt this strange behaviour than pls tell me

  Raj Acharya

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  March 9, 2009 at 6:21 am

  #955906

  Hi

  Only a suggestion:

  Maybe you select only one value from INSERTED instead of working with the bulk set of data within?

  Greets

  Flo

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 9, 2009 at 7:13 am

  #955947

  Duplicate post. Please see other answers here: http://www.sqlservercentral.com/Forums/Topic671411-146-1.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question