Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Effective Dates Rss

   Items 1 to 2 of 2   

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,220 reads

Aggregating Intervals

create intervals from effective dates and aggregate like and adjacent intervals  Read more...
By Michael LeClair 2012/10/03 | Source: | Category: effective dates
Rating: (not yet rated) |  Discuss |   Briefcase | 903 reads
   Items 1 to 2 of 2   
aggregate intervals (1)    
performance (1)    
t-sql (1)