Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Gaps Rss

   Items 1 to 2 of 2   
 

Calculating Gaps Between Overlapping Time Intervals in SQL

There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a number of techniques around that work, but finding ones that scale well makes for a tougher, but interesting, challenge.  Read more...
By Additional Articles 2014/02/28 | Source: SimpleTalk | Category: gaps
Rating: (not yet rated)  Rate this |   Briefcase | 3,226 reads

The SQL of Gaps and Islands in Sequences

Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.  Read more...
By Additional Articles 2013/08/13 | Source: SimpleTalk | Category: gaps
Rating:  Rate this |   Briefcase | 2,342 reads
   Items 1 to 2 of 2   
 
Tags
calculate elapsed times (1)    
lag (1)