TimeSeriesElements trigger, YoY test

insert into TimeSeriesElements values (7607, 1, '20000131', '20000131', 1, '20000131', '20000131', '20000131', '20000131', '20000131', 0, '20000131')
insert into TimeSeriesElements values (7615, 1, '20000131', '20000131', 1, '20000131', '20000131', '20000131', '20000131', '20000131', 0, '20000131')
insert into CalcTimeSeries values(7615, 1, 4, 7607, 1, null, null)
select dbo.GetLatestBday('20010131', 3, 12)
insert into TimeSeriesElements values (7607, 1, '20010131', '20010131', 1, '20010131', '20010131', '20010131', '20010131', '20010131', 0, '20010131')
select * from TimeSeriesElements where TSID = 7607
select * from TimeSeriesElements where TSID = 7615
delete from TimeSeriesElements where TSID = 7607
delete from CalcTimeSeries where TSID = 7615