@AMtwo wrote "The method you're using doesn't scale well. sqlperformance.com/2012/07/t-sql-queries/split-strings". Neither does the XML splitter in that article. The author made a mistake using test data that has a cardinality of "1" no matter the row count and that seriously skews the testing done. Please see the following article for some realistic testing in the area of splitters. sqlservercentral.com/articles/Tally+Table/72993 — Jeff Moden 5 hours ago