TR_SMARTFIELD_INSERT

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