TR_TEAMFUNDRAISINGTEAM_DELETE_FAFGROUPDIRECTHIERARCHY

        create trigger TR_TEAMFUNDRAISINGTEAM_DELETE_FAFGROUPDIRECTHIERARCHY on dbo.TEAMFUNDRAISINGTEAM after delete not for replication
        as
            delete from dbo.FAFGROUPDIRECTHIERARCHY  
            where GROUPID IN (select ID from deleted) or CHILDGROUPID in (select ID from deleted)