Home convert mutilple nodes within xml to comma seperated list in Tsql
Reply: 0

convert mutilple nodes within xml to comma seperated list in Tsql

user492
1#
user492 Published in June 19, 2018, 6:13 pm

I have a table with a column containing the following xml which I want to present on the gui as a comma separated list ie. 1,2,5,6,7,8

    <RuleSetting>
  <CurrentQueue>1559</CurrentQueue>
  <CurrentQueue>1560</CurrentQueue>
  <CurrentQueue>1561</CurrentQueue>
  <CurrentQueue>1564</CurrentQueue>
</RuleSetting>

How might I do this or where can I find information on how to do it?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.325026 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO