Yea, this is NOT the way to accomplish this. String manipulation this way, especially in a recursive CTE is extremely expensive. string_split makes this easy even without the ordinal field...

Yea, this is NOT the way to accomplish this. String manipulation this way, especially in a recursive CTE is extremely expensive. string_split makes this easy even without the ordinal field...