Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,587 reads

Aggregating Intervals

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