TR_PROSPECTRESEARCHREQUESTNOTE_INSERT_HTMLPOPULATE (Trigger)

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