提取从当天起，后两个月生日人员名单 

 1 if object_id('tempdb..#tt')>0 drop table #tt
 2  
 3 --模拟数据
 4  
 5 create table #tt (cc datetime)
 6 insert into #tt values('2013-02-01')
 7 insert into #tt values('2013-05-16')
 8 insert into #tt values('2013-05-21')
 9 insert into #tt values('2013-06-01')
10 insert into #tt values('2013-07-15')
11 insert into #tt values('2013-08-17')
12  
13 insert into #tt values('2014-02-05')
14 insert into #tt values('2014-04-16')
15 insert into #tt values('2014-05-21')
16 insert into #tt values('2014-06-18')
17 insert into #tt values('2014-07-21')
18 insert into #tt values('2014-08-14')
19 insert into #tt values('2014-08-27')
20  
21 select * from #tt
22  
23 --提取数据
24  
25 select *
26 from #tt
27 WHERE CASE WHEN DATEADD(YEAR,DATEDIFF(YEAR,cc,GETDATE()),cc)<GETDATE()
28 THEN DATEADD(YEAR,DATEDIFF(YEAR,cc,GETDATE())+1,cc)
29 ELSE DATEADD(YEAR,DATEDIFF(YEAR,cc,GETDATE()),cc)
30 END BETWEEN GETDATE() AND DATEADD(m,2,GETDATE())

 

posted @ 2014-06-16 20:03  欧迪。  阅读(262)  评论(0)    收藏  举报