select sum(cast(replace(Reparaturkosten, ',', '.') as decimal(18,2))) as Reparaturkosten, -- Wichtig: 18,2 bei normalen Operationen
sum(cast(replace(Reparaturkosten, ',', '.') as decimal(18,0)))*1.19 as ReparaturkostenBrutto, -- Wichtig: 18,0 bei Berechnungen
sum(cast(replace(Reparaturkosten, ',', '.') as decimal(18,0)))*0.19 as ReparaturkostenMwST, -- Produziert sonst 4 Nachkommastellen
sum(cast(replace(Minderwert, ',', '.') as decimal(18,2))) as Minderwert,
sum(cast(replace(Minderwert, ',', '.') as decimal(18,0)))*1.19 as MinderwertBrutto,
sum(cast(replace(Minderwert, ',', '.') as decimal(18,0)))*0.19 as MinderwertMwST,
(sum(cast(replace(Minderwert, ',', '.') as decimal(18,2)))+sum(cast(replace(Reparaturkosten, ',', '.') as decimal(18,2)))) as Gesamt,
(sum(cast(replace(Minderwert, ',', '.') as decimal(18,0)))+sum(cast(replace(Reparaturkosten, ',', '.') as decimal(18,0))))*1.19 as GesamtBrutto,
(sum(cast(replace(Minderwert, ',', '.') as decimal(18,0)))+sum(cast(replace(Reparaturkosten, ',', '.') as decimal(18,0))))*0.19 as GesamtMWsT
from BewertungFoto
where WENumber = '{state:vin}'
Loading...