Steve A
asked on
Separate 2 comma delimited columns into separate rows
Hi,
I have some data that I was to parse or separate out, that is initially in 1 row and want to separate into
different rows. As seen in the data samples below. I was looking at examples but they don't cover 2 columns
being separated at the same time.
Thanks for your time.
Using Sql Server 2008
Data Input
id clx pic trans
-- ------ -------- -------
1 9845 A,B, C 1,2
Data output:
id clx pic trans
-- ------ -------- -------
1 9845 A 1
2 9845 B 2
3 9845 C <null>
I have some data that I was to parse or separate out, that is initially in 1 row and want to separate into
different rows. As seen in the data samples below. I was looking at examples but they don't cover 2 columns
being separated at the same time.
Thanks for your time.
Using Sql Server 2008
Data Input
id clx pic trans
-- ------ -------- -------
1 9845 A,B, C 1,2
Data output:
id clx pic trans
-- ------ -------- -------
1 9845 A 1
2 9845 B 2
3 9845 C <null>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window