Sql Server: How To Detect Date Range Overlaps With Billy Thomas

Use SQL in SQL Server to detect overlapping date ranges. Another way of saying this might be: How do I query for overlapping date ranges.

I will walk you through a real world example and show you how to use SQL to meet the business requirement

00:00 Introduction
01:24 Scenario Setup
04:21 The tables / data
05:50 The View
08:06 The SQL
10:09 Dynamic test

Link for file examples in github:
https://github.com/billythomasalljoydata/yt_examples/tree/165a1957f3ea4cb802a56b3dcded3f28770f84af/sql_detect_overlapping_dates