• And what do you want to do if you have date ranges that overlap?  Are you really still on SQL 2005? SQL 2012 has a feature that makes this much easier.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA