Subversion Repositories Integrator Subversion

SELECT
SUM(D.DIA01) AS dia01,
SUM(D.DIA02) AS dia02,
SUM(D.DIA03) AS dia03,
SUM(D.DIA04) AS dia04,
SUM(D.DIA05) AS dia05,
SUM(D.DIA06) AS dia06,
SUM(D.DIA07) AS dia07,
SUM(D.DIA08) AS dia08,
SUM(D.DIA09) AS dia09,
SUM(D.DIA10) AS dia10,
SUM(D.DIA11) AS dia11,
SUM(D.DIA12) AS dia12,
SUM(D.DIA13) AS dia13,
SUM(D.DIA14) AS dia14,
SUM(D.DIA15) AS dia15,
SUM(D.DIA16) AS dia16,
SUM(D.DIA17) AS dia17,
SUM(D.DIA18) AS dia18,
SUM(D.DIA19) AS dia19,
SUM(D.DIA20) AS dia20,
SUM(D.DIA21) AS dia21,
SUM(D.DIA22) AS dia22,
SUM(D.DIA23) AS dia23,
SUM(D.DIA24) AS dia24,
SUM(D.DIA25) AS dia25,
SUM(D.DIA26) AS dia26,
SUM(D.DIA27) AS dia27,
SUM(D.DIA28) AS dia28,
SUM(D.DIA29) AS dia29,
SUM(D.DIA30) AS dia30,
SUM(D.DIA31) AS dia31
FROM
(
SELECT
CASE DATE(v.dth_venda) WHEN '2015-01-01' THEN SUM(p.val_valor) END AS DIA01,
CASE DATE(v.dth_venda) WHEN '2015-01-02' THEN SUM(p.val_valor) END AS DIA02,
CASE DATE(v.dth_venda) WHEN '2015-01-03' THEN SUM(p.val_valor) END AS DIA03,
CASE DATE(v.dth_venda) WHEN '2015-01-04' THEN SUM(p.val_valor) END AS DIA04,
CASE DATE(v.dth_venda) WHEN '2015-01-05' THEN SUM(p.val_valor) END AS DIA05,
CASE DATE(v.dth_venda) WHEN '2015-01-06' THEN SUM(p.val_valor) END AS DIA06,
CASE DATE(v.dth_venda) WHEN '2015-01-07' THEN SUM(p.val_valor) END AS DIA07,
CASE DATE(v.dth_venda) WHEN '2015-01-08' THEN SUM(p.val_valor) END AS DIA08,
CASE DATE(v.dth_venda) WHEN '2015-01-09' THEN SUM(p.val_valor) END AS DIA09,
CASE DATE(v.dth_venda) WHEN '2015-01-10' THEN SUM(p.val_valor) END AS DIA10,
CASE DATE(v.dth_venda) WHEN '2015-01-11' THEN SUM(p.val_valor) END AS DIA11,
CASE DATE(v.dth_venda) WHEN '2015-01-12' THEN SUM(p.val_valor) END AS DIA12,
CASE DATE(v.dth_venda) WHEN '2015-01-13' THEN SUM(p.val_valor) END AS DIA13,
CASE DATE(v.dth_venda) WHEN '2015-01-14' THEN SUM(p.val_valor) END AS DIA14,
CASE DATE(v.dth_venda) WHEN '2015-01-15' THEN SUM(p.val_valor) END AS DIA15,
CASE DATE(v.dth_venda) WHEN '2015-01-16' THEN SUM(p.val_valor) END AS DIA16,
CASE DATE(v.dth_venda) WHEN '2015-01-17' THEN SUM(p.val_valor) END AS DIA17,
CASE DATE(v.dth_venda) WHEN '2015-01-18' THEN SUM(p.val_valor) END AS DIA18,
CASE DATE(v.dth_venda) WHEN '2015-01-19' THEN SUM(p.val_valor) END AS DIA19,
CASE DATE(v.dth_venda) WHEN '2015-01-20' THEN SUM(p.val_valor) END AS DIA20,
CASE DATE(v.dth_venda) WHEN '2015-01-21' THEN SUM(p.val_valor) END AS DIA21,
CASE DATE(v.dth_venda) WHEN '2015-01-22' THEN SUM(p.val_valor) END AS DIA22,
CASE DATE(v.dth_venda) WHEN '2015-01-23' THEN SUM(p.val_valor) END AS DIA23,
CASE DATE(v.dth_venda) WHEN '2015-01-24' THEN SUM(p.val_valor) END AS DIA24,
CASE DATE(v.dth_venda) WHEN '2015-01-25' THEN SUM(p.val_valor) END AS DIA25,
CASE DATE(v.dth_venda) WHEN '2015-01-26' THEN SUM(p.val_valor) END AS DIA26,
CASE DATE(v.dth_venda) WHEN '2015-01-27' THEN SUM(p.val_valor) END AS DIA27,
CASE DATE(v.dth_venda) WHEN '2015-01-28' THEN SUM(p.val_valor) END AS DIA28,
CASE DATE(v.dth_venda) WHEN '2015-01-29' THEN SUM(p.val_valor) END AS DIA29,
CASE DATE(v.dth_venda) WHEN '2015-01-30' THEN SUM(p.val_valor) END AS DIA30,
CASE DATE(v.dth_venda) WHEN '2015-01-31' THEN SUM(p.val_valor) END AS DIA31
FROM sc_sec.sec_parcela p, sc_sec.sec_venda v, sc_sec.sec_conta_a_receber c
WHERE v.seq_venda = c.seq_venda AND p.seq_conta_a_receber = c.seq_conta_a_receber
GROUP BY DATE(v.dth_venda)
) AS D