Format SQL stumples in xml.query
JornSjostrom
Posts: 1 New member
in SQL Prompt
Format SQL does not like this construction. Seems to be the .query and .value that causes the problem.
CASE WHEN caseTypeRecno IN ( 100010, 100016 )
THEN COALESCE(dbo.xmlCaseSplitTitle(caseDescLong).query('first'),'<first></first>').value('(first/node())[1]','nvarchar(max)')
ELSE caseDescShort
END AS caseTitleFirst,
CASE WHEN caseTypeRecno IN ( 100010, 100016 )
THEN COALESCE(dbo.xmlCaseSplitTitle(caseDescLong).query('first'),'<first></first>').value('(first/node())[1]','nvarchar(max)')
ELSE caseDescShort
END AS caseTitleFirst,
Tagged:
Comments
Unfortunately xml.query is not supported by SQL Prompt at the moment. I'd recommend adding a suggestion to the SQL Prompt uservoice page here and we may revisit it in the future.
Thanks!
James
Redgate Software