Pasted

-- THANKS JOHN SIMON
 
SELECT *
FROM (
SELECT id, attrid, decode(attrtype, -18, valstr, -7, valdate, -1, valstr, 5, valint, 10, valstr, 11, vallong, 14, valint, 10013, valstr, 10130, valstr) AS attrvalue
FROM llattrdata
WHERE defid = 45882 AND defvern = (
SELECT versionnum FROM dtree WHERE dataid = 45882)
)
pivot (
MAX(attrvalue) FOR attrid IN (
2 AS COUNTRY_OF_CONTENT,
3 AS COMPANY_NAME,
4 AS RM_UNIT,
5 AS RM_RECORD_OWNER_INT,
6 AS RM_VITAL_RECORD_INT));