Format SQL Fails with FOR XML query

MikeyC

SQL Prompt 4.0.4.14 fails with an error saying:

"SQL Prompt was unable to format this script because some syntax errors were found while it was being parsed. These errors have been highlighted."

with this valid code:

SELECT (SELECT 'Test' FOR XML PATH(''), TYPE).value('.[1]','varchar(max)') AS Test

slaphead99

Thanks and sorry about this - I will raise a bug report

MikeyC

Will you post the SP number once it has been assigned to make it easier to get the status in the future? Thanks!

slaphead99

This has been assigned SP-2939

I will ask the team if there is a possibility of a quick patch fix.