Advertisement
Guest User

Untitled

a guest
Apr 7th, 2020
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE status
  2. SET stts_name_de = 'Lastenheft in Ausarbeitung'
  3. WHERE
  4.     stts_type = 'm2Bestell'
  5.     AND
  6.     stts_code = 'LH'
  7.     AND
  8.     stts_active = 1;
  9.    
  10. UPDATE status
  11. SET stts_name_de = 'Ausschreibung'
  12. WHERE
  13.     stts_type = 'm2Bestell'
  14.     AND
  15.     stts_code = 'AU'
  16.     AND
  17.     stts_active = 1;
  18.    
  19. UPDATE status
  20. SET stts_name_de = 'Technische Prüfung'
  21. WHERE
  22.     stts_type = 'm2Bestell'
  23.     AND
  24.     stts_code = 'TP'
  25.     AND
  26.     stts_active = 1;
  27.    
  28. UPDATE status
  29. SET stts_name_de = 'Verhandlung'
  30. WHERE
  31.     stts_type = 'm2Bestell'
  32.     AND
  33.     stts_code = 'VH'
  34.     AND
  35.     stts_active = 1;
  36.    
  37. UPDATE status
  38. SET stts_name_de = 'Gremiendurchlauf Einkauf'
  39. WHERE
  40.     stts_type = 'm2Bestell'
  41.     AND
  42.     stts_code = 'GD'
  43.     AND
  44.     stts_active = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement