I have table with single column (Datatype: nvarchar(4000)) and with following records:
The no of comma is same accross all the rows..
Now my requirement is to create a table with separate columns for each comma separated values. Here is the output:
Col A: ColB: ColC; ColD; ColE
1 2 3 4 5
6 7 8 9 10
Please let me know how to proceed.