TR_MERCHANDISEPRODUCTNOTE_INSERT_HTMLPOPULATE

CREATE trigger TR_MERCHANDISEPRODUCTNOTE_INSERT_HTMLPOPULATE on dbo.MERCHANDISEPRODUCTNOTE after insert not for replication
as begin
    update dbo.MERCHANDISEPRODUCTNOTE set
        HTMLNOTE = dbo.UFN_BUILDHTMLNOTE(inserted.TEXTNOTE),
        CHANGEDBYID = inserted.CHANGEDBYID,
        DATECHANGED = inserted.DATECHANGED
    from
        inserted
    where
        inserted.ID = MERCHANDISEPRODUCTNOTE.ID
        and inserted.HTMLNOTE = ''
        and inserted.TEXTNOTE <> '';
end