SQL – Split delimited columns using XML Or UDF function

The requirement is to convert the delimited column into rows Input data and required output details are given below Eno Ename Esloc EDept 1 ABC NJ 10,20,30,40,50 Output:- Eno Ename Esloc EDept 1 ABC NJ 10 1

 
 
 
 
 
4 Star
(1)
493 times
Add to favorites
Databases
1/9/2015
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


Be the first to ask a question.