Split data in sql with multiple delimiters ( , and - ) with owns rule

I have data like this 1,2,3,4-8,10,11

I want split the data into rows with these 2 rules :

The , will only split the data into rows. Ex 1,2,3 become :
```
1
2
3
```
The - will split into series number. Ex 4-8 become :
```
4
5
6
7
8 
```

How can a SQL query do that? Please answer and keep it simple.

Solution

This will work as long as your intervals are less than 2048 (let me know if that numbers can go higher) and you @data follow your current syntax:

declare @data varchar(50) = '1,2,3,4-8,10,11'

;with x as
(
     SELECT t.c.value('.', 'VARCHAR(2000)') subrow
     FROM (
         SELECT x = CAST('<t>' + 
               REPLACE(@data, ',', '</t><t>') + '</t>' AS XML)
     ) a
     CROSS APPLY x.nodes('/t') t(c)
), y as
(
SELECT 
CAST(coalesce(PARSENAME(REPLACE(subrow, '-', '.'), 2),
              PARSENAME(REPLACE(subrow, '-', '.'), 1)) as int) f,
CAST(PARSENAME(REPLACE(subrow, '-', '.'), 1) as int) t from x
)
select z.number from y
cross apply 
(select y.f + number number
from master..spt_values
where number <= y.t - y.f and type = 'p'
) z

Result: