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:35 PM
Modified: Apr 23, 2019 6:35 AM
Views: 25
Tags: no tags
  1. select Kategorie, modell, bezeichnung, Preis =
  2.     CONVERT(nvarchar(20),
  3.         case
  4.             when '{state:RepEuro}' != 'Smart Repair' then Preis
  5.             else '140'
  6.         end,
  7.         0
  8.     )
  9. from tblminderwerte
  10. where id = '{state:MinderwertSelect}'