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:31 PM
Views: 2
Tags: no tags
  1. select *, getDATE() as timeNow,
  2. datediff(day, EINGANGSDATUM, getDATE()) as diff
  3. from Vorgaenge
  4. where Erledigt ='Nein'
  5. and Beauftragter like '%{state:Vorgang}%'
  6. or Erledigt ='Nein'
  7. and Kunde like '%{state:Vorgang}%'
  8. order by ID asc