Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: T-SQL
Posted by: Sascha Manns
Added: Apr 17, 2019 2:30 PM
Modified: Apr 23, 2019 6:41 AM
Views: 13
Tags: no tags
  1. select sum(cast(replace(Anteilpreis, ',', '.') as decimal(18,2))) as NettoAnteil,
  2. cast((sum(cast(replace(Anteilpreis, ',', '.') as decimal(18,2)))*1.19) as decimal (18,2)) as BruttoAnteil,
  3. cast((sum(cast(replace(Anteilpreis, ',', '.') as decimal(18,2)))*0.19) as decimal (18,2)) as MwstAnteil,
  4. sum(cast(replace(Gesamtpreis, ',', '.') as decimal(18,2))) as NettoGesamt,
  5. cast((sum(cast(replace(Gesamtpreis, ',', '.') as decimal(18,2)))*1.19) as decimal (18,2)) as BruttoGesamt,
  6. cast((sum(cast(replace(Gesamtpreis, ',', '.') as decimal(18,2)))*0.19) as decimal (18,2)) as MwSTGesamt
  7. from tblbewertungminder
  8. where WENumber = '{state:vin}'