We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Advanced Join
- SQL Project Planning
- Discussions
SQL Project Planning
SQL Project Planning
Sort by
recency
|
1343 Discussions
|
Please Login in order to post a comment
WITH ProjectGroup AS( SELECT Start_Date, End_Date, DATEDIFF(day, '1900-01-01', End_Date) - ROW_NUMBER() OVER(order by End_Date) AS Consecutive_Date_Group FROM Projects ), ProjectCompletion AS ( SELECT MIN(Start_Date) AS Date_Start, MAX(End_Date) AS Date_End, COUNT(Consecutive_Date_Group) AS Day_Complete FROM ProjectGroup GROUP BY Consecutive_Date_Group )
SELECT Date_Start, Date_End FROM ProjectCompletion ORDER BY Day_Complete, Date_Start
Check out the complete video solution here - https://www.youtube.com/watch?v=JFud6Ui4dOU
Using Recursion
)
SELECT Start_Dte, End_Dte FROM CTE4