TR_MKTASKLADDER_INSERTUPDATE_CURRENCY (Trigger)

        
CREATE trigger dbo.[TR_MKTASKLADDER_INSERTUPDATE_CURRENCY] on dbo.[MKTASKLADDER]
after insert, update 
not for replication
as
begin
  set nocount on;

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