I have a list of numbers like this :
1,
2,
3,
4
and so on.
one way to make this list into grid with one column is union all.
is there another way to do that?
best regards
>Solution :
You can use CROSS APPLY with STRING_SPLIT to achieve the same.
declare @table table(list varchar(50))
insert into @table values ('1, 2, 3, 4')
select ss.value from @table as t
cross apply string_split(t.list,',') as ss
| value |
|---|
| 1 |
| 2 |
| 3 |
| 4 |