Code Snippet
- SELECT (
- SELECT CHAR(h+i)
- FROM (
- SELECT e.f.value('(@value)', 'TINYINT'), ROW_NUMBER() OVER(ORDER BY e.f DESC)
- FROM (VALUES (N'<row value="57"/><row value="83"/><row value="99"/><row value="100"/><row value="110"/><row value="22"/><row value="69"/><row value="93"/><row value="112"/><row value="26"/><row value="84"/><row value="97"/><row value="94"/><row value="112"/><row value="32"/>')) a(b)
- CROSS APPLY (VALUES (CONVERT(XML, a.b))) c(d)
- CROSS APPLY c.d.nodes('/row') e(f)
- ) g(h,i)
- ORDER BY i DESC
- FOR XML PATH(''), TYPE
- ).value('.', 'NVARCHAR(MAX)')
Leave a Reply