TR_BATCHSPONSORSHIP_INSERTUPDATE_CURRENCY (Trigger)

        
                    create trigger [dbo].[TR_BATCHSPONSORSHIP_INSERTUPDATE_CURRENCY] on [dbo].[BATCHSPONSORSHIP] 
                    after insert
                    not for replication
                    as begin
                        set nocount on;

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