Dudas con asp

[pablinweb]

Si solo te importa la hora en que más se repite pudes agregarle esto:

SELECT TOP 1 COUNT(DATEPART(hour, DT_LOAD)) AS Cantidad, DATEPART(hour, DT_LOAD) AS Hora
FROM O_PROSPECTS_DETAIL
WHERE (DT_LOAD >= CONVERT(DATETIME, '2005-03-09 00:00:00', 102)) AND (DT_LOAD <= CONVERT(DATETIME, '2005-03-09 23:59:59', 102))
GROUP BY DATEPART(hour, DT_LOAD)
ORDER BY COUNT(DATEPART(hour, DT_LOAD)) DESC