Hi All,
The following is the scenario
id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....
I need the following output
id name
--------------
1 William
1 Johnson
2 Azim
2 Abdul
3 Grasim
.
.
..etc
Please tell me the way to achieve the solution.
Thanks in advance!!!!