TR_DESIGNATIONGOAL_INSERTUPDATE_CURRENCY (Trigger)

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