Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • All SQL Server versions in mainstream support have STRING_SPLIT. Even SQL Server 2016 is out of mainstream support now Commented Nov 24, 2021 at 14:31
  • @PanagiotisKanavos, The OP didn't provide a minimal reproducible example. That's why I had to stoop down to earlier versions. Commented Nov 24, 2021 at 14:33
  • For 2016 you can use JSON instead of XML, which will be faster. For older versions - we're 8 years back already, the OP should make it clear just how old the server is Commented Nov 24, 2021 at 14:35
  • It's reasonable that we should encourage moving away from lowest common denominator solutions.. Commented Nov 24, 2021 at 14:38