inserting last record....

• MikeAtTheMill

  Old Hand

  Points: 398

  More actions

  February 11, 2004 at 1:37 pm

  #493709

  Hi TNT -

  Basic rule of thumb for a trigger is that it fires once per statement - NOT once per row.  That's why in many triggers you often see a test for @@ROWCOUNT.  Bottom line: INSERT one row and your trigger will work the way you expect.  But - INSERT ... SELECT - she's not gonna work! 

  Maybe you can factor your logic up into a sp that uses (gasp!) a cursor - then feed your inserts one at a time.

  Good Luck.

  
  Mike at the Mill

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 11, 2004 at 1:57 pm

  #493711

  Oops, thanks Mike, meant once per statement when I said per transaction.

• TNT79

  SSC Enthusiast

  Points: 173

  More actions

  February 12, 2004 at 3:16 am

  #493766

  thanx alot for your help guys... i've decided to go with the easy option and enter record by record rather than SELECT..INSERT ...   cheers, TNT