Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

is there any way to collect some number into grid with one column

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 :

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

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
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading