>...and as a follow-up, make sure you're not using recursive triggers...(by default, they're turned off)
Kevin,
Sorry to steal your instructor time for free, but out of curiosity... Would have it mattered if recursive was turned on? I would think that as the second call to the trigger there would be no records complying with WHERE Inserted.nStndCost # Deleted.nStndCost as the only field updated within the trigger was dStndCost, thus ending the trigger and the recursion with some overhead.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
