Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT MCORP, MYEAR, MINUM, MDESC, MONTH, ACTUAL, BUDGET
- FROM LIBRARY_NAME.FILENAME AS S,
- LATERAL(VALUES ('JANUARY', S.MCAS01, S.MCBS01),
- ('FEBRUARY', S.MCAS02, S.MCBS02),
- ('MARCH', S.MCAS03, S.MCBS03),
- ('APRIL', S.MCAS04, S.MCBS04),
- ('MAY', S.MCAS05, S.MCBS05),
- ('JUNE', S.MCAS06, S.MCBS06),
- ('JULY', S.MCAS07, S.MCBS07),
- ('AUGUST', S.MCAS08, S.MCBS08),
- ('SEPTEMBER', S.MCAS09, S.MCBS09),
- ('OCTOBER', S.MCAS10, S.MCBS10),
- ('NOVEMBER', S.MCAS11, S.MCBS11),
- ('DECEMBER', S.MCAS12, S.MCBS12)
- ) AS T(MONTH, ACTUAL, BUDGET)
- WHERE MYEAR = 2016
- AND MINUM = 580
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement