SELECT lnPayRecID AS pay_rec_id,; ldStartDate AS st_dte, ldEndDate AS end_dte,; service_id, cst_frml, cst_coef, ano_frml, ano_coef,; adj_frml, adj_coef, cpi_frml, COUNT(*) AS srv_days,; SUM(IIF(EMPTY(date_calc),0,1)) AS calc_days,; SUM(IIF(EMPTY(date_calc),0.00,NVL(contract_base,0.00))) AS cntr_base ,; SUM(IIF(EMPTY(date_calc),0.00,NVL(contract_anomaly,0.00))) AS cntr_ano,; SUM(IIF(EMPTY(date_calc),0.00,NVL(contract_adjustment,0.00))) AS cntr_adj,; SUM(IIF(EMPTY(date_calc),0.00,NVL(contract_total,0.00))) AS cntr_total,; SUM(IIF(EMPTY(date_appr),0,1)) AS appr_days,; SUM(IIF(EMPTY(date_appr),0.00,NVL(appr_final,0.00))) AS cntr_appr ; FROM cutemp; GROUP BY service_id,cst_frml,cst_coef,ano_frml, ano_coef, adj_frml, ; adj_coef, cpi_frml ; INTO CURSOR new_tThanks,