SQL for date ranges, gaps and overlaps

(stewashton) There are lots of questions and posts on the Web about data with date ranges. It’s harder than it seems to design tables with start and end dates, to avoid overlaps or even to write SQL to find gaps or overlaps. I’m writing this post to get some basic ideas straight and to make myself s

Read More - Register for Free Membership