I have an
Object table which is populated from an Integrated service (which I can change if needed) from another database. At certain points we need to manually add posts in another table
ObjectObjectGroup (ObjectId, ObjectGroupId) which is needed if
Object.ObjectType have a certain integer value. Since the integration service doesn't handle that kind of update, I'm thinking of adding a trigger to the Object table which in pseudo-code would be the following:
if Object.ObjectType = 10 begin if Object.ObjectNumber like '<string pattern>' begin insert into ObjectObjectGroup values... end end
Is this setup wise, or is there a better way in terms of performance?