Question : > CREATE OR REPLACE PROCEDURE PRC_OPEN_PERIOD > ( InputXml in VARCHAR2,Tmode in varchar2,pOUT OUT number ) > IS […]
Tag: xml
Merging two XML variables – please help!
Question : I am using SQL Server Management Studio 17.9.1 with SQL Server 2016 Service Pack 2 (SP2). There is […]
Estimated vs Actual rows differences (actual much smaller than estimated) – sort
Question : I’m running a query that is processing some nodes out of an XML document. My estimated subtree cost […]
Querying XML with Unicode data
Question : I’m trying to select attribute value from XML column using XPath with a parameter that can be a […]
Concatenate all values of the same XML element using XPath/XQuery
Question : I have an XML value like this: <R> <I>A</I> <I>B</I> <I>C</I> … </R> I want to concatenate all […]
Very strange performance with an XML index
Question : My question is based on this: https://stackoverflow.com/q/35575990/5089204 To give an answer there I did the following test-scenario. Test […]
Compare value from xml node that contains decimal
Question : I need to compare the values of two different XML nodes for a record stored on SQL Server […]
Mysql database design with XML
Question : I intend to create a wiki webpage, but it has some few more limitations than regular wikis. The […]
Collation conflict when running dynamic sql FOR XML PATH
Question : I am getting the following error message when running the query below: Cannot resolve the collation conflict between […]
default value with select case on xml
Question : select case ‘NULL’ when ‘NULL’ then ‘f’ end as out output: f but select case (select (SELECT LEFT(l.list,LEN(l.list)-1) […]