TR_DESIGNATIONLEVEL_INSERT_BBNCDESIGNATIONLEVELIDMAP

                CREATE trigger TR_DESIGNATIONLEVEL_INSERT_BBNCDESIGNATIONLEVELIDMAP on dbo.DESIGNATIONLEVEL after insert not for replication
                as begin
                    insert into dbo.BBNCDESIGNATIONLEVELIDMAP (DESIGNATIONLEVELID)
                        select ID from inserted
                end