select * from 表
where dateadd(dd,定时提醒天数,getdate())>时间1
union all
select * from 表
where dateadd(dd,定时提醒天数,getdate())>时间2
union all
select * from 表
where dateadd(dd,定时提醒天数,getdate())>时间3
效率 高!
insert into @t select '2005-01-01','2006-03-27','2003-05-02',2
insert into @t select '2005-12-11','2003-03-22','2004-01-14',3
insert into @t select '2007-01-02','2007-01-02','2007-01-02',1
select * from @t where dateadd(day,定时提醒天数,getdate())>时间1 or dateadd(day,定时提醒天数,getdate())>时间2 or dateadd(day,定时提醒天数,getdate())>时间3
--这样?