I have a query which in the PI SQL commander which pulls the events information from AF database. The same query If I used in the PI data services to create a new dataset. the following error message being displayed when clicked on the Verify SQL.. I am using the CROSS APPLY on the transpose function of event frame template.
syntax error near CROSS..
PI Webparts version is 2010 R2 and PI SQL commander is 2012 version...
Request your help to resolve this issue.