TR_BATCHREVENUE_INSERT_HTMLPOPULATE

        CREATE trigger TR_BATCHREVENUE_INSERT_HTMLPOPULATE on dbo.BATCHREVENUE after insert not for replication
        as begin
              update dbo.BATCHREVENUE
              set NOTEHTMLNOTE = dbo.UFN_BUILDHTMLNOTE(NOTETEXTNOTE)
              where ID in(select ID from inserted)
          and NOTEHTMLNOTE = ''
          and NOTETEXTNOTE <> ''
        end