SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag calculate elapsed times Rss

Search for any content tagged calculate elapsed times

   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,714 reads

Calculating Elapsed Times (SQL Spackle)

Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.  Read more...
By Dwain Camps 2013/09/26 | Source: SQLServerCentral.com | Category: sql elapsed times
Rating: |  Discuss |   Briefcase | 6,945 reads
   Items 1 to 2 of 2