In SQL Server, how do I relate each date in a set to the subsequent date from the same set?
Unless you're on a very old version of SQL Server, the LEAD function should work.
SELECT 
    MyDate AS CurrentDate,
    LEAD(MyDate, 1, NULL) OVER
    (
        ORDER BY
            MyDate
    ) AS NextDate
FROM #Dates
ORDER BY CurrentDate;