SQL Server: Facing problem to parse xml using xquery
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am generating xml from my C# application which look like
Consensus Model 1Q 2010 Income Statement NET REVENUES Extracted Net Revenue 329.623
i guess due to \" character sql server not able to parse my xml. i tried lot to remove back slash from my xml in c# but failed. so tell me what kind of changes i can do in my below xquery code as a result \" will not cause any problem here is my full code
Declare @BrokerBogeyXML xml='
Consensus Model 1Q 2010 Income Statement NET REVENUES Extracted Net Revenue 329.623 Consensus Model 2Q 2010 Income Statement NET REVENUES Extracted Net Revenue 454.776