Pull Date-Effective Records That Intersect A Given Range
Join the DZone community and get the full member experience.Join For Free
Basics of how to pull records that intersect a date range from a temporal (aka date-effective) database.
-- @rangeStart is the start of the date range of interest -- @rangeEnd is the end of the date range of interest -- If you use null to signify infinity, then use the commented line instead of the one above it. -- Assumes both intervals are [Start, End), ie, start is inclusive, end is exclusive. select * from DateEffectiveTable where StartDate < @rangeEnd and EndDate > @rangeStart -- and coalesce(endDate, '9999-12-31') > @rangeStart