Advertisement
Guest User

aaaa

a guest
Nov 23rd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. SELECT SUM_IMPORTI_3.CD_ISTITUTO CD_ISTITUTO,
  2. SUM_IMPORTI_3.VOCE VOCE,
  3. SUM(SUM_IMPORTI_3.EQUIVALENTE) EQUIVALENTE,
  4. SUM(SUM_IMPORTI_3.PONDERATO) PONDERATO
  5. FROM
  6. (SELECT <%CONCAT_PRE%>TBRBIRC.C_VOCE<%CONCAT%>TBRBIRC.C_SV<%CONCAT_POS%> VOCE,
  7. CASE
  8. WHEN TBRBIRC.C_VOCE = '59062'
  9. AND TBRBIRC.P00350 = '083'
  10. THEN TBRBIRC.IMPORTO
  11. WHEN TBRBIRC.P00350 = '083'
  12. THEN TBRBIRC.IMPORTO
  13. ELSE 0
  14. END EQUIVALENTE,
  15. CASE
  16. WHEN TBRBIRC.P00350 = '003'
  17. THEN TBRBIRC.IMPORTO
  18. ELSE 0
  19. END PONDERATO,
  20. TBRBIRC.CD_ISTITUTO CD_ISTITUTO
  21. FROM <%schema%>TBRBIRC TBRBIRC
  22. WHERE TBRBIRC.CD_ISTITUTO = ?
  23. AND TBRBIRC.DT_RIFERIMENTO = ?
  24. AND TBRBIRC.KEY_TP_ELABORAZ = ?
  25. ) SUM_IMPORTI_3
  26. GROUP BY SUM_IMPORTI_3.CD_ISTITUTO,
  27. SUM_IMPORTI_3.VOCE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement