gregdodd.me
Aggregate Functions in an Update Statement
I often need to update a record with an aggregate of another table. It’s often a parent record that has a record of the sum of a column in all of it’s child records. It seems like a rea…