API tools faq
paste
Advertisement
tonytonov

TimeSeriesElements trigger, complex case test

tonytonov
May 13th, 2013
79
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 5.05 KB | None | 0 0
raw download clone embed print report
  1. -- declaring source and target time series
  2. delete from CalcTimeSeries where TSID = 6995
  3. insert into CalcTimeSeries values (6995, 1, 2, 6991, 1, null, null)
  4.  
  5. --cycle 1, accurate refdate usage
  6. delete from TimeSeriesElements where TSID = 6991 or TSID = 6995
  7. declare @correctRefDate datetime
  8. set @correctRefDate = '19830131'
  9. insert into TimeSeriesElements values (6991, 1, '19820129', '19820129', 1, '19820129',null,null,null,null,0,null)
  10. insert into TimeSeriesElements values (6991, 1, '19820226', '19820226', 2, '19820226',null,null,null,null,0,null)
  11. insert into TimeSeriesElements values (6991, 1, '19820331', '19820331', 3, '19820331',null,null,null,null,0,null)
  12. insert into TimeSeriesElements values (6991, 1, '19820430', '19820430', 4, '19820430',null,null,null,null,0,null)
  13. insert into TimeSeriesElements values (6991, 1, '19820531', '19820531', 5, '19820531',null,null,null,null,0,null)
  14. insert into TimeSeriesElements values (6991, 1, '19820630', '19820630', 6, '19820630',null,null,null,null,0,null)
  15. insert into TimeSeriesElements values (6991, 1, '19820730', '19820730', 7, '19820730',null,null,null,null,0,null)
  16. insert into TimeSeriesElements values (6991, 1, '19820831', '19820831', 8, '19820831',null,null,null,null,0,null)
  17. insert into TimeSeriesElements values (6991, 1, '19820930', '19820930', 9, '19820930',null,null,null,null,0,null)
  18. insert into TimeSeriesElements values (6991, 1, '19821029', '19821029', 10, '19821029',null,null,null,null,0,null)
  19. insert into TimeSeriesElements values (6991, 1, '19821130', '19821130', 11, '19821130',null,null,null,null,0,null)
  20. insert into TimeSeriesElements values (6991, 1, '19821231', '19821231', 12, '19821231',null,null,null,null,0,null)
  21. insert into TimeSeriesElements values (6991, 1, '19830331', '19830331', 15, '19830331',null,null,null,null,0,null)
  22. insert into TimeSeriesElements values (6991, 1, @correctRefDate, @correctRefDate, 13, @correctRefDate,null,null,null,null,0,null)
  23. insert into TimeSeriesElements values (6991, 1, @correctRefDate, '19830331', 15, @correctRefDate,null,null,null,null,0,null)
  24. insert into TimeSeriesElements values (6991, 1, @correctRefDate, '19830501', 13, @correctRefDate,null,null,null,null,0,null)
  25. insert into TimeSeriesElements values (6991, 1, '19830430', '19830430', 16, '19830430',null,null,null,null,0,null)
  26. insert into TimeSeriesElements values (6991, 1, '19830630', '19830630', 18, '19830630',null,null,null,null,0,null)
  27. insert into TimeSeriesElements values (6991, 1, '19830830', '19830830', 20, '19830830',null,null,null,null,0,null)
  28. select * from TimeSeriesElements where TSID = 6995
  29. select * from TS_Elements (6995, 1)
  30.  
  31. --cycle 2, accurate refdate usage
  32. delete from TimeSeriesElements where TSID = 6991 or TSID = 6995 or TSID = 6997
  33. declare @incorrectRefDate datetime
  34. set @incorrectRefDate = '19830129'
  35. insert into TimeSeriesElements values (6991, 1, '19820129', '19820129', 1, '19820129',null,null,null,null,0,null)
  36. insert into TimeSeriesElements values (6991, 1, '19820226', '19820226', 2, '19820226',null,null,null,null,0,null)
  37. insert into TimeSeriesElements values (6991, 1, '19820331', '19820331', 3, '19820331',null,null,null,null,0,null)
  38. insert into TimeSeriesElements values (6991, 1, '19820430', '19820430', 4, '19820430',null,null,null,null,0,null)
  39. insert into TimeSeriesElements values (6991, 1, '19820531', '19820531', 5, '19820531',null,null,null,null,0,null)
  40. insert into TimeSeriesElements values (6991, 1, '19820630', '19820630', 6, '19820630',null,null,null,null,0,null)
  41. insert into TimeSeriesElements values (6991, 1, '19820730', '19820730', 7, '19820730',null,null,null,null,0,null)
  42. insert into TimeSeriesElements values (6991, 1, '19820831', '19820831', 8, '19820831',null,null,null,null,0,null)
  43. insert into TimeSeriesElements values (6991, 1, '19820930', '19820930', 9, '19820930',null,null,null,null,0,null)
  44. insert into TimeSeriesElements values (6991, 1, '19821029', '19821029', 10, '19821029',null,null,null,null,0,null)
  45. insert into TimeSeriesElements values (6991, 1, '19821130', '19821130', 11, '19821130',null,null,null,null,0,null)
  46. insert into TimeSeriesElements values (6991, 1, '19821231', '19821231', 12, '19821231',null,null,null,null,0,null)
  47. insert into TimeSeriesElements values (6991, 1, '19830331', '19830331', 15, '19830331',null,null,null,null,0,null)
  48. insert into TimeSeriesElements values (6991, 1, @incorrectRefDate, @incorrectRefDate, 13, @incorrectRefDate,null,null,null,null,0,null)
  49. insert into TimeSeriesElements values (6991, 1, @incorrectRefDate, '19830331', 15, @incorrectRefDate,null,null,null,null,0,null)
  50. insert into TimeSeriesElements values (6991, 1, @incorrectRefDate, '19830501', 13, @incorrectRefDate,null,null,null,null,0,null)
  51. insert into TimeSeriesElements values (6991, 1, '19830430', '19830430', 16, '19830430',null,null,null,null,0,null)
  52. insert into TimeSeriesElements values (6991, 1, '19830630', '19830630', 18, '19830630',null,null,null,null,0,null)
  53. insert into TimeSeriesElements values (6991, 1, '19830830', '19830830', 20, '19830830',null,null,null,null,0,null)
  54. select * from TimeSeriesElements where TSID = 6995
  55. select * from TS_Elements (6995, 1)
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!