How to differentiate column like this.

See more:

SQL-Server

Hi guys,

I have a table named EMPLOYEE as shown.

pk_emp_code Name Desc_Child1
----------- -------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
000001 DEMO123 ok
E0000860 AMITABH Yes,son
Mayy002 Mayy002 Yes,daughter,Delhi,South Delhi
Mayy003 Mayy003 Yes,daughter,Delhi
Mayy004 Mayy004 Yes,daughter,
Mayy005 Mayy005 Null

How can i get the result like this:

pk_emp_code name FirstField SecondField ThirdField FourthField
000001 DEMO123 ok
E0000860 AMITABH Yes son
Mayy002 Mayy002 Yes daughter Delhi South Delhi
Mayy003 Mayy003 Yes daughter Delhi
Mayy004 Mayy004 Yes daughter
Mayy005 Mayy005 Yes


Thanks in advance.