Home Forums SQL Server 7,2000 T-SQL select query for overlap date range!!! RE: select query for overlap date range!!!

  • October 11, 2004 at 12:31 pm

    #526233

    select distinct a.keycolumn

    from tablex a

           join tablex b ON a.startdate between b.startdate and b.enddate

                             OR a.enddate between b.startdate and b.enddate