在T-SQL中组合日期重叠的行

WITH CTE AS (
    SELECT 
        Start_Date, 
        End_Date, 
        ROW_NUMBER() OVER (PARTITION BY Start_Date ORDER BY End_Date) AS RowNum
    FROM 
        Table1
)
SELECT 
    Start_Date, 
    End_Date
FROM 
    CTE

WITH CTE AS (
    SELECT 
        Start_Date, 
        End_Date, 
        ROW_NUMBER() OVER (PARTITION BY Start_Date ORDER BY End_Date) AS RowNum,
        LAG(End_Date) OVER (ORDER BY Start_Date, End_Date) AS Prev_End_Date
    FROM 
        Table1
)
SELECT 
    Start_Date, 
    CASE 
        WHEN Start_Date <= Prev_End_Date THEN Prev_End_Date
        ELSE End_Date
    END AS End_Date
FROM 
    CTE