How to split hierarchy in SQL Server

Asked Jul 21 '19 at 16:15

Active Jul 21 '19 at 16:27

Viewed 128 times

I have a table which contains 23,000 hierarchypaths like below mentioned in the picture.

I want split these hierarchypaths like below. How can I do this in SQL Server 2014

edited Jul 21 '19 at 16:27

Thom A

asked Jul 21 '19 at 16:15

1

Possible duplicate of [How to split a comma-separated value to columns](https://stackoverflow.com/questions/10581772/how-to-split-a-comma-separated-value-to-columns) – Thom A Jul 21 '19 at 16:27
If you have a known or maximum number of levels, take a peek at https://stackoverflow.com/questions/43789578/split-one-column-value-into-multiple-column-values/43789876#43789876 – John Cappelletti Jul 21 '19 at 16:43
Is the amount of possible groups known? – Evaldas Buinauskas Jul 21 '19 at 19:46
maximum group11 / groupK – Muhammad Ali Khamis Jul 21 '19 at 20:04

0 Answers0