"<sales> <sale> <name>Joy G</name> <details>TYOP 1,KODF 1243</details> </sale> </sales> "
SELECT n.xmlData.value('(sales/sale/details)[1]','varchar(max)') FROM xmlTable Cross Apply xmlData.nodes('/') n(xmlData)
SELECT n.RawXml.value('(sales/sale/details)[1]','varchar(max)') FROM Batches Cross Apply RawXml.nodes('/') n(RawXml)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)