如何在SQL Server中合并多行数据直到下一行的值不为null

CREATE TABLE ExampleTable (
    ID INT,
    Value VARCHAR(50)
);

INSERT INTO ExampleTable (ID, Value)
VALUES (1, 'A'), (2, NULL), (3, 'B'), (4, 'C'), (5, NULL), (6, NULL), (7, 'D');

WITH CTE AS (
    SELECT ID, Value, ROW_NUMBER() OVER (ORDER BY ID) AS RowNum
    FROM ExampleTable
), RecursiveCTE AS (
    SELECT ID, Value, RowNum
    FROM CTE
    WHERE RowNum = 1
    
    UNION ALL
    
    SELECT CTE.ID, CASE WHEN CTE.Value IS NULL THEN RecursiveCTE.Value ELSE CTE.Value END, CTE.RowNum
    FROM CTE
    INNER JOIN RecursiveCTE ON CTE.RowNum = RecursiveCTE.RowNum + 1
)
SELECT ID, Value
FROM RecursiveCTE;