API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 1.80 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM importrate.rates WHERE ticker_id in (
  2. 17965, --                   ACB Rating
  3. 13211, --                   ADCV5
  4. 17969, --                   BMO Rating
  5. 17970, --                   CIB Rating
  6. 17966, --                   COE Rating
  7. 17968, --                   FMB Rating
  8. 17975, --                   FNB Rating
  9. 17967, --                   FTB Rating
  10. 17556, --                   GBPJPY2M
  11. 17557, --                   GBPJPY3M
  12. 17976, --                   GBP Rating
  13. 17977, --                   HNB Rating
  14. 17978, --                   JGL Rating
  15. 17971, --                   KBC Rating
  16. 17972, --                   KEY Rating
  17. 17973, --                   NCB Rating
  18. 17974, --                   NLB Rating
  19. 17982, --                   NOT Rating
  20. 17981, --                   ONB Rating
  21. 17980, --                   RBC Rating
  22. 17984, --                   SCB Rating
  23. 17986, --                   SCO Rating
  24. 17979, --                   SMF Rating
  25. 17983, --                   SUN Rating
  26. 17985, --                   SVB Rating
  27. 17989, --                   TOR Rating
  28. 17988, --                   UBC Rating
  29. 17987 --                    ZBC Rating
  30. );
  31.  
  32. DELETE FROM importrate.tickers WHERE id in (
  33. 17965, --                   ACB Rating
  34. 13211, --                   ADCV5
  35. 17969, --                   BMO Rating
  36. 17970, --                   CIB Rating
  37. 17966, --                   COE Rating
  38. 17968, --                   FMB Rating
  39. 17975, --                   FNB Rating
  40. 17967, --                   FTB Rating
  41. 17556, --                   GBPJPY2M
  42. 17557, --                   GBPJPY3M
  43. 17976, --                   GBP Rating
  44. 17977, --                   HNB Rating
  45. 17978, --                   JGL Rating
  46. 17971, --                   KBC Rating
  47. 17972, --                   KEY Rating
  48. 17973, --                   NCB Rating
  49. 17974, --                   NLB Rating
  50. 17982, --                   NOT Rating
  51. 17981, --                   ONB Rating
  52. 17980, --                   RBC Rating
  53. 17984, --                   SCB Rating
  54. 17986, --                   SCO Rating
  55. 17979, --                   SMF Rating
  56. 17983, --                   SUN Rating
  57. 17985, --                   SVB Rating
  58. 17989, --                   TOR Rating
  59. 17988, --                   UBC Rating
  60. 17987 --                    ZBC Rating
  61. );
  62.  
  63. UPDATE importrate.rates SET ticker_id = 16825 WHERE ticker_id = 17745; --NKBP12M
  64. UPDATE importrate.rates SET ticker_id = 16826 WHERE ticker_id = 17746; --NKBP15M
  65. UPDATE importrate.rates SET ticker_id = 16827 WHERE ticker_id = 17747; --NKBP18M
  66.  
  67. UPDATE importrate.tickers SET suid = trim(suid);
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!