declare @tb table([startDate] datetime,[endDate] datetime)
insert @tb
select '2009/01/15','2009/02/15' union all
select '2009/03/20','2009/04/15' union all
select '2009/04/16','2010/01/19'
select * from @tb
where startDate > ''2009/01/15'' AND ('2009/03/19' between startDate and endDate
or '2009/05/19' between startDate and endDate
OR startDate BETWEEN '2009/03/19' AND '2009/05/19'
OR endDate BETWEEN '2009/03/19' AND '2009/05/19'
)
AND BST_ID NOT IN(22) --修改时用到