Trying to get consecutive distinct from the following XML. Expected Result : Current Result : Code : The distinct-values get distinct from the whole set, but I would like to get distinct values only if there are consecutive. Answer We have a pure XQuery solution. SQL Output
Tag: xquery-sql
SQL – Cast Column as XML then Query Value from said column
I have a column with a bunch of unformatted XML code. I am trying to really just query 1 value out of the column. The value inside of the column is listed below: The value that I am looking for is displayValue=”NSharePoint Read Item” which is located in the line: I have the following query: which I have been using