mikegrad7
asked on
SQL Server Transpose , partially at least
Hi, i am trying to create a SQL Sp that will output some data, but it needs to do a partial transpose.
the current data is in rows, and looks like this. Lets call this Table CURRDATA
ID 1 ID2 TYPE RATE END_DATE
ABC123 786efr XXX 5.5 12/31/2019
XXYYZZ AABBCC YYY 6.9 6/30/2020
etc... they key for the table is the combination of ID1 and ID 2
I need to re-arrange this output for import to another system, and it needs to be somewhat transposed. The output should look like this, with a line for each value outside the key.
ID1 ID2 Property Value
ABC123 786efr TYPE XXX
ABC123 786efr RATE 5.5
ABC123 786efr END_DATE 12/31/2019
XXYYZZ AABBCC TYPE YYY
XXYYZZ AABBCC RATE 6.9
XXYYZZ AABBCC END_DATE 6/30/2020
Can someone help me write this SQL to get the desired output?
the current data is in rows, and looks like this. Lets call this Table CURRDATA
ID 1 ID2 TYPE RATE END_DATE
ABC123 786efr XXX 5.5 12/31/2019
XXYYZZ AABBCC YYY 6.9 6/30/2020
etc... they key for the table is the combination of ID1 and ID 2
I need to re-arrange this output for import to another system, and it needs to be somewhat transposed. The output should look like this, with a line for each value outside the key.
ID1 ID2 Property Value
ABC123 786efr TYPE XXX
ABC123 786efr RATE 5.5
ABC123 786efr END_DATE 12/31/2019
XXYYZZ AABBCC TYPE YYY
XXYYZZ AABBCC RATE 6.9
XXYYZZ AABBCC END_DATE 6/30/2020
Can someone help me write this SQL to get the desired output?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mikegrad7, do you still need help with this question?
ASKER
thanks to everyone for you help, i was able to get this working as i needed.