TR_BATCHREVENUEENHANCEDMATCHINGGIFTS_INSERTUPDATE_CURRENCY (Trigger)

                
                    CREATE trigger [dbo].[TR_BATCHREVENUEENHANCEDMATCHINGGIFTS_INSERTUPDATE_CURRENCY] on [dbo].[BATCHREVENUEENHANCEDMATCHINGGIFTS] 
                    after insert
                    not for replication
                    as begin
                        set nocount on;

                        update
                            dbo.BATCHREVENUEENHANCEDMATCHINGGIFTS
                        set
                            BATCHREVENUEENHANCEDMATCHINGGIFTS.TRANSACTIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(),
                            BATCHREVENUEENHANCEDMATCHINGGIFTS.CHANGEDBYID = BATCHREVENUEENHANCEDMATCHINGGIFTS.CHANGEDBYID,
                            BATCHREVENUEENHANCEDMATCHINGGIFTS.DATECHANGED = BATCHREVENUEENHANCEDMATCHINGGIFTS.DATECHANGED
                        from 
                            inserted
                            inner join dbo.BATCHREVENUEENHANCEDMATCHINGGIFTS on inserted.ID = BATCHREVENUEENHANCEDMATCHINGGIFTS.ID
                        where 
                            BATCHREVENUEENHANCEDMATCHINGGIFTS.TRANSACTIONCURRENCYID is null;
                    end