Cascade Update Trigger Problems

From: <dleenhouts_at_gmail.com>
Date: 7 Aug 2006 11:18:48 -0700
Message-ID: <1154974728.247035.145200_at_m73g2000cwd.googlegroups.com>

[Quoted] [Quoted] Does anyone know how to use a trigger to update a table (& all child tables) so that an existing pk is updated to another existing pk. For instance, merging records so that:

Key             CompanyName
1                  GE
2                  General Electric
3                  general electric
4                  G.E.

All become one single record. I would even be satisfied by assigning all 4 of these into a 5th record as long as all related records are attached. These also have a number of child records associated with them as well (orders, employees, etc).

Thanks Received on Mon Aug 07 2006 - 20:18:48 CEST