aaa, Sql Server - rextester

Language: Layout:

CREATE TABLE tab(
   ProtocolName           VARCHAR(10) NOT NULL 
  ,PacketsDate                                                  DATETIME NOT NULL
  ,PacketsAmount                                                  INTEGER  NOT NULL
  ,Flows                                               INTEGER  NOT NULL
);
INSERT INTO tab VALUES
 ('UPD','01/13/2016 23:55:00',50,10)
,('UPD','01/14/2016 00:02:00',50,10)
,('UPD','01/14/2016 00:03:00',50,10)
,('UPD','01/14/2016 01:10:00',50,10)
,('TCP','01/14/2016 00:00:00',50,10)
,('TCP','01/14/2016 00:03:00',50,10)
,('TCP','01/14/2016 00:10:00',50,10)
,('IPv6','01/13/2016 23:30:00',50,10)
,('IPv6','01/14/2016 00:03:00',50,10)
,('IPv6','01/14/2016 00:45:00',50,10)
,('IPv6','01/14/2016 00:50:00',50,10)
,('IPv6','01/14/2016 01:35:00',50,10)
,('IPv6','01/14/2016 01:33:00',50,10);

CREATE TABLE periods(
   DateFrom DATETIME NOT NULL 
  ,DateTo   DATETIME NOT NULL
);
INSERT INTO periods(DateFrom,DateTo) VALUES
 ('01/13/2016 23:00:00','01/13/2016 23:30:00')
,('01/13/2016 23:30:00','01/14/2016 00:00:00')
,('01/14/2016 00:00:00','01/14/2016 00:30:00')
,('01/14/2016 00:30:00','01/14/2016 01:00:00')
,('01/14/2016 01:00:00','01/14/2016 01:30:00')
,('01/14/2016 01:30:00','01/14/2016 02:00:00');

SELECT p.DateTo,
  UDP_PacketsAmount  = SUM(CASE WHEN ProtocolName = 'UDP' THEN PacketsAmount END),
  TCP_PacketsAmount  = SUM(CASE WHEN ProtocolName = 'TCP' THEN PacketsAmount END),
  IPv6_PacketsAmount = SUM(CASE WHEN ProtocolName = 'IPv6' THEN PacketsAmount END),
  UPD_Flows          = SUM(CASE WHEN ProtocolName = 'UDP' THEN Flows END),
  TCP_Flows          = SUM(CASE WHEN ProtocolName = 'TCP' THEN Flows END), 
  IPv6_Flows         = SUM(CASE WHEN ProtocolName = 'IPv6' THEN Flows END)  
FROM tab t
RIGHT JOIN periods p
  ON t.PacketsDate >= p.DateFrom AND t.PacketsDate < p.DateTo
GROUP BY p.DateTo
ORDER BY p.DateTo

View schema
Execution time: 0,05 sec, rows selected: 6, rows affected: 19, absolute service time: 0,2 sec