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. Hi, Hugo, good question. To be honest, aside from any impact of additional overhead, I don't know of any additional harm in this instance. (Though since they're disabled by default, one would only use them for specific reasons). Maybe someone else reading this can jump in.
