>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_t >>