TR_OPPORTUNITYAMOUNTBRACKET_INSERTUPDATE_CURRENCY (Trigger)

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