How to split comma separated string values into columns ?

Рет қаралды 38,216

SQL Tutorial

Күн бұрын

Пікірлер: 18

@Kamrul.6coder 4 ай бұрын

Excellent ! Thanks for this process !

@sourabhthorat9550 2 жыл бұрын

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 ?

@shami621 2 жыл бұрын

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

@scrow23 3 жыл бұрын

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 :)

@leonorpereira6997 2 жыл бұрын

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

@lia_sahin 3 жыл бұрын

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

@sudhirmore6295 11 ай бұрын

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

@anuragbawankar685 Жыл бұрын

Thank You !

@siprabehera4680 4 жыл бұрын

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 &

@pradeepraturi9880 4 жыл бұрын

Then in this case you can use replace function that will replace the all & with comma. It is simple to keep all the substring value separated by same delimiter, if not then use replace function or translate function if there are multiple delimiter.

@siprabehera4680 4 жыл бұрын

@@pradeepraturi9880 i dint get..will you give the emailid so that i can sent scenario..but using oracle not sql server

@jayachandrang7933 Жыл бұрын

Even I have the same query? Can you able to help me out????????