http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspxWhen working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as "gaps". What are the time ranges that we are fully covering? These are known as "islands". If you'reenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspx#19679Wed, 09 Dec 2009 13:19:54 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19679Adam Machanic<p>Wow! The response to the first T-SQL Tuesday was truly amazing. We ended up with 20 great posts, from</p> http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/12/08/t-sql-tuesday-001-exploring-fuzzy-interval-islands-using-sqlclr.aspx#19717Wed, 09 Dec 2009 22:30:01 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19717Peter Larsson<p>In response to Adam's new series of T-SQL Tuesday, I wanted to write that there are faster ways to get</p>