select t.*
from table t
where p.starttime < @StartTime and p.EndTime > @EndTime;