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?