Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SUM_IMPORTI_3.CD_ISTITUTO CD_ISTITUTO,
- SUM_IMPORTI_3.VOCE VOCE,
- SUM(SUM_IMPORTI_3.EQUIVALENTE) EQUIVALENTE,
- SUM(SUM_IMPORTI_3.PONDERATO) PONDERATO
- FROM
- (SELECT <%CONCAT_PRE%>TBRBIRC.C_VOCE<%CONCAT%>TBRBIRC.C_SV<%CONCAT_POS%> VOCE,
- CASE
- WHEN TBRBIRC.C_VOCE = '59062'
- AND TBRBIRC.P00350 = '083'
- THEN TBRBIRC.IMPORTO
- WHEN TBRBIRC.P00350 = '083'
- THEN TBRBIRC.IMPORTO
- ELSE 0
- END EQUIVALENTE,
- CASE
- WHEN TBRBIRC.P00350 = '003'
- THEN TBRBIRC.IMPORTO
- ELSE 0
- END PONDERATO,
- TBRBIRC.CD_ISTITUTO CD_ISTITUTO
- FROM <%schema%>TBRBIRC TBRBIRC
- WHERE TBRBIRC.CD_ISTITUTO = ?
- AND TBRBIRC.DT_RIFERIMENTO = ?
- AND TBRBIRC.KEY_TP_ELABORAZ = ?
- ) SUM_IMPORTI_3
- GROUP BY SUM_IMPORTI_3.CD_ISTITUTO,
- SUM_IMPORTI_3.VOCE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement