This task and stored procedure generate concatenated salutations based on setups in Gen_Tables every time a name is changed. Essentially, the description line in the Gen_Tables stores the SQL statement for the salutation. When a name is changed or added, the task fires a stored procedure that uses the Gen_Tables setups to create all the "auto" salutations for the donor. The solution also accommodates manually created salutations, for instance for the occasional record that would have a special executive's salutation, leaving those alone when it rebuilds the auto salutations.

Zip file includes a task and a stored procedure.