sql server - xml parsing error of the sql query -
when run query below, following error
msg 9455, level 16, state 1, line 1
xml parsing: line 31, character 19, illegal qualified name character
query:
;with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition', 'http://schemas.microsoft.com/sqlserver/reporting/reportdesigner' rd) select a.name, x.value('commandtype[1]', 'nvarchar(50)') commandtype, x.value('commandtext[1]','nvarchar(50)') commandtext (select name, cast(cast(content varbinary(max)) xml) reportxml reportserver.dbo.catalog) cross apply a.reportxml.nodes('/report/datasets/dataset/query') r(x) x.value('commandtype[1]', 'nvarchar(50)') = 'storedprocedure'
Comments
Post a Comment