>>
CASE WHEN TYPE = 'PCPA-NAL' AND LEVEL = 4 THEN '01-DOR LEVEL 4 EDITS'
WHEN TYPE = 'PCPA-NAL' AND LEVEL = 3 THEN '02-DOR LEVEL 3 EDITS'
WHEN TYPE = 'PCPA-NAL' AND LEVEL = 2 THEN '03-DOR LEVEL 2 EDITS'
WHEN TYPE = 'PCPA-NAL' AND LEVEL = 1 THEN '04-DOR LEVEL 1 EDITS'
WHEN TYPE = 'PCPA-HX' THEN '05-DOR CAPPING (HX)'
WHEN TYPE = 'PCPA-NHX' THEN '06-DOR CAPPING (NHX)'
WHEN TYPE = 'PCPA-SDF' THEN '07-DOR SALES EDITS'
WHEN TYPE = 'PCPA-NAP' THEN '08-DOR TPP EDITS'
WHEN TYPE = 'PCPA-RE-EDIT' THEN '09-PCPA RE EDITS'
WHEN TYPE = 'PCPA-TPP-EDIT' THEN '10-PCPA TPP EDITS' ELSE 'XXXX' END,
Why not change this shit in a subselect:
(select entry from capacities_table where level = o.level and type = o.type)
And then create this table:
| entry | type | level |
| 02-DOR LEVEL 1 EDITS | PCPA-NAL | 1 | 05-DOR CAPPING (HX) | PCPA-HX | 1
| 05-DOR CAPPING (HX) | PCPA-HX | 2
| 05-DOR CAPPING (HX) | PCPA-HX | 3
....
| 05-DOR CAPPING (HX) | PCPA-HX | 20
Message too long. Click here to view the full text.