TR_MEMBERNOTE_INSERT_HTMLPOPULATE

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