Hi all,
I'm writting a query with CASE, CAST, COALESCE...
Is there any possibility to express this using table object or class mapped?
------------------
SELECT bolletta.numero as nr_doc, bolletta.data_emissione as data_doc,
anagrafica.nome as rag_sociale,
comune.nome as comune, anagrafica.dato_fiscale as p_iva,
CASE WHEN
tariffa.aliquota_iva = 0
THEN
importo
ELSE
0.00
END as fuori_campo,
CASE WHEN
tariffa.aliquota_iva > 0
THEN
importo
ELSE
0.00
END as imponibile,
cast(importo*tariffa.aliquota_iva/100 as decimal(10,2)) as iva,
cast(importo+coalesce(bolletta.imposta_bollo,0)+(importo*tariffa.aliquota_iva/100)
as decimal(10,2)) as totale,
aa_bolletta_na||'/'||nr_bolletta_na as rif_na,
imposta_bollo,bolletta.sezionale
FROM bolletta, comune, anagrafica, figura_aziendale, bolletta_dettaglio,
tariffa
WHERE figura_aziendale.id_anagrafica = anagrafica.id
AND anagrafica.id_comune = comune.id
AND bolletta.cliente = figura_aziendale.id
AND bolletta_dettaglio.cod_tariffa = tariffa.codice
AND bolletta_dettaglio.aa_bolletta = bolletta.anno
AND bolletta_dettaglio.nr_bolletta = bolletta.numero
-----------
jo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
