TR_FUNDINGPLANNOTE_INSERT_HTMLPOPULATE

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