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())
