December 8, 2009 at 7:55 am
A customer has requested a report of instances where a log entry was not made for a client.
A simplified version of the client log table (for purpose of this example) contains 3 columns:
Log ID, Client ID, Log Entry Time
Each time a log entry is made for a client, the log entry time is timestamped in the table.
Their business rule is that each client must have at least one log entry per shift per day (the shifts being 07:30 to 16:30 and 16:30 to 23:30).
The report needs to return for each client a list of 'missing' log entries between 2 dates (parameterized), that is to say each daily shift where there is no log entry for the client during the period. The code will be going into a SQL 2000 stored proc to be referenced by the client's reporting tool (Crystal).
Can this be done with a set-based solution, without building a reference table that would contain all dates/shifts for the next period of years and using a cursor to compare each client's existing records to the 'potential' records?
Scripts for the test table and one month of sample data are included below. Any ideas would be appreciated.
Thanks.
Tim Harding
Test Table:
CREATE TABLE [dbo].[zLogEntries] (
[log_ID] [int] IDENTITY(1, 1) NOT NULL,
[client_ID] [int] NOT NULL,
[log_time] [smalldatetime] NOT NULL
)
GO
ALTER TABLE [dbo].[zLogEntries]
ADD
CONSTRAINT [PK_Table_1]
PRIMARY KEY
CLUSTERED
([log_ID])
GO
Test Data:
SET IDENTITY_INSERT [dbo].[zLogEntries] ON
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (1, 9824, '20090901 13:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (2, 9824, '20090901 21:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (3, 9824, '20090902 14:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (4, 9824, '20090903 14:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (5, 9824, '20090903 21:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (6, 9824, '20090904 14:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (7, 9824, '20090905 22:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (8, 9824, '20090906 12:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (9, 9824, '20090906 23:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (10, 9824, '20090907 23:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (11, 9824, '20090908 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (12, 9824, '20090909 08:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (13, 9824, '20090909 22:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (14, 9824, '20090911 22:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (15, 9824, '20090912 14:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (16, 9824, '20090912 21:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (17, 9824, '20090913 14:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (18, 9824, '20090914 22:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (19, 9824, '20090915 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (20, 9824, '20090915 22:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (21, 9824, '20090916 15:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (22, 9824, '20090916 23:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (23, 9824, '20090917 14:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (24, 9824, '20090919 21:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (25, 9824, '20090920 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (26, 9824, '20090921 22:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (27, 9824, '20090922 22:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (28, 9824, '20090923 08:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (29, 9824, '20090923 08:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (30, 9824, '20090923 15:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (31, 9824, '20090923 15:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (32, 9824, '20090923 15:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (33, 9824, '20090923 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (34, 9824, '20090924 15:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (35, 9824, '20090924 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (36, 9824, '20090926 12:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (37, 9824, '20090926 23:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (38, 9824, '20090927 22:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (39, 9824, '20090928 14:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (40, 9824, '20090928 21:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (41, 9824, '20090928 21:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (42, 10564, '20090910 14:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (43, 10564, '20090911 14:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (44, 10564, '20090914 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (45, 10564, '20090915 14:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (46, 10564, '20090916 15:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (47, 10564, '20090917 15:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (48, 10564, '20090918 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (49, 10564, '20090922 08:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (50, 10564, '20090922 14:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (51, 10564, '20090924 15:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (52, 10564, '20090928 14:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (53, 10564, '20090928 14:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (54, 10564, '20090929 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (55, 10574, '20090901 22:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (56, 10574, '20090902 22:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (57, 10574, '20090904 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (58, 10574, '20090905 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (59, 10574, '20090906 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (60, 10574, '20090907 22:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (61, 10574, '20090908 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (62, 10574, '20090910 23:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (63, 10574, '20090913 23:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (64, 10574, '20090915 23:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (65, 10574, '20090920 22:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (66, 10574, '20090923 23:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (67, 10574, '20090925 23:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (68, 10605, '20090909 14:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (69, 10605, '20090909 22:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (70, 10605, '20090910 15:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (71, 10605, '20090910 21:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (72, 10605, '20090914 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (73, 10605, '20090915 22:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (74, 10605, '20090916 22:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (75, 10605, '20090917 14:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (76, 10605, '20090917 21:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (77, 10605, '20090922 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (78, 10605, '20090922 22:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (79, 10605, '20090923 14:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (80, 10605, '20090923 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (81, 10605, '20090924 14:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (82, 10605, '20090927 21:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (83, 10605, '20090928 14:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (84, 10605, '20090928 21:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (85, 10605, '20090929 13:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (86, 10605, '20090929 21:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (87, 11184, '20090901 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (88, 11184, '20090903 14:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (89, 11184, '20090903 21:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (90, 11184, '20090904 13:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (91, 11184, '20090905 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (92, 11184, '20090906 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (93, 11184, '20090906 23:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (94, 11184, '20090907 23:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (95, 11184, '20090908 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (96, 11184, '20090909 08:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (97, 11184, '20090909 21:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (98, 11184, '20090911 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (99, 11534, '20090901 15:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (100, 11534, '20090901 23:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (101, 11534, '20090902 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (102, 11534, '20090903 22:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (103, 11534, '20090904 15:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (104, 11534, '20090905 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (105, 11534, '20090906 10:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (106, 11534, '20090906 14:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (107, 11534, '20090906 22:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (108, 11534, '20090907 14:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (109, 11534, '20090909 23:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (110, 11534, '20090910 23:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (111, 11534, '20090911 22:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (112, 11534, '20090912 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (113, 11534, '20090912 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (114, 11534, '20090913 22:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (115, 11534, '20090918 22:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (116, 11534, '20090919 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (117, 11534, '20090920 12:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (118, 11534, '20090920 22:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (119, 11534, '20090923 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (120, 11534, '20090925 09:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (121, 11534, '20090925 13:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (122, 11534, '20090926 15:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (123, 11534, '20090927 15:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (124, 11534, '20090927 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (125, 11534, '20090928 22:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (126, 11534, '20090929 22:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (127, 11714, '20090901 22:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (128, 11714, '20090902 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (129, 11714, '20090905 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (130, 11714, '20090906 15:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (131, 11714, '20090907 22:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (132, 11714, '20090908 23:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (133, 11714, '20090910 23:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (134, 11714, '20090912 22:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (135, 11714, '20090913 23:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (136, 11714, '20090915 14:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (137, 11714, '20090915 23:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (138, 11714, '20090920 22:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (139, 11714, '20090923 22:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (140, 11714, '20090925 23:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (141, 11714, '20090929 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (142, 12364, '20090901 22:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (143, 12364, '20090902 22:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (144, 12364, '20090905 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (145, 12364, '20090907 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (146, 12364, '20090908 23:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (147, 12364, '20090910 23:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (148, 12364, '20090912 22:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (149, 12364, '20090913 23:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (150, 12364, '20090915 23:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (151, 12364, '20090920 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (152, 12364, '20090923 23:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (153, 12364, '20090925 23:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (154, 12364, '20090929 23:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (155, 12366, '20090905 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (156, 12366, '20090912 14:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (157, 12366, '20090912 21:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (158, 12366, '20090913 14:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (159, 12366, '20090914 09:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (160, 12366, '20090914 22:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (161, 12366, '20090915 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (162, 12366, '20090915 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (163, 12514, '20090901 22:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (164, 12514, '20090902 22:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (165, 12514, '20090902 22:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (166, 12514, '20090905 15:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (167, 12714, '20090901 23:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (168, 12714, '20090902 15:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (169, 12714, '20090902 23:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (170, 12714, '20090903 15:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (171, 12714, '20090903 22:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (172, 12714, '20090904 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (173, 12714, '20090904 23:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (174, 12714, '20090905 15:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (175, 12714, '20090905 23:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (176, 12714, '20090906 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (177, 12714, '20090906 22:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (178, 12714, '20090907 13:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (179, 12714, '20090907 21:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (180, 12714, '20090908 13:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (181, 12714, '20090908 15:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (182, 12714, '20090908 23:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (183, 12714, '20090909 15:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (184, 12714, '20090909 23:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (185, 12714, '20090910 23:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (186, 12714, '20090911 15:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (187, 12714, '20090911 22:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (188, 12714, '20090912 14:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (189, 12714, '20090912 22:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (190, 12714, '20090913 15:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (191, 12714, '20090913 21:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (192, 12714, '20090914 23:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (193, 12714, '20090915 14:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (194, 12714, '20090916 15:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (195, 12714, '20090916 22:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (196, 12714, '20090917 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (197, 12714, '20090918 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (198, 12714, '20090918 23:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (199, 12714, '20090919 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (200, 12714, '20090919 22:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (201, 12714, '20090920 15:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (202, 12714, '20090920 21:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (203, 12714, '20090921 15:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (204, 12714, '20090921 22:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (205, 12714, '20090922 16:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (206, 12714, '20090922 21:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (207, 12714, '20090923 20:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (208, 12714, '20090923 22:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (209, 12714, '20090924 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (210, 12714, '20090924 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (211, 12714, '20090925 15:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (212, 12714, '20090925 22:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (213, 12714, '20090926 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (214, 12714, '20090927 15:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (215, 12714, '20090927 23:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (216, 12714, '20090928 15:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (217, 12714, '20090928 21:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (218, 12714, '20090929 13:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (219, 12714, '20090929 22:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (220, 12784, '20090907 22:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (221, 12784, '20090908 23:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (222, 12784, '20090910 23:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (223, 12784, '20090912 22:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (224, 12784, '20090913 23:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (225, 12784, '20090915 23:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (226, 12784, '20090920 22:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (227, 12784, '20090929 22:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (228, 12944, '20090901 22:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (229, 12944, '20090903 14:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (230, 12944, '20090903 21:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (231, 12944, '20090904 14:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (232, 12944, '20090904 22:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (233, 12944, '20090905 22:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (234, 12944, '20090906 12:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (235, 12944, '20090906 23:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (236, 12944, '20090907 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (237, 12944, '20090908 22:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (238, 12944, '20090909 08:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (239, 12944, '20090909 22:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (240, 12944, '20090911 20:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (241, 12944, '20090911 22:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (242, 12944, '20090912 14:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (243, 12944, '20090912 21:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (244, 12944, '20090913 14:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (245, 12944, '20090914 22:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (246, 12944, '20090915 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (247, 12944, '20090915 22:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (248, 12944, '20090916 15:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (249, 12944, '20090916 23:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (250, 12944, '20090917 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (251, 12944, '20090918 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (252, 12944, '20090919 21:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (253, 12944, '20090920 22:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (254, 12944, '20090921 22:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (255, 12944, '20090922 22:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (256, 12944, '20090923 08:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (257, 12944, '20090923 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (258, 12944, '20090923 22:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (259, 12944, '20090924 15:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (260, 12944, '20090926 12:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (261, 12944, '20090926 23:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (262, 12944, '20090927 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (263, 12944, '20090928 14:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (264, 12944, '20090928 21:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (265, 12944, '20090928 21:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (266, 13124, '20090902 22:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (267, 13124, '20090902 22:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (268, 13124, '20090915 14:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (269, 13124, '20090920 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (270, 13154, '20090901 23:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (271, 13154, '20090905 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (272, 13154, '20090910 13:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (273, 13154, '20090910 13:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (274, 13154, '20090912 22:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (275, 13154, '20090914 09:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (276, 13154, '20090915 09:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (277, 13154, '20090915 23:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (278, 13154, '20090918 09:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (279, 13154, '20090918 14:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (280, 13154, '20090920 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (281, 13154, '20090922 09:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (282, 13154, '20090922 14:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (283, 13154, '20090925 14:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (284, 13154, '20090925 14:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (285, 13154, '20090929 14:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (286, 13154, '20090929 14:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (287, 13504, '20090920 22:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (288, 13504, '20090922 14:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (289, 13504, '20090925 14:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (290, 13504, '20090925 14:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (291, 13504, '20090929 14:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (292, 13504, '20090929 14:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (293, 13504, '20090929 22:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (294, 13514, '20090901 23:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (295, 13514, '20090902 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (296, 13514, '20090902 23:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (297, 13514, '20090903 15:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (298, 13514, '20090903 22:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (299, 13514, '20090904 15:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (300, 13514, '20090904 23:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (301, 13514, '20090905 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (302, 13514, '20090905 22:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (303, 13514, '20090906 15:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (304, 13514, '20090906 22:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (305, 13514, '20090907 13:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (306, 13514, '20090907 20:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (307, 13514, '20090908 22:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (308, 13514, '20090909 21:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (309, 13514, '20090911 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (310, 13514, '20090911 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (311, 13514, '20090912 14:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (312, 13514, '20090912 22:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (313, 13514, '20090913 15:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (314, 13514, '20090913 21:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (315, 13514, '20090914 23:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (316, 13514, '20090915 13:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (317, 13514, '20090916 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (318, 13514, '20090916 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (319, 13514, '20090917 14:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (320, 13514, '20090917 22:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (321, 13514, '20090918 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (322, 13514, '20090918 21:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (323, 13514, '20090919 09:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (324, 13514, '20090919 21:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (325, 13514, '20090920 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (326, 13514, '20090920 21:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (327, 13514, '20090921 15:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (328, 13514, '20090921 22:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (329, 13514, '20090922 16:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (330, 13514, '20090922 21:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (331, 13514, '20090923 20:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (332, 13514, '20090923 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (333, 13514, '20090923 23:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (334, 13514, '20090924 14:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (335, 13514, '20090924 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (336, 13514, '20090925 09:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (337, 13514, '20090925 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (338, 13514, '20090926 15:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (339, 13514, '20090927 15:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (340, 13514, '20090927 21:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (341, 13514, '20090928 14:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (342, 13514, '20090928 22:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (343, 13514, '20090929 12:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (344, 13514, '20090929 22:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (345, 13674, '20090901 23:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (346, 13674, '20090901 23:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (347, 13674, '20090902 14:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (348, 13674, '20090902 14:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (349, 13674, '20090902 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (350, 13674, '20090902 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (351, 13674, '20090903 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (352, 13674, '20090903 15:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (353, 13674, '20090903 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (354, 13674, '20090903 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (355, 13674, '20090904 14:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (356, 13674, '20090904 14:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (357, 13674, '20090904 23:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (358, 13674, '20090905 15:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (359, 13674, '20090905 15:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (360, 13674, '20090905 23:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (361, 13674, '20090905 23:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (362, 13674, '20090906 15:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (363, 13674, '20090906 15:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (364, 13674, '20090906 22:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (365, 13674, '20090907 13:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (366, 13674, '20090907 21:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (367, 13674, '20090907 21:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (368, 13674, '20090908 13:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (369, 13674, '20090908 13:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (370, 13674, '20090908 22:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (371, 13674, '20090908 22:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (372, 13674, '20090909 14:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (373, 13674, '20090909 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (374, 13674, '20090909 21:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (375, 13674, '20090909 21:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (376, 13674, '20090911 12:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (377, 13674, '20090911 21:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (378, 13674, '20090912 14:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (379, 13674, '20090913 21:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (380, 13674, '20090913 21:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (381, 13674, '20090914 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (382, 13674, '20090914 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (383, 13674, '20090915 08:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (384, 13674, '20090915 14:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (385, 13674, '20090916 15:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (386, 13674, '20090916 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (387, 13674, '20090916 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (388, 13674, '20090917 08:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (389, 13674, '20090917 15:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (390, 13674, '20090917 15:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (391, 13674, '20090917 22:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (392, 13674, '20090917 22:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (393, 13674, '20090918 15:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (394, 13674, '20090918 15:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (395, 13674, '20090918 21:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (396, 13674, '20090918 21:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (397, 13674, '20090919 09:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (398, 13674, '20090919 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (399, 13674, '20090919 21:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (400, 13674, '20090919 21:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (401, 13674, '20090920 15:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (402, 13674, '20090920 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (403, 13674, '20090920 21:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (404, 13674, '20090920 21:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (405, 13674, '20090921 15:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (406, 13674, '20090921 15:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (407, 13674, '20090921 22:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (408, 13674, '20090921 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (409, 13674, '20090922 16:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (410, 13674, '20090922 16:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (411, 13674, '20090922 20:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (412, 13674, '20090922 21:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (413, 13674, '20090923 20:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (414, 13674, '20090923 20:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (415, 13674, '20090923 21:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (416, 13674, '20090923 22:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (417, 13674, '20090924 14:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (418, 13674, '20090924 14:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (419, 13674, '20090924 22:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (420, 13674, '20090925 09:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (421, 13674, '20090925 09:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (422, 13674, '20090925 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (423, 13674, '20090925 21:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (424, 13674, '20090926 15:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (425, 13674, '20090927 15:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (426, 13674, '20090927 21:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (427, 13674, '20090928 14:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (428, 13674, '20090928 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (429, 13674, '20090928 15:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (430, 13674, '20090928 15:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (431, 13674, '20090928 21:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (432, 13674, '20090928 21:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (433, 13674, '20090929 12:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (434, 13674, '20090929 22:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (435, 13674, '20090929 22:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (436, 13687, '20090901 22:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (437, 13687, '20090902 22:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (438, 13687, '20090905 15:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (439, 13687, '20090905 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (440, 13687, '20090906 15:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (441, 13687, '20090907 22:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (442, 13754, '20090901 22:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (443, 13754, '20090902 22:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (444, 13754, '20090905 15:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (445, 13754, '20090906 15:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (446, 13754, '20090907 22:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (447, 13754, '20090908 23:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (448, 13754, '20090910 23:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (449, 13754, '20090912 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (450, 13754, '20090913 23:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (451, 13754, '20090915 23:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (452, 13754, '20090920 22:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (453, 13754, '20090925 23:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (454, 13774, '20090901 13:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (455, 13774, '20090901 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (456, 13774, '20090902 14:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (457, 13774, '20090903 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (458, 13774, '20090903 21:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (459, 13774, '20090904 14:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (460, 13774, '20090904 22:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (461, 13774, '20090905 22:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (462, 13774, '20090906 12:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (463, 13774, '20090906 23:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (464, 13774, '20090907 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (465, 13774, '20090908 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (466, 13774, '20090909 08:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (467, 13774, '20090909 22:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (468, 13774, '20090911 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (469, 13774, '20090912 14:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (470, 13774, '20090912 21:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (471, 13774, '20090913 14:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (472, 13774, '20090914 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (473, 13774, '20090915 14:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (474, 13774, '20090915 22:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (475, 13774, '20090916 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (476, 13774, '20090916 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (477, 13774, '20090917 14:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (478, 13774, '20090918 22:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (479, 13774, '20090919 21:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (480, 13774, '20090920 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (481, 13774, '20090921 22:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (482, 13774, '20090922 15:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (483, 13774, '20090922 22:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (484, 13774, '20090923 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (485, 13774, '20090923 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (486, 13774, '20090924 14:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (487, 13774, '20090925 22:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (488, 13774, '20090926 12:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (489, 13774, '20090926 23:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (490, 13774, '20090927 22:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (491, 13774, '20090928 14:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (492, 13774, '20090928 21:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (493, 13774, '20090928 21:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (494, 13815, '20090901 23:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (495, 13815, '20090902 22:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (496, 13815, '20090905 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (497, 13815, '20090907 22:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (498, 13815, '20090908 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (499, 13815, '20090910 23:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (500, 13815, '20090912 22:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (501, 13815, '20090913 23:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (502, 13815, '20090915 23:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (503, 13815, '20090920 22:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (504, 13815, '20090923 23:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (505, 13815, '20090929 22:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (506, 13894, '20090901 15:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (507, 13894, '20090901 23:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (508, 13894, '20090902 23:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (509, 13894, '20090904 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (510, 13894, '20090905 14:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (511, 13894, '20090906 10:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (512, 13894, '20090906 14:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (513, 13894, '20090906 22:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (514, 13894, '20090907 14:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (515, 13894, '20090909 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (516, 13894, '20090910 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (517, 13894, '20090911 22:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (518, 13894, '20090912 15:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (519, 13894, '20090912 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (520, 13894, '20090913 22:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (521, 13894, '20090918 22:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (522, 13894, '20090919 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (523, 13894, '20090919 23:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (524, 13894, '20090920 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (525, 13894, '20090920 22:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (526, 13894, '20090923 22:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (527, 13894, '20090925 09:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (528, 13894, '20090925 13:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (529, 13894, '20090926 15:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (530, 13894, '20090927 15:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (531, 13894, '20090927 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (532, 13894, '20090928 22:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (533, 13894, '20090929 22:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (534, 13984, '20090901 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (535, 13984, '20090901 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (536, 13984, '20090902 23:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (537, 13984, '20090903 21:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (538, 13984, '20090904 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (539, 13984, '20090905 15:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (540, 13984, '20090906 10:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (541, 13984, '20090906 14:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (542, 13984, '20090906 21:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (543, 13984, '20090907 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (544, 13984, '20090909 23:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (545, 13984, '20090910 23:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (546, 13984, '20090911 22:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (547, 13984, '20090912 15:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (548, 13984, '20090912 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (549, 13984, '20090913 22:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (550, 13984, '20090915 14:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (551, 13984, '20090918 14:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (552, 13984, '20090918 22:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (553, 13984, '20090919 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (554, 13984, '20090920 12:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (555, 13984, '20090920 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (556, 13984, '20090923 22:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (557, 13984, '20090925 08:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (558, 13984, '20090925 14:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (559, 13984, '20090926 15:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (560, 13984, '20090927 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (561, 13984, '20090927 21:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (562, 13984, '20090928 22:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (563, 13984, '20090929 22:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (564, 14044, '20090920 22:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (565, 14044, '20090925 23:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (566, 14284, '20090901 15:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (567, 14284, '20090901 23:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (568, 14284, '20090902 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (569, 14284, '20090903 21:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (570, 14284, '20090904 15:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (571, 14284, '20090905 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (572, 14284, '20090906 10:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (573, 14284, '20090906 14:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (574, 14284, '20090906 21:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (575, 14284, '20090907 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (576, 14284, '20090909 23:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (577, 14284, '20090910 23:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (578, 14284, '20090911 21:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (579, 14284, '20090912 15:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (580, 14284, '20090912 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (581, 14284, '20090913 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (582, 14284, '20090918 22:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (583, 14284, '20090919 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (584, 14284, '20090920 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (585, 14284, '20090923 22:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (586, 14284, '20090925 08:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (587, 14284, '20090925 13:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (588, 14284, '20090926 15:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (589, 14284, '20090927 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (590, 14284, '20090927 21:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (591, 14284, '20090928 22:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (592, 14284, '20090929 22:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (593, 14335, '20090901 15:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (594, 14335, '20090901 23:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (595, 14335, '20090902 23:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (596, 14335, '20090904 15:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (597, 14335, '20090905 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (598, 14335, '20090906 10:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (599, 14335, '20090906 14:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (600, 14335, '20090906 22:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (601, 14335, '20090907 14:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (602, 14335, '20090909 23:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (603, 14335, '20090910 23:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (604, 14335, '20090911 22:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (605, 14335, '20090912 15:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (606, 14335, '20090912 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (607, 14335, '20090913 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (608, 14335, '20090915 14:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (609, 14335, '20090918 22:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (610, 14335, '20090919 15:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (611, 14335, '20090920 12:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (612, 14335, '20090923 22:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (613, 14335, '20090925 09:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (614, 14335, '20090925 13:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (615, 14454, '20090901 22:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (616, 14454, '20090902 14:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (617, 14454, '20090903 14:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (618, 14454, '20090903 21:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (619, 14454, '20090904 14:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (620, 14454, '20090904 22:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (621, 14454, '20090905 22:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (622, 14454, '20090906 12:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (623, 14454, '20090906 23:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (624, 14454, '20090907 23:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (625, 14454, '20090908 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (626, 14454, '20090909 08:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (627, 14454, '20090909 22:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (628, 14454, '20090911 22:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (629, 14494, '20090901 13:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (630, 14494, '20090901 21:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (631, 14494, '20090902 14:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (632, 14494, '20090903 14:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (633, 14494, '20090903 21:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (634, 14494, '20090904 13:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (635, 14494, '20090904 22:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (636, 14494, '20090905 22:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (637, 14494, '20090906 12:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (638, 14494, '20090906 23:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (639, 14494, '20090907 23:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (640, 14494, '20090908 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (641, 14494, '20090909 08:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (642, 14494, '20090909 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (643, 14494, '20090911 08:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (644, 14494, '20090911 22:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (645, 14494, '20090912 14:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (646, 14494, '20090912 21:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (647, 14494, '20090913 14:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (648, 14494, '20090914 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (649, 14494, '20090915 14:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (650, 14494, '20090915 22:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (651, 14494, '20090916 14:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (652, 14494, '20090916 23:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (653, 14494, '20090917 14:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (654, 14494, '20090918 22:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (655, 14494, '20090919 21:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (656, 14494, '20090920 22:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (657, 14494, '20090921 13:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (658, 14494, '20090921 22:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (659, 14494, '20090922 15:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (660, 14494, '20090922 22:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (661, 14494, '20090923 15:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (662, 14494, '20090923 22:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (663, 14494, '20090924 14:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (664, 14494, '20090925 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (665, 14494, '20090926 12:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (666, 14494, '20090926 23:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (667, 14494, '20090927 22:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (668, 14494, '20090928 14:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (669, 14494, '20090928 20:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (670, 14494, '20090928 20:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (671, 14514, '20090901 21:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (672, 14514, '20090902 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (673, 14514, '20090902 21:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (674, 14514, '20090903 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (675, 14514, '20090904 09:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (676, 14514, '20090904 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (677, 14514, '20090904 23:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (678, 14514, '20090905 21:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (679, 14514, '20090906 15:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (680, 14514, '20090906 21:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (681, 14514, '20090907 14:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (682, 14514, '20090907 21:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (683, 14514, '20090908 14:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (684, 14514, '20090908 22:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (685, 14514, '20090909 14:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (686, 14514, '20090909 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (687, 14514, '20090910 13:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (688, 14514, '20090910 21:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (689, 14514, '20090910 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (690, 14514, '20090911 15:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (691, 14514, '20090911 15:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (692, 14514, '20090911 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (693, 14514, '20090911 22:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (694, 14514, '20090912 00:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (695, 14514, '20090912 15:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (696, 14514, '20090912 15:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (697, 14514, '20090913 14:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (698, 14514, '20090913 15:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (699, 14514, '20090913 23:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (700, 14514, '20090913 23:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (701, 14514, '20090914 14:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (702, 14514, '20090914 14:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (703, 14514, '20090914 22:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (704, 14514, '20090914 22:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (705, 14514, '20090915 22:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (706, 14514, '20090915 22:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (707, 14514, '20090916 14:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (708, 14514, '20090916 14:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (709, 14514, '20090916 23:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (710, 14514, '20090917 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (711, 14514, '20090917 15:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (712, 14514, '20090917 21:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (713, 14514, '20090918 14:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (714, 14514, '20090918 14:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (715, 14514, '20090919 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (716, 14514, '20090919 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (717, 14514, '20090919 22:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (718, 14514, '20090920 14:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (719, 14514, '20090920 14:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (720, 14514, '20090920 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (721, 14514, '20090921 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (722, 14514, '20090921 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (723, 14514, '20090922 14:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (724, 14514, '20090922 14:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (725, 14514, '20090922 16:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (726, 14514, '20090922 16:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (727, 14514, '20090922 21:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (728, 14514, '20090922 21:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (729, 14514, '20090923 14:05:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (730, 14514, '20090923 14:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (731, 14514, '20090923 21:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (732, 14514, '20090923 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (733, 14514, '20090924 14:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (734, 14514, '20090924 14:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (735, 14514, '20090924 21:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (736, 14514, '20090925 14:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (737, 14514, '20090925 14:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (738, 14514, '20090925 23:14:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (739, 14514, '20090926 08:06:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (740, 14514, '20090926 08:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (741, 14514, '20090926 15:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (742, 14514, '20090926 21:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (743, 14514, '20090926 21:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (744, 14514, '20090927 15:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (745, 14514, '20090927 15:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (746, 14514, '20090927 21:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (747, 14514, '20090928 14:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (748, 14514, '20090928 14:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (749, 14514, '20090929 14:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (750, 14514, '20090929 14:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (751, 14515, '20090901 21:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (752, 14515, '20090902 14:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (753, 14515, '20090902 21:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (754, 14515, '20090903 21:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (755, 14515, '20090904 09:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (756, 14515, '20090904 15:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (757, 14515, '20090904 23:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (758, 14515, '20090905 21:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (759, 14515, '20090906 15:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (760, 14515, '20090906 21:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (761, 14515, '20090907 14:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (762, 14515, '20090907 21:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (763, 14515, '20090908 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (764, 14515, '20090908 22:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (765, 14515, '20090909 14:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (766, 14515, '20090909 22:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (767, 14515, '20090910 14:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (768, 14515, '20090910 21:57:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (769, 14515, '20090911 15:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (770, 14515, '20090911 22:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (771, 14515, '20090912 15:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (772, 14515, '20090913 15:02:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (773, 14515, '20090913 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (774, 14515, '20090914 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (775, 14515, '20090914 22:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (776, 14515, '20090915 22:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (777, 14515, '20090916 14:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (778, 14515, '20090916 14:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (779, 14515, '20090916 23:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (780, 14515, '20090917 15:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (781, 14515, '20090917 15:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (782, 14515, '20090917 21:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (783, 14515, '20090917 21:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (784, 14515, '20090918 14:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (785, 14515, '20090918 14:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (786, 14515, '20090919 15:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (787, 14515, '20090919 22:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (788, 14515, '20090919 22:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (789, 14515, '20090920 14:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (790, 14515, '20090920 14:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (791, 14515, '20090920 23:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (792, 14515, '20090920 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (793, 14515, '20090921 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (794, 14515, '20090921 15:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (795, 14515, '20090921 20:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (796, 14515, '20090921 20:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (797, 14515, '20090922 14:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (798, 14515, '20090922 14:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (799, 14515, '20090922 21:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (800, 14515, '20090922 21:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (801, 14515, '20090923 14:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (802, 14515, '20090923 14:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (803, 14515, '20090923 21:54:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (804, 14515, '20090924 14:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (805, 14515, '20090924 14:24:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (806, 14515, '20090924 22:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (807, 14515, '20090925 14:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (808, 14515, '20090925 14:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (809, 14515, '20090925 23:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (810, 14515, '20090925 23:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (811, 14515, '20090926 08:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (812, 14515, '20090926 15:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (813, 14515, '20090926 15:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (814, 14515, '20090926 21:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (815, 14515, '20090926 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (816, 14515, '20090927 15:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (817, 14515, '20090927 15:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (818, 14515, '20090927 21:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (819, 14515, '20090928 14:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (820, 14515, '20090928 14:40:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (821, 14515, '20090929 14:42:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (822, 14515, '20090929 14:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (823, 14544, '20090909 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (824, 14544, '20090909 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (825, 14544, '20090910 23:00:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (826, 14544, '20090911 15:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (827, 14544, '20090911 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (828, 14544, '20090912 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (829, 14544, '20090913 02:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (830, 14544, '20090913 15:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (831, 14544, '20090913 16:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (832, 14544, '20090913 21:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (833, 14544, '20090914 15:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (834, 14544, '20090914 22:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (835, 14544, '20090915 23:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (836, 14544, '20090916 10:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (837, 14544, '20090916 22:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (838, 14544, '20090917 11:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (839, 14544, '20090917 21:51:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (840, 14544, '20090918 15:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (841, 14544, '20090918 23:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (842, 14544, '20090919 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (843, 14544, '20090919 23:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (844, 14544, '20090920 14:36:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (845, 14544, '20090920 22:13:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (846, 14544, '20090921 22:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (847, 14544, '20090922 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (848, 14544, '20090922 22:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (849, 14544, '20090923 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (850, 14544, '20090923 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (851, 14544, '20090924 15:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (852, 14544, '20090924 22:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (853, 14544, '20090925 09:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (854, 14544, '20090925 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (855, 14544, '20090926 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (856, 14544, '20090927 07:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (857, 14544, '20090927 07:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (858, 14544, '20090927 15:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (859, 14544, '20090927 23:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (860, 14544, '20090928 16:59:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (861, 14544, '20090928 22:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (862, 14544, '20090929 23:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (863, 14554, '20090917 14:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (864, 14554, '20090918 15:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (865, 14554, '20090918 15:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (866, 14554, '20090918 15:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (867, 14554, '20090918 15:23:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (868, 14554, '20090918 15:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (869, 14554, '20090918 22:46:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (870, 14554, '20090919 21:32:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (871, 14554, '20090920 22:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (872, 14554, '20090921 22:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (873, 14554, '20090922 08:45:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (874, 14554, '20090922 14:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (875, 14554, '20090922 22:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (876, 14554, '20090923 15:08:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (877, 14554, '20090923 22:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (878, 14554, '20090924 14:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (879, 14554, '20090924 15:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (880, 14554, '20090926 12:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (881, 14554, '20090926 23:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (882, 14554, '20090927 22:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (883, 14554, '20090928 14:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (884, 14554, '20090928 14:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (885, 14554, '20090928 14:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (886, 14554, '20090928 14:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (887, 14554, '20090928 21:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (888, 14554, '20090929 14:50:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (889, 14574, '20090919 15:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (890, 14574, '20090919 22:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (891, 14574, '20090920 14:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (892, 14574, '20090920 23:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (893, 14574, '20090921 15:26:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (894, 14574, '20090921 21:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (895, 14574, '20090922 14:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (896, 14574, '20090922 21:52:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (897, 14574, '20090922 21:53:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (898, 14574, '20090923 14:03:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (899, 14574, '20090923 15:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (900, 14574, '20090923 21:48:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (901, 14574, '20090924 14:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (902, 14574, '20090924 21:56:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (903, 14574, '20090925 14:07:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (904, 14574, '20090925 23:12:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (905, 14574, '20090926 15:28:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (906, 14574, '20090926 21:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (907, 14574, '20090927 15:22:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (908, 14574, '20090927 21:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (909, 14574, '20090928 14:29:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (910, 14574, '20090929 14:38:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (911, 14584, '20090922 22:16:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (912, 14584, '20090923 08:15:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (913, 14584, '20090923 15:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (914, 14584, '20090923 22:34:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (915, 14584, '20090924 14:58:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (916, 14584, '20090926 12:27:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (917, 14584, '20090926 23:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (918, 14584, '20090927 22:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (919, 14584, '20090928 14:31:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (920, 14584, '20090928 21:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (921, 14584, '20090928 21:41:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (922, 14584, '20090928 21:44:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (923, 14594, '20090923 14:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (924, 14594, '20090923 21:49:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (925, 14594, '20090924 14:19:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (926, 14594, '20090924 22:04:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (927, 14594, '20090925 14:09:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (928, 14594, '20090925 23:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (929, 14594, '20090926 15:30:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (930, 14594, '20090926 21:43:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (931, 14594, '20090927 15:25:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (932, 14594, '20090927 21:20:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (933, 14594, '20090928 14:37:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (934, 14594, '20090929 14:39:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (935, 14595, '20090923 14:11:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (936, 14595, '20090923 21:55:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (937, 14595, '20090924 14:18:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (938, 14595, '20090924 22:01:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (939, 14595, '20090925 14:10:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (940, 14595, '20090925 23:17:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (941, 14595, '20090926 15:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (942, 14595, '20090926 21:47:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (943, 14595, '20090927 15:33:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (944, 14595, '20090927 21:21:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (945, 14595, '20090928 14:35:00.000')
INSERT INTO [dbo].[zLogEntries] ([log_ID], [client_ID], [log_time]) VALUES (946, 14595, '20090929 14:45:00.000')
SET IDENTITY_INSERT [dbo].[zLogEntries] OFF
Tim
December 8, 2009 at 9:11 am
Using a sub set of your data this appears to work and is set based.
Sub set utilized client_id of 9824 and 14595 with last date of 20090927:21:21:00.000
SELECT Client_id,MONTH(log_time),DAY(log_time),YEAR(log_time) FROM zLogEntries
GROUP BY Client_id, MONTH(log_time),DAY(log_time),YEAR(log_time) HAVING COUNT(DAY(log_time)) < 2
Be advised I did NOT utilize all your submitted data. Further the solution would not produce what you desire if there were no entries on a given day for a client, that is client contact was NOT made on either shift.
December 8, 2009 at 9:28 am
Thanks for the reply. I wish it could be that simple. I need to be able to return clients with no entry on either shift, and I also need to identify which shift (day = 1, evening = 2) was missed.
I know I can accomplish this by building a temp table at runtime that contains all of the dates and shifts for the period between the startdate and enddate, then doing an outer join for each client's existing logs(cursor - :angry:) to generate the final list, but that just seems too clumsy and awkward.
Tim
December 8, 2009 at 11:09 am
slimchance99
I need to be able to return clients with no entry on either shift, and I also need to identify which shift (day = 1, evening = 2) was missed.
I know I can accomplish this by building a temp table at runtime that contains all of the dates and shifts for the period between the startdate and enddate, then doing an outer join for each client's existing logs(cursor - ) to generate the final list, but that just seems too clumsy and awkward.
OOPS - might I suggest that you post your code along with appropriate table definitions and hopefully some one will review it and give you additional ideas.
December 8, 2009 at 11:13 am
ok i think i followed your logic; this was fun for me. made me think hard about how to get a calendar in 12 increments.
correct me if i'm wrong, but essentially if we created a Calendar table for all possible dates, and then cross joined it to all possible clients, that would give us all possible dates per client.
a kink in it is we need two shifts per day, which i assumed was morning shift and night shift, 0-11:59 and 12:00 to 23:59
sample results: note dates N for 09/04 and 09/06 are missing.
N Client_ID log_ID client_ID log_time
2009-09-01 00:00:00.000 9824 NULL NULL NULL
2009-09-02 00:00:00.000 9824 NULL NULL NULL
2009-09-03 00:00:00.000 9824 NULL NULL NULL
2009-09-05 00:00:00.000 9824 NULL NULL NULL
2009-09-07 00:00:00.000 9824 NULL NULL NULL
see if this CTE gives you the results you were looking for:
--we need all possible clientID's; for this example, we use a temp table.
select distinct [client_ID] into #tempClients from [zLogEntries] --'37 distinct clients
--A Calendar Table
--five years before and after todays date:
--special requirement: we need times for zero oclock and 12 oclock
limit the result set just to the data sample's date ranges.
DECLARE @mn datetime,
@MX datetime
SELECT @mn = MIN(log_time),@MX = MAX(log_time) FROM [zLogEntries]
;
with TallyCalendar as (
SELECT dateadd( hh,(-3650 + RW) * 12 ,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) As N
--SELECT dateadd(hh,CASE WHEN RW % 2 = 0 THEN 0 ELSE 12 END ,dateadd( dd,-7300 + CASE WHEN RW % 2 = 0 THEN RW ELSE RW + 1 END ,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))) As N2
FROM (
SELECT TOP 7300
row_number() OVER (ORDER BY sc1.id) AS RW
FROM Master.dbo.SysColumns sc1
CROSS JOIN Master.dbo.SysColumns sc2
) X
)
select TallyCalendar.N,#tempClients.Client_ID,zLogEntries.*
From TallyCalendar
CROSS JOIN #tempClients
LEFT OUTER JOIN zLogEntries
ON CASE
WHEN datepart(hour,log_time) >= 12
THEN DATEADD(hh,12,DATEADD(dd, DATEDIFF(dd,0,log_time), 0))
ELSE
DATEADD(dd, DATEDIFF(dd,0,log_time), 0)
END = TallyCalendar.N
WHERE TallyCalendar.N BETWEEN @mn -1 AND @MX + 1 --one day before the min date, one lay later then max
AND zLogEntries.log_id is NULL --missing entry
ORDER BY #tempClients.Client_ID
Lowell
December 8, 2009 at 11:43 am
Lowell:
Your logic is going to work I think, but this project is for a SQL 2000 server, so no CTE's, row numbering, etc.
I'm working on a solution using a temporary table that holds all of the shifts between the provided startdate and enddate:
DECLARE @startdate SMALLDATETIME
DECLARE @enddate SMALLDATETIME
DECLARE @date SMALLDATETIME
SET @startdate = '9/1/2009'
SET @enddate = '9/30/2009'
--create temp table for shift reference
CREATE TABLE #shiftTable
(
[Date] VARCHAR(8),
[Shift] int
)
--populate shift reference table
SET @date = @startdate
WHILE ( @date <= @enddate )
begin
INSERT INTO
#shiftTable ( Date, Shift )
VALUES
(
CONVERT(VARCHAR(8), @date, 112),
1
)
INSERT INTO
#shiftTable ( Date, Shift )
VALUES
(
CONVERT(VARCHAR(8), @date, 112),
2
)
SET @date = DATEADD(dd, 1, @date)
END
This will give me the 2 shifts daily needed (1 = day, 2 = evening). I can then convert the time from the log entry to one of those shift codes.
I have a cursor-based solution that pulls the logs entries for 1 client at a time and outer joins with #shiftTable to find missing records then puts that into another temp table. I am going to try your method of pulling the unique clients then cross joining with the log records and #shift Table.
Tim
December 8, 2009 at 11:46 am
Lowell
This is posted in a SQL 2000 forum, is it true that CTE,
or Common Table Expression was introduced in SQL 2005 and before that i.e., in SQL 2000 were not available
December 8, 2009 at 11:48 am
That is true. CTE is not supported in SQL 2000
Tim
December 8, 2009 at 11:49 am
oops didn't notice the 2000 forum; easy to fix; here is the same solution, but witht he TallyCalendar as a correlated subquery instead:
DECLARE @mn datetime,
@MX datetime
SELECT @mn = MIN(log_time),@MX = MAX(log_time) FROM [zLogEntries]
select TallyCalendar.N,#tempClients.Client_ID,zLogEntries.*
From (
SELECT dateadd( hh,(-3650 + RW) * 12 ,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) As N
--SELECT dateadd(hh,CASE WHEN RW % 2 = 0 THEN 0 ELSE 12 END ,dateadd( dd,-7300 + CASE WHEN RW % 2 = 0 THEN RW ELSE RW + 1 END ,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))) As N2
FROM (
SELECT TOP 7300
row_number() OVER (ORDER BY sc1.id) AS RW
FROM Master.dbo.SysColumns sc1
CROSS JOIN Master.dbo.SysColumns sc2
) X
) TallyCalendar
CROSS JOIN #tempClients
LEFT OUTER JOIN zLogEntries
ON CASE
WHEN datepart(hour,log_time) >= 12
THEN DATEADD(hh,12,DATEADD(dd, DATEDIFF(dd,0,log_time), 0))
ELSE
DATEADD(dd, DATEDIFF(dd,0,log_time), 0)
END = TallyCalendar.N
WHERE TallyCalendar.N BETWEEN @mn -1 AND @MX + 1 --one day before the min date, one lay later then max
AND zLogEntries.log_id is NULL --missing entry
ORDER BY #tempClients.Client_ID
Lowell
December 8, 2009 at 11:50 am
row_number() is not supported either...
Tim
December 8, 2009 at 12:00 pm
i am completely spoiled by 2005 i swear.
assuming you create this tally table complements of Jeff Moden:
--===== Create and populate the Tally table on the fly
SELECT TOP 11000 --equates to more than 30 years of dates
IDENTITY(INT,1,1) AS N
INTO dbo.Tally
FROM Master.dbo.SysColumns sc1, Master.dbo.SysColumns sc2
--===== Add a Primary Key to maximize performance
ALTER TABLE dbo.Tally
ADD CONSTRAINT PK_Tally_N PRIMARY KEY CLUSTERED (N) WITH FILLFACTOR = 100
--===== Allow the general public to use it
GRANT SELECT ON dbo.Tally TO PUBLIC
this slightly modifed version will work:
--special requirement: we need times for zero occlock and 12 oclock
DECLARE @mn datetime,
@MX datetime
SELECT @mn = MIN(log_time),@MX = MAX(log_time) FROM [zLogEntries]
select TallyCalendar.N,#tempClients.Client_ID,zLogEntries.*
From (
SELECT dateadd( hh,(-3650 + N) * 12 ,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) As N
--SELECT dateadd(hh,CASE WHEN RW % 2 = 0 THEN 0 ELSE 12 END ,dateadd( dd,-7300 + CASE WHEN RW % 2 = 0 THEN RW ELSE RW + 1 END ,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))) As N2
FROM (
SELECT TOP 7300
N From dbo.Tally
) X
) TallyCalendar
CROSS JOIN #tempClients
LEFT OUTER JOIN zLogEntries
ON CASE
WHEN datepart(hour,log_time) >= 12
THEN DATEADD(hh,12,DATEADD(dd, DATEDIFF(dd,0,log_time), 0))
ELSE
DATEADD(dd, DATEDIFF(dd,0,log_time), 0)
END = TallyCalendar.N
WHERE TallyCalendar.N BETWEEN @mn -1 AND @MX + 1 --one day before the min date, one lay later then max
AND zLogEntries.log_id is NULL --missing entry
ORDER BY #tempClients.Client_ID
Lowell
December 8, 2009 at 12:56 pm
This is getting close, but there needs to be a way to identify the shift (am or pm) where the log was missed.
I'll post my solution when I have it working.
Thanks for your help.
Tim
December 8, 2009 at 3:49 pm
Lowell (12/8/2009)
i am completely spoiled by 2005 i swear.
I feel like one of the only holdouts nowadays. I've lost count of the number of times I've had to do something here and thought:
'If only I could use <insert 2005+ feature here> this would be so much easier...'
Or the only slightly less common...
'If we were on 2005/2008, we could do <insert nifty new feature here>... but since we're not... uh... we can uh... wait... until we upgrade?'
December 10, 2009 at 11:34 am
This is what I came up with. Client, date and shift for missed logs are returned.
DECLARE @startdate SMALLDATETIME
DECLARE @enddate SMALLDATETIME
DECLARE @date SMALLDATETIME
DECLARE @costcentre int
SET @startdate = '2009-09-01'
SET @enddate = '2009-09-30'
SET @costcentre = 25
SET NOCOUNT on
CREATE TABLE #shiftTable
(
[Date] VARCHAR(8),
[Shift] int
)
--populate shift reference table
SET @date = @startdate
WHILE ( @date <= @enddate )
begin
INSERT INTO
#shiftTable ( Date, Shift )
VALUES
(
CONVERT(VARCHAR(8), @date, 112),
1
)
INSERT INTO
#shiftTable ( Date, Shift )
VALUES
(
CONVERT(VARCHAR(8), @date, 112),
2
)
SET @date = DATEADD(dd, 1, @date)
END
--select distinct clients with logs in period
SELECT DISTINCT
zLogEntries.client_ID
INTO
#logClients
FROM
zLogEntries
WHERE
zLogEntries.log_time BETWEEN @startdate
AND DATEADD(ms, -3,
DATEADD(dd, 1, @enddate))
AND DATEPART(hh, zLogEntries.log_time) >= 7
--correlate records
SELECT DISTINCT
#logClients.client_ID,
CONVERT(SMALLDATETIME, #shiftTable.[Date]) AS [Date],
CASE WHEN #shiftTable.Shift = 1 THEN 'Day'
ELSE 'Evening'
END AS [shift]
FROM
#shiftTable
CROSS JOIN #logClients
LEFT OUTER JOIN ( SELECT DISTINCT
zLogEntries.client_ID,
CONVERT(VARCHAR(8), zLogEntries.log_time, 112) AS [date],
CASE WHEN DATEPART(hh,
zLogEntries.log_time) BETWEEN 7
and 16
THEN 1
ELSE 2
END AS [shift]
FROM
zLogEntries
WHERE
zLogEntries.log_time BETWEEN @startdate
AND DATEADD(ms, -3, DATEADD(dd, 1, @enddate))
AND DATEPART(hh,
zLogEntries.log_time) >= 7 )
AS logs
ON #logClients.client_ID = logs.client_ID
AND #shiftTable.Shift = logs.shift
AND #shiftTable.Date = logs.date
WHERE
logs.client_ID IS NULL
ORDER BY
#logClients.client_ID,
#shiftTable.Date,
#shiftTable.Shift
DROP TABLE #logClients
DROP TABLE #shiftTable
Tim
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply