SQLite Forum

Help with a query
Login
Chronological Hierarchical 
Thanks for that Harald, I don't / have not use(d) the shell, but can do it in SQLiteExpert.

This is a 48 interval set hope it's ok and not too long, you will note pollDate is shown as, for example, 1899-12-30 this is casued by type mapping comming from sqliteexpert export to sql, the date does show correctly though.

the date part of pollDate is is the same as the pollTime date part only diff is time is also included in pollTime, so should be easy to update that column with the date part of pollTime.

Cheers

DROP TABLE IF EXISTS [readings];
CREATE TABLE [readings]([meterId] INT, [pollDate] datetime, [pollTime] datetime, [interval] INT, [importKwh] INT, [importCost] FLOAT(0, 4), [importKwhRate] FLOAT(0, 4), [periodType] INT, [line1Part] INT, [line2Part] INT, [line3Part] INT, [reversePart] INT, [reverseIncome] FLOAT(0, 4), [reverseKwhRate] FLOAT(0, 4), [kWhsGenerated] INT, [exportIntervalRate] FLOAT(0, 4), [assumedConsumptionBenefit] FLOAT(0, 4), [pfactor] VARCHAR(5), [p1ave] INT, [p2ave] INT, [p3ave] int, [toGrid] int, [selfConsumed] int, [dateCreated] DATETIME, [time_stamp] VARCHAR);

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 06:00:00.000', 12, 16, 0.0224, 0.14, 2, 16, 0, 6, 6, 0.04092, 0.682, 6, 0.681999981403351, 0.0084, ' 100', 160, 0, 64, 0, 6, '2015-01-05 06:58:43.000', '201501050658');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 06:30:00.000', 13, 53, 0.0742, 0.14, 2, 53, 0, 10, 10, 0.0682, 0.682, 10, 0.681999981403351, 0.014, 'C077', 523, 0, 93, 0, 10, '2015-01-05 07:28:43.000', '201501050728');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 07:00:00.000', 14, 11, 0.0154, 0.14, 2, 11, 0, 12, 12, 0.08184, 0.682, 12, 0.681999981403351, 0.0168, 'C011', 98, 0, 121, 0, 12, '2015-01-05 07:58:43.000', '201501050758');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 07:30:00.000', 15, 23, 0.07521, 0.327, 2, 23, 0, 21, 21, 0.14322, 0.682, 21, 0.681999981403351, 0.06867, 'L088', 227, 0, 207, 0, 21, '2015-01-05 08:28:43.000', '201501050828');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 08:00:00.000', 16, 27, 0.04806, 0.178, 1, 27, 0, 34, 34, 0.23188, 0.682, 34, 0.178, 0.0534, 'C094', 311, 0, 344, 4, 30, '2015-01-05 08:58:43.000', '201501050858');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 08:30:00.000', 17, 2, 0.00356, 0.178, 1, 2, 0, 56, 56, 0.38192, 0.682, 56, 0.178, 0.04628, 'C098', 310, 0, 552, 30, 26, '2015-01-05 09:28:43.000', '201501050928');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 09:00:00.000', 18, -1, -0.00178, 0.178, 1, -1, 0, 73, 73, 0.49786, 0.682, 73, 0.178, 0.04094, ' 100', 498, 0, 733, 50, 23, '2015-01-05 09:58:43.000', '201501050958');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 09:30:01.000', 19, 0, 0, 0.178, 1, 0, 0, 81, 81, 0.55242, 0.682, 81, 0.178, 0.04272, 'C098', 567, 0, 810, 57, 24, '2015-01-05 10:28:44.000', '201501051028');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 10:00:00.000', 20, 1, 0.00178, 0.178, 1, 1, 0, 100, 100, 0.682, 0.682, 100, 0.178, 0.09256, 'L099', 484, 0, 1003, 48, 52, '2015-01-05 10:58:43.000', '201501051058');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 10:30:00.000', 21, 0, 0, 0.178, 1, 0, 0, 147, 147, 1.00254, 0.682, 147, 0.178, 0.05874, ' 100', 1140, 0, 1459, 114, 33, '2015-01-05 11:28:43.000', '201501051128');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 11:00:00.000', 22, -1, -0.00178, 0.178, 1, -1, 0, 149, 149, 1.01618, 0.682, 149, 0.178, 0.04628, ' 100', 1220, 0, 1485, 123, 26, '2015-01-05 11:58:43.000', '201501051158');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 11:30:00.000', 23, 0, 0, 0.178, 1, 0, 0, 169, 169, 1.15258, 0.682, 169, 0.178, 0.04984, ' 100', 1411, 0, 1694, 141, 28, '2015-01-05 12:28:43.000', '201501051228');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 12:00:00.000', 24, 1, 0.00178, 0.178, 1, 1, 0, 163, 163, 1.11166, 0.682, 163, 0.178, 0.06052, 'L099', 1291, 0, 1621, 129, 34, '2015-01-05 12:58:43.000', '201501051258');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 12:30:00.000', 25, 0, 0, 0.178, 1, 0, 0, 153, 153, 1.04346, 0.682, 153, 0.178, 0.10502, 'L099', 933, 0, 1525, 94, 59, '2015-01-05 13:28:43.000', '201501051328');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 13:00:00.000', 26, 0, 0, 0.178, 1, 0, 0, 183, 183, 1.24806, 0.682, 183, 0.178, 0.05162, ' 100', 1540, 0, 1827, 154, 29, '2015-01-05 13:58:43.000', '201501051358');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 13:30:00.000', 27, 0, 0, 0.178, 1, 0, 0, 192, 192, 1.30944, 0.682, 192, 0.178, 0.06586, ' 100', 1551, 0, 1918, 155, 37, '2015-01-05 14:28:43.000', '201501051428');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 14:00:00.000', 28, 0, 0, 0.178, 1, 0, 0, 169, 169, 1.15258, 0.682, 169, 0.178, 0.08722, ' 100', 1201, 0, 1690, 120, 49, '2015-01-05 14:58:43.000', '201501051458');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 14:30:00.000', 29, 0, 0, 0.178, 1, 0, 0, 181, 181, 1.23442, 0.682, 181, 0.178, 0.07654, ' 100', 1398, 0, 1815, 138, 43, '2015-01-05 15:28:43.000', '201501051528');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 15:00:00.000', 30, 0, 0, 0.178, 1, 0, 0, 178, 178, 1.21396, 0.682, 178, 0.178, 0.06764, ' 100', 1400, 0, 1776, 140, 38, '2015-01-05 15:58:44.000', '201501051558');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 15:30:00.000', 31, -1, -0.00178, 0.178, 1, -1, 0, 151, 151, 1.02982, 0.682, 151, 0.178, 0.06408, ' 100', 1145, 0, 1515, 115, 36, '2015-01-05 16:28:43.000', '201501051628');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 16:00:00.000', 32, 1, 0.00178, 0.178, 1, 1, 0, 134, 134, 0.91388, 0.682, 134, 0.178, 0.06942, ' 100', 947, 0, 1331, 95, 39, '2015-01-05 16:58:43.000', '201501051658');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 16:30:00.000', 33, -1, -0.00178, 0.178, 1, -1, 0, 114, 114, 0.77748, 0.682, 114, 0.178, 0.05874, ' 100', 804, 0, 1136, 81, 33, '2015-01-05 17:28:43.000', '201501051728');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 17:00:00.000', 34, 1, 0.00178, 0.178, 1, 1, 0, 136, 136, 0.92752, 0.682, 136, 0.178, 0.06052, ' 100', 1022, 0, 1362, 102, 34, '2015-01-05 17:58:43.000', '201501051758');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 17:30:00.000', 35, 0, 0, 0.178, 1, 0, 0, 101, 101, 0.68882, 0.682, 101, 0.178, 0.06408, 'C098', 654, 0, 1009, 65, 36, '2015-01-05 18:28:43.000', '201501051828');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 18:00:00.000', 36, 3, 0.00534, 0.178, 1, 3, 0, 77, 77, 0.52514, 0.682, 77, 0.178, 0.10858, 'L081', 193, 0, 764, 16, 61, '2015-01-05 18:58:43.000', '201501051858');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 18:30:00.000', 37, 1, 0.00178, 0.178, 1, 1, 0, 53, 53, 0.36146, 0.682, 53, 0.178, 0.06408, 'C094', 174, 0, 533, 17, 36, '2015-01-05 19:28:43.000', '201501051928');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 19:00:00.000', 38, 9, 0.01602, 0.178, 1, 9, 0, 24, 24, 0.16368, 0.682, 24, 0.178, 0.03916, 'C066', 118, 0, 237, 2, 22, '2015-01-05 19:58:43.000', '201501051958');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 19:30:00.000', 39, 56, 0.09968, 0.178, 1, 56, 0, 5, 5, 0.0341, 0.682, 5, 0.178, 0.0089, ' 100', 553, 0, 52, 0, 5, '2015-01-05 20:28:43.000', '201501052028');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 20:00:00.000', 40, 19, 0.03382, 0.178, 1, 19, 0, 0, 0, 0, 0.682, 0, 0.178, 0, 'C064', 186, 0, 1, 0, 0, '2015-01-05 20:58:43.000', '201501052058');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 20:30:00.000', 41, 13, 0.02314, 0.178, 1, 13, 0, 0, 0, 0, 0.682, 0, 0.178, 0, 'C092', 138, 0, 0, 0, 0, '2015-01-05 21:28:42.000', '201501052128');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 21:00:00.000', 42, 12, 0.02136, 0.178, 1, 12, 0, 0, 0, 0, 0.682, 0, 0.178, 0, 'C068', 113, 0, 0, 0, 0, '2015-01-05 21:58:43.000', '201501052158');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 21:30:00.000', 43, 27, 0.04806, 0.178, 1, 27, 0, 0, 0, 0, 0.682, 0, 0.178, 0, 'L099', 272, 0, 0, 0, 0, '2015-01-05 22:28:43.000', '201501052228');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 22:00:00.000', 44, 36, 0.06408, 0.178, 1, 36, 0, 0, 0, 0, 0.682, 0, 0.178, 0, 'C093', 358, 0, 0, 0, 0, '2015-01-05 22:58:43.000', '201501052258');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 22:30:00.000', 45, 14, 0.02492, 0.178, 1, 14, 0, 0, 0, 0, 0.682, 0, 0.178, 0, 'C067', 138, 0, 0, 0, 0, '2015-01-05 23:28:43.000', '201501052328');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 23:00:00.000', 46, 12, 0.0168, 0.14, 2, 12, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C093', 124, 0, 0, 0, 0, '2015-01-05 23:58:42.000', '201501052358');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 23:30:00.000', 47, 16, 0.0224, 0.14, 2, 16, 3, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C070', 121, 27, 0, 0, 0, '2015-01-06 00:28:42.000', '201501060028');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-05 23:59:00.000', 48, 197, 0.350659996271133, 0.178000003099442, 2, 197, 173, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'L099', 248, 1723, 0, 0, 0, '2015-01-06 00:58:43.000', '201501060058');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 00:30:00.000', 1, 209, 0.2926, 0.14, 2, 209, 173, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C068', 353, 1731, 0, 0, 0, '2015-01-06 01:28:42.000', '201501060128');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 01:00:00.000', 2, 186, 0.2604, 0.14, 2, 186, 171, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C094', 153, 1710, 0, 0, 0, '2015-01-06 01:58:42.000', '201501060158');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 01:30:00.000', 3, 137, 0.1918, 0.14, 2, 137, 105, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'L098', 313, 1049, 0, 0, 0, '2015-01-06 02:28:42.000', '201501060228');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 02:00:00.000', 4, 43, 0.0602, 0.14, 2, 43, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C093', 431, 0, 0, 0, 0, '2015-01-06 02:58:43.000', '201501060258');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 02:30:00.000', 5, 14, 0.0196, 0.14, 2, 14, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C068', 141, 0, 0, 0, 0, '2015-01-06 03:28:43.000', '201501060328');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 03:00:00.000', 6, 13, 0.0182, 0.14, 2, 13, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C093', 126, 0, 0, 0, 0, '2015-01-06 03:58:42.000', '201501060358');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 03:30:00.000', 7, 12, 0.0168, 0.14, 2, 12, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C068', 120, 0, 0, 0, 0, '2015-01-06 04:28:42.000', '201501060428');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 04:00:00.000', 8, 14, 0.0196, 0.14, 2, 14, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C093', 142, 0, 0, 0, 0, '2015-01-06 04:58:42.000', '201501060458');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 04:30:00.000', 9, 10, 0.014, 0.14, 2, 10, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C094', 103, 0, 0, 0, 0, '2015-01-06 05:28:42.000', '201501060528');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 05:00:00.000', 10, 15, 0.021, 0.14, 2, 15, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C065', 144, 0, 0, 0, 0, '2015-01-06 05:58:43.000', '201501060558');

INSERT INTO [readings]([meterId], [pollDate], [pollTime], [interval], [importKwh], [importCost], [importKwhRate], [periodType], [line1Part], [line2Part], [line3Part], [reversePart], [reverseIncome], [reverseKwhRate], [kWhsGenerated], [exportIntervalRate], [assumedConsumptionBenefit], [pfactor], [p1ave], [p2ave], [p3ave], [toGrid], [selfConsumed], [dateCreated], [time_stamp])
VALUES(5, '1899-12-30 00:00:00.000', '2015-01-06 05:30:00.000', 11, 11, 0.0154, 0.14, 2, 11, 0, 0, 0, 0, 0.682, 0, 0.681999981403351, 0, 'C080', 107, 0, 1, 0, 0, '2015-01-06 06:28:43.000', '201501060628');