Optimize Table Matches Based on Count of Matches

How to Use SQL LEAD and LAG Window Functions to Solve Gaps-and-Islands Problems

Using Dynamic SQL and Subqueries in MS SQL: A Deep Dive