We help IT Professionals succeed at work.
Get Started

SQL Select to change record orientation from horizontal to vertical

tmajor99 asked
Last Modified: 2020-02-28
I need a SQL select that can change the orientation of my record.  My input file contains one row per unique ID with separate columns for each reference ID and Type.  I need to format each row by breaking out each column reference type and ID into a new row.  

Input Table:

ID               Reference1 ID      Reference1 Type      Reference 2  ID             Reference2 Type
--------      -------------       -------------               -----------------            -----------------
10000       82                               GPH                             63                              LineBuy
10001       55                               GPH                             43                              LineBuy                                                                
10002                                                                                32                              LineBuy

Output Table:

ID              Reference ID        Reference Type
---------    -------------        ----------------
10000        82                        GPH
10000        63                        LineBuy
10001        55                        GPH
10001        43                        LineBuy
10002        32                        LineBuy
Watch Question
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE