TR_MKTSEGMENTWHITEMAILCACHE_INSERTUPDATE_CURRENCY (Trigger)

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

  update dbo.[MKTSEGMENTWHITEMAILCACHE] set
    [MKTSEGMENTWHITEMAILCACHE].[BASECURRENCYID] = [MKTSEGMENT].[BASECURRENCYID],
    [MKTSEGMENTWHITEMAILCACHE].[CHANGEDBYID]    = [MKTSEGMENTWHITEMAILCACHE].[CHANGEDBYID],
    [MKTSEGMENTWHITEMAILCACHE].[DATECHANGED]    = [MKTSEGMENTWHITEMAILCACHE].[DATECHANGED]
  from inserted
  inner join dbo.[MKTSEGMENTWHITEMAILCACHE] on [MKTSEGMENTWHITEMAILCACHE].[ID] = inserted.[ID]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTWHITEMAILCACHE].[ID]
  where [MKTSEGMENTWHITEMAILCACHE].[BASECURRENCYID] is null;
end