You are viewing a single comment's thread. Return to all 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);
Seems like cookies are disabled on this browser, please enable them to open this website
SQL Project Planning
You are viewing a single comment's thread. Return to all comments →