Jack,

Thanks for the article. I don't know if it is your cheeky picture or your writing style, but you have become one of my favorites on this forum.

I am very familiar with Oracle triggers and I have not read up on the SQL Server implementation, but you left me with the impression, based on your set examples, that the trigger only fires once for each insert command, versus for every record inserted. I would assume it is for every record inserted, so the need for set stuff is moot. Did I just not get the reasoning behind your example?

Tobar