How to split comma separated string values into columns ?

In this video we will learn about how to split comma separated string values into columns.

[sourabhthorat]

I have a question how to decide maximum how much phone numbers will be there in case of random inputs as you have hardcoded phn1..phn4 ?

[shami]

string split function introduced in SQL 2017, but I want to do that in SQL 2014, how can i do that?

[scrow]

How to do this same thing but with two columns? That is, if I have EmpID, EmpPhoneNo and EmpDirection columns in my table and I would like to apply string_split cross apply and Pivot to EmpPhoneNo and EmpDirection, how would the query be?, by the way THANKS FOR THE VIDEO :)

[leonorpereira]

How do I do this but with alter table or something like that?

[lia_sahin]

how to split a large table consisting of a single column with 15 attributes, there should be 15 columns. in MsSQL server? Thanks 😊.

[sudhirmore]

Data in table is so much large, index is not applicable to pivot then performance is so much low..then what will do..pls suggest..thanks in advance

[siprabehera]

If both comma and '&' searator value will be there in some column then how to do..like 578, 599 & 580 then how to split or one value will be 580, 590 and anthoer 560 &570 then how to wright script for both to separate comma and &

[shikhasomani]

How to split the column into different columns if having n numbers of strings

[hanumegowdabh]

sql server 2005 how to split, or | separation text to new line ?