TR_DESIGNATIONLEVEL_INSERTUPDATE_CURRENCY (Trigger)

                
                    CREATE trigger [dbo].[TR_DESIGNATIONLEVEL_INSERTUPDATE_CURRENCY] on [dbo].[DESIGNATIONLEVEL]
                        after insert, update
                        not for replication
                        as
                        begin
                            set nocount on;
                        
                            declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                            if update(ENDOWMENTMINAMOUNT)
                                update
                                    dbo.DESIGNATIONLEVEL
                                set
                                    DESIGNATIONLEVEL.ORGANIZATIONENDOWMENTMINAMOUNT = DESIGNATIONLEVEL.ENDOWMENTMINAMOUNT,
                                    DESIGNATIONLEVEL.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
                                    DESIGNATIONLEVEL.CHANGEDBYID = DESIGNATIONLEVEL.CHANGEDBYID,
                                    DESIGNATIONLEVEL.DATECHANGED = DESIGNATIONLEVEL.DATECHANGED
                                from
                                    inserted
                                inner join
                                    dbo.DESIGNATIONLEVEL on inserted.ID = DESIGNATIONLEVEL.ID
                                where
                                    DESIGNATIONLEVEL.ORGANIZATIONEXCHANGERATEID is null
                                    and (DESIGNATIONLEVEL.BASECURRENCYID is null or DESIGNATIONLEVEL.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
                                    and
                                    (
                                        DESIGNATIONLEVEL.ORGANIZATIONENDOWMENTMINAMOUNT <> DESIGNATIONLEVEL.ENDOWMENTMINAMOUNT
                                        or DESIGNATIONLEVEL.ENDOWMENTMINAMOUNT = 0
                                    );
                        end