TR_BATCHEVENT_INSERTUPDATE_CURRENCY

Definition

Copy


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

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