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