TR_SMARTFIELD_INSERT (Trigger)

        
CREATE trigger TR_SMARTFIELD_INSERT on dbo.SMARTFIELD after insert not for replication
as begin
    if update(CURRENCYID)
    begin
      declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](); 
      update
        dbo.[SMARTFIELD]
      set
        [SMARTFIELD].[CURRENCYID] = @ORGANIZATIONCURRENCYID,
        [SMARTFIELD].[CHANGEDBYID] = [SMARTFIELD].[CHANGEDBYID],
        [SMARTFIELD].[DATECHANGED] = [SMARTFIELD].[DATECHANGED]

      from
        inserted
        inner join dbo.[SMARTFIELD] on inserted.ID = [SMARTFIELD].[ID]
        inner join dbo.[SMARTFIELDCATALOG] on [SMARTFIELD].[SMARTFIELDCATALOGID] = [SMARTFIELDCATALOG].[ID]
        where
          [SMARTFIELD].[CURRENCYID] is null
          and [SMARTFIELDCATALOG].[DATATYPECODE] = 3;
    end
end