SQL Project Planning

  • + 2 comments
     select min(Start_Date), max(End_date)
     from (
        select *, day(End_date) - row_number() over (order by end_date) dif
        from Projects) x
    group by dif
    order by datediff(day,min(Start_Date), max(End_date)), min(Start_Date);