--select sum(Anteilpreis) as NettoAnteil,
--Select sum(convert(Anteilspreis (varchar(20)))) as Nettoanteil
select sum(cast(replace(Anteilpreis, ',', '.') as decimal(18,2))) as NettoAnteil,
sum(cast(replace(Anteilpreis, ',', '.') as decimal(18,2)))*1.19 as BruttoAnteil,
--sum(Anteilpreis)*1.19 as BruttoAnteil,
sum(cast(replace(Anteilpreis, ',', '.') as decimal(18,2)))*0.19 as MwstAnteil,
--sum(Anteilpreis)*0.19 as MwstAnteil,
sum(cast(replace(Gesamtpreis, ',', '.') as decimal(18,2))) as NettoGesamt,
--sum(Gesamtpreis) as NettoGesamt,
cast((sum(cast(replace(Gesamtpreis, ',', '.') as decimal(18,2)))*1.19) as decimal(18,2)) as BruttoGesamt,
--sum(Gesamtpreis)*1.19 as BruttoGesamt,
cast((sum(cast(replace(Gesamtpreis, ',', '.') as decimal(18,2)))*0.19) as decimal(18,2)) as MwstGesamt
--sum(Gesamtpreis)*0.19 as MwstGesamt
--Round(cast(BruttoGesamt as decimal (18,2)),-3) as BruttoGesamt
from tblbewertungminder
where WENumber = '$state.vin'
Loading...