Calculate mode (or frequency) distribution of a value over time in SQL Server

WITH GroupedValues (Value, Frequency, Hour) AS
    (SELECT
    	Value,
    	COUNT(*) AS Frequency,
    	DATEPART(hh, LogTime) AS Hour
    FROM
    	dbo.MyValues
    GROUP BY
    	Value,
    	DATEPART(hh, LogTime))

SELECT
    MAX(Value) AS Value,
    a.Hour
FROM
    GroupedValues a INNER JOIN
    	(SELECT MAX(Frequency) AS MaxFrequency,
    		Hour FROM GroupedValues GROUP BY Hour) b
    ON a.Frequency = b.MaxFrequency AND a.Hour = b.Hour
GROUP BY
    a.Hour

SELECT
    MAX(Frequency) AS [Mode],
    [Year],[Month],[Day],[Hour]
FROM
    (SELECT
         COUNT(*) AS Frequency,
         DatePart(yy, LogTime) as [Year],
         DatePart(mm, LogTime) as [Month],
         DatePart(dd, LogTime) as [Day],
         DatePart(hh, LogTime) as [Hour]
    FROM
         Values
    GROUP BY
         Value,
         DatePart(yy, LogTime),
         DatePart(mm, LogTime),
         DatePart(dd, LogTime),
         DatePart(hh, LogTime)
    ) foo
GROUP By
    [Year],[Month],[Day],[Hour]