troubleshooting Question

SQL - Splitting column values into separate rows

Avatar of tmajor99
tmajor99 asked on
Microsoft SQL ServerSQL
6 Comments1 Solution73 ViewsLast Modified:
I do not think this is possible with SQL but I thought i would ask anyway.   I need to split a column into multiple rows.  

Table A:

Item ID               Kits Reference ID       Kits Reference Qty
---------            -------------------      --------------------
1                         100;500                       1;40
2                          200;820;910               45;32;56

As you can see each item record can have one or more reference ID's each separated by a ";".   In addition, each reference ID has a QTY.

Expected Output

Item ID               Kits Reference ID       Kits Reference Qty
---------            -------------------      --------------------
1                         100                                1
1                          500                               40
2                          200                               45
2                           820                              32
2                           910                              56
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros