fix bug : TeamID is unique across all leagues

This tutorial will help you learning SQL Server Profiler...

Using tally table and cross apply to divide the date range in weekly. Then apply the period by the period order.

The challenge is to find the minimal set of intervals without creating gaps. There is a table with groups of redundantly overlapping date intervals where each group has no gaps. Given this table, your job is to find the minimum set of date intervals witho