LOL there is something amiss in the math here. These two parts don't even look they are from the same question.

Woohoo. And just a few weeks after we have finally migrated the last of our production databases off of 2005. Sadly we only upgraded to 2014 but hey at least...

I would try to avoid doing this in triggers. You could add the new data points in your update queries (hopefully you are using stored procs so this is a...

Great question Alan. I must need more coffee this morning. I knew the answer but managed to click the wrong one. :Whistling: