create view v as
select d from (
select getdate()-number d from
(select number from master..spt_values where type='p')t
union all
select getdate()+number from
(select number from master..spt_values where type='p')t)t
create view v as
select d from (
select getdate()-number d from
(select number from master..spt_values where type='p')t
union all
select getdate()+number from
(select number from master..spt_values where type='p')t)t