You are viewing a single comment's thread. Return to all comments →
WITH partitioned AS ( SELECT * , DATEDIFF(start_Date, '1970-01-01') - ROW_NUMBER() OVER (ORDER BY start_Date ASC) AS PartID FROM Projects ) SELECT MIN(start_Date) AS StartDate , MAX(end_date) AS EndDate FROM partitioned GROUP BY PartID ORDER BY COUNT(*) ASC , StartDate ASC
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 →