Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Network Performance Monitor (NPM) > Queries Using CTE Fail in Web Report Writer

Queries Using CTE Fail in Web Report Writer

Created by Michael Almadova, last modified by MindTouch on Jun 23, 2016

Views: 733 Votes: 0 Revisions: 4

Overview

Queries Using CTE fail in Web Report Writer, but will run in Report writer. 

 

Environment

  • NPM 11.5.2

 

Cause 

 

A semicolon is missing in front of the command ;WITH CTE AS.

Resolution

  1. Add the semicolon in front of the;WITH CTE AS command and this will run in Web reports. 

 

 

 

 

Last modified
23:24, 22 Jun 2016

Tags

This page has no custom tags.

Classifications

Public