• I've attempted something that is based on your explanation, using J's DDL (many thanks), however, it doesn't return the same result set you have, if I'm reading it correct.

    For starters, I have a value for 00:09:40, but that isn't in your table. I think 01:25:50 is also missing in yours, but it's in mine. Am I missing something?

    SELECT id,

    hist_timestamp,

    DP,

    mints,

    secnds,

    [value],

    mv.MaxValue

    FROM #yourtable yt

    CROSS APPLY (SELECT MAX(ca.value) AS MaxValue

    FROM #yourtable ca

    WHERE ca.hist_timestamp BETWEEN yt.hist_timestamp AND DATEADD(SECOND, 60, yt.hist_timestamp)) mv;

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk