But nested triggers would be triggers on different tables.

So a trigger on orderdetail that updates the order header totals which has a trigger that goes and modifies some audit tables...

Perhaps if you could paste in the 'dirty work' too people might be able to help more. I get the impression that its hard because we only have half the...

Generally no chip can be all things to all people, but if vendors could be bothered providing their software on alternative architectures that would be cool. (only if they bothered...

Be careful you just lost the DISTINCT clause which may or may not be important or required, only the data can tell you.

Still can't see why anyone would do this...