1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
SELECT
Дата,
SUM(IIf(0 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [00-01],
SUM(IIf(1 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [01-02],
SUM(IIf(2 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [02-03],
SUM(IIf(3 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [03-04],
SUM(IIf(4 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [04-05],
SUM(IIf(5 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [05-06],
SUM(IIf(6 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [06-07],
SUM(IIf(7 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [07-08],
SUM(IIf(8 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [08-09],
SUM(IIf(9 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [09-10],
SUM(IIf(10 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [10-11],
SUM(IIf(11 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [11-12],
SUM(IIf(12 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [12-13],
SUM(IIf(13 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [13-14],
SUM(IIf(14 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [14-15],
SUM(IIf(15 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [15-16],
SUM(IIf(16 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [16-17],
SUM(IIf(17 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [17-18],
SUM(IIf(18 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [18-19],
SUM(IIf(19 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [19-20],
SUM(IIf(20 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [20-21],
SUM(IIf(21 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [21-22],
SUM(IIf(22 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [22-23],
SUM(IIf(23 BETWEEN DatePart("h", ВремяНачРаботы) AND DatePart("h", ВремяОкончРаботы), 1, 0)) AS [23-00]
FROM Таблица
WHERE >>Здесь лучше всего фильтровать данные<<
GROUP BY Дата
ORDER BY Дата;
