Tag Archives: Parse the delimited columns

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 ABC NJ 20 … Continue reading

Posted in SQL, T-SQL | Tagged , , , , , | Leave a comment