TR_TEAMFUNDRAISINGTEAM_INSERTUPDATE_CURRENCY (Trigger)

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