TR_MKTSEGMENTGROUP_IU_BASECURRENCYID (Trigger)

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

  declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 

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