SQL Help! - Get quarterly employee payroll results by using Querterly dimension name
Summary
I am getting one row for each payroll by using the following SQL. Please help what I am missing.Content
with gross_pay as (SELECT SSN, PERSON_NAME,balance_name, CASE WHEN TO_CHAR(:pEndDate, 'MM') in ('01', '02', '03') THEN '1'||TO_CHAR(:pEndDate, 'YY')
WHEN TO_CHAR(:pEndDate, 'MM') in ('04', '05', '06') THEN '2'||TO_CHAR(:pEndDate, 'YY')
WHEN TO_CHAR(:pEndDate, 'MM') in ('07', '08', '09') THEN '3'||TO_CHAR(:pEndDate, 'YY')
WHEN TO_CHAR(:pEndDate, 'MM') in ('10', '11', '12') THEN '4'||TO_CHAR(:pEndDate, 'YY')
Tagged:
0