1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
create table calendrier
(operation varchar(50),
jour date
)
insert into calendrier values('operation1','2013-04-04')
insert into calendrier values('operation2','2013-10-25')
insert into calendrier values('operation3','2013-12-13')
insert into calendrier values('operation4','2013-12-26')
insert into calendrier values('operation5','2013-12-30')
insert into calendrier values('operation6','2013-12-31')
insert into calendrier values('operation7','2014-01-01')
select *,datediff(day,LEAD(jour,1)over(order by operation),jour) from calendrier |
Partager