TR_STEWARDSHIPNOTE_INSERT_HTMLPOPULATE

                CREATE trigger TR_STEWARDSHIPNOTE_INSERT_HTMLPOPULATE on dbo.STEWARDSHIPNOTE after insert not for replication
                as begin
                    declare @INSERTEDHTML nvarchar(max)
                    declare @INSERTEDID uniqueidentifier

                    select @INSERTEDID = ID, @INSERTEDHTML = HTMLNOTE from inserted
                    if @INSERTEDHTML = ''
                    begin
                        update dbo.STEWARDSHIPNOTE
                        set HTMLNOTE = dbo.UFN_BUILDHTMLNOTE(TEXTNOTE)
                        where ID = @INSERTEDID
                    end
                end