TR_MKTSEGMENT_IU_BASECURRENCYID (Trigger)

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

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

  update dbo.[MKTSEGMENT] set
    [MKTSEGMENT].[BASECURRENCYID] = @ORGANIZATIONCURRENCYID,
    [MKTSEGMENT].[CHANGEDBYID] = [MKTSEGMENT].[CHANGEDBYID],
    [MKTSEGMENT].[DATECHANGED] = [MKTSEGMENT].[DATECHANGED]
  from inserted
  inner join dbo.[MKTSEGMENT] on inserted.ID = [MKTSEGMENT].[ID]
  where [MKTSEGMENT].[BASECURRENCYID] is null
  and [MKTSEGMENT].[SEGMENTTYPECODE] in (2, 9);
end