TR_CONSTITUENCYCODE_INSERTCONSTITUENCYDEFINITION

--Add insert trigger to the CONSTITUENCYCODE table to keep it in sync with the associated CONSTITUENCYDEFINITION record
create trigger TR_CONSTITUENCYCODE_INSERTCONSTITUENCYDEFINITION on dbo.CONSTITUENCYCODE after insert not for replication
as
begin
    set nocount on;

        insert into
            dbo.CONSTITUENCYDEFINITION(ID, DESCRIPTION, SYSTEMDESCRIPTION, ISACTIVE, ISSYSTEM, DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
        select
            INSERTED.ID,
            INSERTED.DESCRIPTION,
            INSERTED.DESCRIPTION,
            INSERTED.ACTIVE,
            0,
            INSERTED.DATEADDED, 
            INSERTED.DATECHANGED,
            INSERTED.ADDEDBYID, 
            INSERTED.CHANGEDBYID
        from
            INSERTED;
end