TimeSeriesElements trigger, currency conversion test

--3 - 20 - 2
--1 - 20 - 8
--benchmark 20: spot 4, converted 32
--spot 4, converted 32
--3 - 23 - 4
--1 - 23 - 8
--benchmark 23: spot 2, converted 16
--spot 2, converted 16
--3 - 24 - 2
--1 - 24 - 8
--benchmark 24: spot 4, converted 32
--spot 4, converted 32
--3 - 25 - 5
--1 - 25 - 15
--benchmark 25: spot 3, converted 45
--spot 3, converted 45
--3 - 27 - 15
--1 - 26 - 10
--1 - 27 - 20
--benchmark 26: spot 1, converted 20 (if locf)
--spot NA, converted 20
--benchmark 27: spot 1.33, converted 26.66
--spot 1.33, converted 26.66
--3 - 25 - 20
--benchmark 26: spot 0.5, converted 5 (if locf)
--3 - 26 - 10
--benchmark 26: spot 1, converted 10
--spot 1, converted 20

--*
select top 20 * from dbo.TimeSeriesElements t where t.TSID=1 and t.RefDate>='20120420' order by t.RefDate desc
select top 20 * from dbo.TimeSeriesElements t where t.TSID=3 and t.RefDate>='20120420' order by t.RefDate desc
select * from TimeSeriesElements where TSID = 137 and RefDate>='20120420' order by RefDate desc
select * from dbo.FXSpotPrices (12,2,'20120420','20120427',1) order by RefDate desc
--*

insert into TimeSeriesElements values (3, 1, '20120420', '20120420', 2, '20120420')
insert into TimeSeriesElements values (1, 1, '20120420', '20120420', 8, '20120420')
--*
insert into TimeSeriesElements values (3, 1, '20120423', '20120423', 4, '20120423')
insert into TimeSeriesElements values (1, 1, '20120423', '20120423', 8, '20120423')
--*
insert into TimeSeriesElements values (3, 1, '20120424', '20120424', 2, '20120424')
--*
insert into TimeSeriesElements values (1, 1, '20120424', '20120424', 8, '20120424')
--*
insert into TimeSeriesElements values (3, 1, '20120425', '20120425', 5, '20120425')
insert into TimeSeriesElements values (1, 1, '20120425', '20120425', 15, '20120425')
--*
insert into TimeSeriesElements values (3, 1, '20120427', '20120427', 15, '20120427')
insert into TimeSeriesElements values (1, 1, '20120426', '20120426', 10, '20120426')
insert into TimeSeriesElements values (1, 1, '20120427', '20120427', 20, '20120427')
--*
insert into TimeSeriesElements values (3, 1, '20120426', '20120426', 10, '20120426')
--*
delete from TimeSeriesElements where RefDate >= '20120420' and TSID = 1
delete from TimeSeriesElements where RefDate >= '20120420' and TSID = 3