Forum Discussion
michaeljc70
10 years agoAdvocate II
Query with CTE gives error
I used SQL Server and a query that uses a CTE. It gives me an error "Incorrent syntax near the Keyword 'WITH'. ......."if this is a common table expression......previous statement must be terminated...
rowlandshaw
9 years agoFrequent Visitor
The detail I'd add here, is that the query preview works, it's when evaluating the query that it falls over