API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2018
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.92 KB | None | 0 0
raw download clone embed print report
  1.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  2. SET [How_Long_Delayed] = 60
  3. WHERE [How_Long_Delayed] = '1hr'
  4.  
  5.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  6. SET [How_Long_Delayed] = 5
  7. WHERE [How_Long_Delayed] = '5MIN' OR [How_Long_Delayed]='5 MIN' OR [How_Long_Delayed]='5MINS'
  8.  OR [How_Long_Delayed]='5 MINS' OR [How_Long_Delayed]='5 MINUTES'
  9.    OR [How_Long_Delayed]='5 MNS' OR [How_Long_Delayed]='5MINUTES' OR [How_Long_Delayed]='5MNS'
  10.       OR [How_Long_Delayed]='5MINTUES'  OR [How_Long_Delayed]='5 MINTUES'
  11.  
  12.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  13. SET [How_Long_Delayed] = 30
  14. WHERE [How_Long_Delayed] = '30MIN' OR [How_Long_Delayed]='30 MIN' OR [How_Long_Delayed]='30MINS'
  15.  OR [How_Long_Delayed]='30 MINS' OR [How_Long_Delayed]='30 MINUTES'
  16.   OR [How_Long_Delayed]='30 MNS' OR [How_Long_Delayed]='30MINUTES' OR [How_Long_Delayed]='30MNS'
  17.      OR [How_Long_Delayed]='30MINTUES'  OR [How_Long_Delayed]='30 MINTUES'
  18.  
  19.             UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  20. SET [How_Long_Delayed] = 35
  21. WHERE [How_Long_Delayed] = '35MIN' OR [How_Long_Delayed]='35 MIN' OR [How_Long_Delayed]='35MINS'
  22.  OR [How_Long_Delayed]='35 MINS' OR [How_Long_Delayed]='35 MINUTES'
  23.   OR [How_Long_Delayed]='35 MNS' OR [How_Long_Delayed]='35MINUTES' OR [How_Long_Delayed]='35MNS'
  24.        OR [How_Long_Delayed]='35MINTUES'  OR [How_Long_Delayed]='35 MINTUES'
  25.  
  26.  
  27.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  28. SET [How_Long_Delayed] = 10
  29. WHERE [How_Long_Delayed] = '10MIN' OR [How_Long_Delayed]='10 MIN' OR [How_Long_Delayed]='10MINS'
  30.  OR [How_Long_Delayed]='10 MINS' OR [How_Long_Delayed]='10 MINUTES'
  31.    OR [How_Long_Delayed]='10 MNS' OR [How_Long_Delayed]='10MINUTES' OR [How_Long_Delayed]='10MNS'
  32.         OR [How_Long_Delayed]='10MINTUES'  OR [How_Long_Delayed]='10 MINTUES'
  33.  
  34.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  35. SET [How_Long_Delayed] = 20
  36. WHERE [How_Long_Delayed] = '20MIN' OR [How_Long_Delayed]='20 MIN' OR [How_Long_Delayed]='20MINS'
  37.  OR [How_Long_Delayed]='20 MINS' OR [How_Long_Delayed]='20 MINUTES'
  38.    OR [How_Long_Delayed]='20 MNS' OR [How_Long_Delayed]='20MINUTES' OR [How_Long_Delayed]='20MNS'
  39.       OR [How_Long_Delayed]='20MINTUES'  OR [How_Long_Delayed]='20 MINTUES'
  40.  
  41.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  42. SET [How_Long_Delayed] = 15
  43. WHERE [How_Long_Delayed] = '15MIN' OR [How_Long_Delayed]='15 MIN' OR [How_Long_Delayed]='15MINS'
  44.  OR [How_Long_Delayed]='15 MINS' OR [How_Long_Delayed]='15 MINUTES'
  45.    OR [How_Long_Delayed]='15 MNS' OR [How_Long_Delayed]='15MINUTES' OR [How_Long_Delayed]='15MNS'
  46.    OR [How_Long_Delayed]='15MINTUES'  OR [How_Long_Delayed]='15 MINTUES'
  47.  
  48.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  49. SET [How_Long_Delayed] = 25
  50. WHERE [How_Long_Delayed] = '25MIN' OR [How_Long_Delayed]='25 MIN' OR [How_Long_Delayed]='25MINS'
  51.  OR [How_Long_Delayed]='25 MINS' OR [How_Long_Delayed]='25 MINUTES'
  52.    OR [How_Long_Delayed]='25 MNS' OR [How_Long_Delayed]='25MINUTES' OR [How_Long_Delayed]='25MNS'
  53.            OR [How_Long_Delayed]='25MINTUES'  OR [How_Long_Delayed]='25 MINTUES'
  54.  
  55.                UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  56. SET [How_Long_Delayed] = 40
  57. WHERE [How_Long_Delayed] = '40MIN' OR [How_Long_Delayed]='40 MIN' OR [How_Long_Delayed]='40MINS'
  58.  OR [How_Long_Delayed]='40 MINS' OR [How_Long_Delayed]='40 MINUTES'
  59.    OR [How_Long_Delayed]='40 MNS' OR [How_Long_Delayed]='40MINUTES' OR [How_Long_Delayed]='40MNS'
  60.            OR [How_Long_Delayed]='40MINTUES'  OR [How_Long_Delayed]='40 MINTUES'
  61.  
  62.            UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  63. SET [How_Long_Delayed] = 45
  64. WHERE [How_Long_Delayed] = '45MIN' OR [How_Long_Delayed]='45 MIN' OR [How_Long_Delayed]='45MINS'
  65.  OR [How_Long_Delayed]='45 MINS' OR [How_Long_Delayed]='45 MINUTES'
  66.    OR [How_Long_Delayed]='45 MNS' OR [How_Long_Delayed]='45MINUTES' OR [How_Long_Delayed]='45MNS'
  67.               OR [How_Long_Delayed]='45MINTUES'  OR [How_Long_Delayed]='45 MINTUES'
  68.  
  69.                          UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  70. SET [How_Long_Delayed] = 50
  71. WHERE [How_Long_Delayed] = '50MIN' OR [How_Long_Delayed]='50 MIN' OR [How_Long_Delayed]='50MINS'
  72.  OR [How_Long_Delayed]='50 MINS' OR [How_Long_Delayed]='50 MINUTES'
  73.    OR [How_Long_Delayed]='50 MNS' OR [How_Long_Delayed]='50MINUTES' OR [How_Long_Delayed]='50MNS'
  74.               OR [How_Long_Delayed]='50MINTUES'  OR [How_Long_Delayed]='50 MINTUES'
  75.  
  76.  
  77.             UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  78. SET [How_Long_Delayed] = 60
  79. WHERE [How_Long_Delayed] = '60MIN' OR [How_Long_Delayed]='60 MIN' OR [How_Long_Delayed]='60MINS'
  80.  OR [How_Long_Delayed]='60 MINS' OR [How_Long_Delayed]='60 MINUTES'
  81.    OR [How_Long_Delayed]='60 MNS' OR [How_Long_Delayed]='60MINUTES' OR [How_Long_Delayed]='60MNS'
  82.               OR [How_Long_Delayed]='60MINTUES'  OR [How_Long_Delayed]='60 MINTUES'
  83.  
  84.                           UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  85. SET [How_Long_Delayed] = 105
  86. WHERE [How_Long_Delayed] = '105MIN' OR [How_Long_Delayed]='105 MIN' OR [How_Long_Delayed]='105MINS'
  87.  OR [How_Long_Delayed]='105 MINS' OR [How_Long_Delayed]='105 MINUTES'
  88.    OR [How_Long_Delayed]='105 MNS' OR [How_Long_Delayed]='105MINUTES' OR [How_Long_Delayed]='60MNS'
  89.               OR [How_Long_Delayed]='105MINTUES'  OR [How_Long_Delayed]='105 MINTUES'
  90.  
  91.  
  92.  
  93.  UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  94.  
  95. SET [How_Long_Delayed] = LEFT([How_Long_Delayed],3)
  96.  
  97. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  98. SET [How_Long_Delayed] = 10
  99. WHERE [How_Long_Delayed] = '10-' OR [How_Long_Delayed] = '10/'
  100.  
  101. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  102. SET [How_Long_Delayed] = 15
  103. WHERE [How_Long_Delayed] = '15-' OR [How_Long_Delayed] = '15/' OR [How_Long_Delayed] = '0-1'
  104.  
  105. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  106. SET [How_Long_Delayed] = 20
  107. WHERE [How_Long_Delayed] = '20-' OR [How_Long_Delayed] = '20/'
  108.  
  109. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  110. SET [How_Long_Delayed] = 25
  111. WHERE [How_Long_Delayed] = '25-' OR [How_Long_Delayed] = '25/'
  112.  
  113.  
  114. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  115. SET [How_Long_Delayed] = 30
  116. WHERE [How_Long_Delayed] = '30-' OR [How_Long_Delayed] = '30/'
  117.  
  118. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  119. SET [How_Long_Delayed] = 40
  120. WHERE [How_Long_Delayed] = '31-' OR [How_Long_Delayed] = '31/'
  121.  
  122. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  123. SET [How_Long_Delayed] = 60
  124. WHERE [How_Long_Delayed] = '46-' OR [How_Long_Delayed] = '46/'
  125.  
  126. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  127. SET [How_Long_Delayed] = 75
  128. WHERE [How_Long_Delayed] = '61-' OR [How_Long_Delayed] = '61/'
  129.  
  130. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  131. SET [How_Long_Delayed] = 60
  132. WHERE [How_Long_Delayed] = '1 H' OR [How_Long_Delayed] = '1H'
  133. OR [How_Long_Delayed] = '1HO' OR [How_Long_Delayed] = '1HR'
  134.  
  135. UPDATE  [Projekt].[dbo].[Bus_Breakdown_and_Delays$]
  136. SET [How_Long_Delayed] = 120
  137. WHERE [How_Long_Delayed] = '2 H' OR [How_Long_Delayed] = '2H'
  138. OR [How_Long_Delayed] = '2HO' OR [How_Long_Delayed] = '2HR'
  139.  
  140. DELETE FROM [Projekt].dbo.Bus_Breakdown_and_Delays$
  141. WHERE [How_Long_Delayed]!='5' AND  [How_Long_Delayed]!='10' AND
  142.  [How_Long_Delayed]!='15' AND  [How_Long_Delayed]!='16' AND  [How_Long_Delayed]!='17' AND [How_Long_Delayed]!='18' AND [How_Long_Delayed]!='19' AND
  143.   [How_Long_Delayed]!='20' AND  [How_Long_Delayed]!='25' AND  [How_Long_Delayed]!='30' AND  [How_Long_Delayed]!='35' AND  [How_Long_Delayed]!='40' AND
  144.    [How_Long_Delayed]!='45' AND  [How_Long_Delayed]!='50' AND  [How_Long_Delayed]!='55' AND  [How_Long_Delayed]!='60' AND  [How_Long_Delayed]!='65' AND  [How_Long_Delayed]!='70'
  145.     AND  [How_Long_Delayed]!='75'  AND  [How_Long_Delayed]!='80'  AND  [How_Long_Delayed]!='85'  AND  [How_Long_Delayed]!='90'  AND  [How_Long_Delayed]!='95'  AND  [How_Long_Delayed]!='100'
  146.      AND  [How_Long_Delayed]!='105'  AND  [How_Long_Delayed]!='110' AND  [How_Long_Delayed]!='115' AND  [How_Long_Delayed]!='120'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!