XML Path

emilebons.nl · Post by **emilebons.nl** » Mon Dec 19, 2011 7:53 am

We are using a query which is using 'FOR XML PATH'. Using this one in SQL Server Management Studio works fine. However, using this query in Stimulsoft causes a error message like 'Query invalid...'. The error message points at the point in the query where FOR XML PATH has been used. Is this not supported or are we doing something else wrong?

Thanks,

Emile Bons

Post by **Alex K.** » Mon Dec 19, 2011 8:36 am

Hello,

We couldn't reproduce this bug.
Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

emilebons.nl · Post by **emilebons.nl** » Mon Dec 19, 2011 8:57 am

Thanks! I added two files: one is a database backup(SQL server 2005) of the database on which the query (other file) is used.

Thanks,

Emile Bons

Post by **Alex K.** » Wed Dec 21, 2011 1:24 am

Hello,

Please check your backup file.
We get an error when trying to recover from it.

Thank you.