TR_DONORCHALLENGENOTE_INSERT_HTMLPOPULATE

                  CREATE trigger TR_DONORCHALLENGENOTE_INSERT_HTMLPOPULATE on dbo.DONORCHALLENGENOTE 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.DONORCHALLENGENOTE
                          set HTMLNOTE = dbo.UFN_BUILDHTMLNOTE(TEXTNOTE)
                          where ID = @INSERTEDID
                      end
                  end