if object_id(‘tempdb..#tt‘)>0 drop table #tt

--模拟数据

create table #tt (cc datetime)
insert into #tt values(‘2013-02-01‘)
insert into #tt values(‘2013-05-16‘)
insert into #tt values(‘2013-05-21‘)
insert into #tt values(‘2013-06-01‘)
insert into #tt values(‘2013-07-15‘)
insert into #tt values(‘2013-08-17‘)

insert into #tt values(‘2014-02-05‘)
insert into #tt values(‘2014-04-16‘)
insert into #tt values(‘2014-05-21‘)
insert into #tt values(‘2014-06-18‘)
insert into #tt values(‘2014-07-21‘)
insert into #tt values(‘2014-08-14‘)
insert into #tt values(‘2014-08-27‘)

select * from #tt

--提取数据

select *
from #tt
WHERE CASE WHEN DATEADD(YEAR,DATEDIFF(YEAR,cc,GETDATE()),cc)<GETDATE()
THEN DATEADD(YEAR,DATEDIFF(YEAR,cc,GETDATE())+1,cc)
ELSE DATEADD(YEAR,DATEDIFF(YEAR,cc,GETDATE()),cc)
END BETWEEN GETDATE() AND DATEADD(m,2,GETDATE())