TSQL Challenge 31 - Managing multiple overlapping date intervals.
        Posted  
        
        on SQL Server Central
        
        See other posts from SQL Server Central
        
        
        
        Published on 2010/05/31
        Indexed on 
            2010/05/31
            6:03 UTC
        
        
        Read the original article
        Hit count: 267
        
Filed under: 
        This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession
        
        © SQL Server Central or respective owner