You are viewing a single comment's thread. Return to all comments →
with t1 as (Select start_date, row_number() over(order by (SELECT 0)) r1 From Projects Where start_date not in (select end_date from projects)),
t2 as (Select end_date, row_number() over(order by (SELECT 0)) r2 From Projects Where end_date not in (select start_date from projects))
select start_date, end_date from t1, t2 where t1.r1 = t2.r2 order by DATEDIFF(DAY,start_date, end_date), 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 →
with t1 as (Select start_date, row_number() over(order by (SELECT 0)) r1 From Projects Where start_date not in (select end_date from projects)),
t2 as (Select end_date, row_number() over(order by (SELECT 0)) r2 From Projects Where end_date not in (select start_date from projects))
select start_date, end_date from t1, t2 where t1.r1 = t2.r2 order by DATEDIFF(DAY,start_date, end_date), start_date