TR_DESIGNATIONLEVEL_INSERTUPDATE_DESIGNATIONNAME

                        CREATE trigger [dbo].[TR_DESIGNATIONLEVEL_INSERTUPDATE_DESIGNATIONNAME] on [dbo].[DESIGNATIONLEVEL]
                            after insert, update
                            not for replication
                            as
                            begin
                                set nocount on;

                                declare @IDS UDT_GENERICID;

                                with CTE_DESIGNATIONS as
                                (
                                    select
                                        D.ID
                                    from
                                        inserted I
                                        inner join dbo.DESIGNATION D on I.ID = D.DESIGNATIONLEVEL1ID

                                    union all

                                    select
                                        D.ID
                                    from
                                        inserted I
                                        inner join dbo.DESIGNATION D on I.ID = D.DESIGNATIONLEVEL2ID

                                    union all

                                    select
                                        D.ID
                                    from
                                        inserted I
                                        inner join dbo.DESIGNATION D on I.ID = D.DESIGNATIONLEVEL3ID

                                    union all

                                    select
                                        D.ID
                                    from
                                        inserted I
                                        inner join dbo.DESIGNATION D on I.ID = D.DESIGNATIONLEVEL4ID

                                    union all

                                    select
                                        D.ID
                                    from
                                        inserted I
                                        inner join dbo.DESIGNATION D on I.ID = D.DESIGNATIONLEVEL5ID
                                )
                                insert into @IDS
                                    (ID)
                                select distinct
                                    ID
                                from
                                    CTE_DESIGNATIONS

                                exec dbo.USP_DESIGNATION_SETNAME @IDS
                            end