SQL Puzzle | Get # of Hits Per Hour | Improving my SQL BI Skills

Tags

SQL Puzzle | Fill the Date Gaps Puzzle (No tally or numbers table)

This puzzle is really simple. We have to write a SQL query which will get number(#) of hits per hour !

Please check out the sample input and the expected output below-

Sample Input

Check the input script below-

Expected Output

Date	HourStart	HourEnd	#Hits
2016-06-22	00	01	1
2016-06-22	01	02	1
2016-06-22	05	06	1
2016-06-22	06	07	1
2016-06-22	07	08	5
2016-06-22	08	09	6
2016-06-22	09	10	14
2016-06-22	10	11	16
2016-06-22	11	12	9
2016-06-22	12	13	9
2016-06-22	13	14	17
2016-06-22	14	15	12
2016-06-22	15	16	27
2016-06-22	16	17	33
2016-06-22	17	18	10
2016-06-22	18	19	4
2016-06-22	19	20	16
2016-06-22	20	21	2
2016-06-22	21	22	2
2016-06-22	22	23	1
2016-06-23	00	01	1
2016-06-23	07	08	3
2016-06-23	08	09	3
2016-06-23	09	10	12
2016-06-23	10	11	7
2016-06-23	11	12	16
2016-06-23	12	13	13
2016-06-23	13	14	26
2016-06-23	14	15	7
2016-06-23	15	16	16
2016-06-23	16	17	6
2016-06-23	17	18	6
2016-06-23	18	19	3
2016-06-23	21	22	7
2016-06-23	22	23	2
2016-06-23	23	24	5
2016-06-24	04	05	2
2016-06-24	07	08	6
2016-06-24	08	09	16
2016-06-24	09	10	14
2016-06-24	10	11	7
2016-06-24	11	12	38
2016-06-24	12	13	9
2016-06-24	13	14	20
2016-06-24	14	15	9
2016-06-24	15	16	15
2016-06-24	16	17	26
2016-06-24	17	18	9
2016-06-24	19	20	22
2016-06-24	20	21	8
2016-06-24	21	22	44
2016-06-24	22	23	3
2016-06-24	23	24	1

Rules/Restrictions

The solution should be should use “SELECT” statement or a CTE.
Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script | use below script to create table & insert some sample data


--

CREATE TABLE [dbo].[tblStats](
	[teID] [float] NULL,
	[teGUID] [nvarchar](255) NULL,
	[teTimestamp] [datetime] NULL,
	[teIP] [nvarchar](255) NULL,
	[teReferrer] [nvarchar](255) NULL
) ON [PRIMARY]
GO

INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (569, N'ABC-EBO-40-34-15', CAST(0x0000A62F017F979C AS DateTime), N'121.216.236.110', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (568, N'ABC-NEZ-03-77-58', CAST(0x0000A62F017159E8 AS DateTime), N'121.216.67.104', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (567, N'ABC-IFD-22-15-87', CAST(0x0000A62F016B76E0 AS DateTime), N'121.216.236.110', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (566, N'ABC-SUO-35-20-81', CAST(0x0000A62F016AB584 AS DateTime), N'1.129.96.74', N'http://www.mydomain.com/page.php?p=DOC-YOA-75-07-31')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (565, N'ABC-EBO-40-34-15', CAST(0x0000A62F016A5DA0 AS DateTime), N'121.216.236.110', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (564, N'ABC-UUJ-76-60-32', CAST(0x0000A62F0168A050 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (563, N'ABC-YLK-57-42-23', CAST(0x0000A62F01688688 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (562, N'ABC-FSY-00-84-55', CAST(0x0000A62F01688430 AS DateTime), N'58.166.84.224', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (561, N'ABC-FQO-61-54-26', CAST(0x0000A62F01687620 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (560, N'ABC-NOK-63-57-38', CAST(0x0000A62F01686810 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (559, N'ABC-NOK-63-57-38', CAST(0x0000A62F016865B8 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (558, N'ABC-FQO-61-54-26', CAST(0x0000A62F01683804 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (557, N'ABC-EBO-40-34-15', CAST(0x0000A62F01682FD0 AS DateTime), N'58.166.84.224', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (556, N'ABC-NOK-63-57-38', CAST(0x0000A62F01681F68 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-BZB-78-63-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (555, N'ABC-YZO-87-72-53', CAST(0x0000A62F0167D6C0 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (554, N'ABC-BTX-78-63-44', CAST(0x0000A62F0167C400 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (553, N'ABC-CPC-10-03-65', CAST(0x0000A62F0167C1A8 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (552, N'ABC-AYT-78-53-34', CAST(0x0000A62F0167B4C4 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (551, N'ABC-AYT-78-53-34', CAST(0x0000A62F0167B26C AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (550, N'ABC-AXW-08-51-33', CAST(0x0000A62F0167A45C AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (549, N'ABC-YLQ-77-62-43', CAST(0x0000A62F016798A4 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (548, N'ABC-KBH-72-56-37', CAST(0x0000A62F01678F44 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (547, N'ABC-GLK-51-45-16', CAST(0x0000A62F01678008 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (546, N'ABC-CPC-10-03-65', CAST(0x0000A62F016755D8 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (545, N'ABC-CPC-10-03-65', CAST(0x0000A62F016754AC AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (544, N'ABC-ULS-86-71-42', CAST(0x0000A62F01674570 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (543, N'ABC-YRP-17-02-73', CAST(0x0000A62F01672950 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (542, N'ABC-YRP-17-02-73', CAST(0x0000A62F016726F8 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (541, N'ABC-YLQ-77-62-43', CAST(0x0000A62F0166D3C4 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (540, N'ABC-YLQ-77-62-43', CAST(0x0000A62F0166D298 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (539, N'ABC-KBH-72-56-37', CAST(0x0000A62F0166C80C AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (538, N'ABC-FPJ-71-64-46', CAST(0x0000A62F0166A73C AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (537, N'ABC-FPJ-71-64-46', CAST(0x0000A62F0166A4E4 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (536, N'ABC-FPJ-71-64-46', CAST(0x0000A62F01667028 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (535, N'ABC-KBH-72-56-37', CAST(0x0000A62F01662FB4 AS DateTime), N'49.190.74.1', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (534, N'ABC-LIQ-63-34-07', CAST(0x0000A62F01628058 AS DateTime), N'58.166.84.224', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (533, N'ABC-JDA-42-36-17', CAST(0x0000A62F015B06AC AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (532, N'ABC-JDA-42-36-17', CAST(0x0000A62F015B0580 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (531, N'ABC-JDA-42-36-17', CAST(0x0000A62F015ADB50 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (530, N'ABC-JDA-42-36-17', CAST(0x0000A62F015ADA24 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (529, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A9F8C AS DateTime), N'1.129.96.186', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (528, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A9D34 AS DateTime), N'1.129.96.186', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (527, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A8DF8 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (526, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A8BA0 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (525, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A8A74 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (524, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A7C64 AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (523, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A7A0C AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (522, N'ABC-JDA-42-36-17', CAST(0x0000A62F015A1C4C AS DateTime), N'125.168.204.17', N'http://www.mydomain.com/page.php?p=DOC-PQV-73-64-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (521, N'ABC-EBO-40-34-15', CAST(0x0000A62F01568460 AS DateTime), N'1.129.96.9', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (520, N'ABC-GWX-20-21-23', CAST(0x0000A62F01559A00 AS DateTime), N'1.129.96.10', N'http://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (519, N'ABC-OUE-03-87-58', CAST(0x0000A62F01552AAC AS DateTime), N'1.129.96.10', N'http://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (518, N'ABC-UNL-56-31-12', CAST(0x0000A62F014F1C48 AS DateTime), N'1.129.96.95', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (517, N'ABC-NPD-33-27-88', CAST(0x0000A62F014E4250 AS DateTime), N'122.107.117.251', N'http://www.mydomain.com/page.php?p=DOC-KSM-23-42-26')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (516, N'ABC-CFC-50-11-74', CAST(0x0000A62F014AFD98 AS DateTime), N'1.129.96.95', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (515, N'ABC-EBO-40-34-15', CAST(0x0000A62F014ABE50 AS DateTime), N'1.129.96.95', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (514, N'ABC-EBO-40-34-15', CAST(0x0000A62F014AA5B4 AS DateTime), N'1.129.96.95', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (513, N'ABC-OZR-64-57-20', CAST(0x0000A62F01482E10 AS DateTime), N'121.218.202.140', N'http://mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (512, N'ABC-PWO-74-68-40', CAST(0x0000A62F01482000 AS DateTime), N'121.218.202.140', N'http://mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (511, N'ABC-CPC-10-03-65', CAST(0x0000A62F01412E44 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (510, N'ABC-CPC-10-03-65', CAST(0x0000A62F01412BEC AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (509, N'ABC-EZS-20-72-45', CAST(0x0000A62F01410B1C AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (508, N'ABC-EZS-20-72-45', CAST(0x0000A62F014109F0 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (507, N'ABC-HVN-11-85-66', CAST(0x0000A62F0140EA4C AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (506, N'ABC-HVN-11-85-66', CAST(0x0000A62F0140E7F4 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (505, N'ABC-MTH-33-17-88', CAST(0x0000A62F0140625C AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (504, N'ABC-MTH-33-17-88', CAST(0x0000A62F01406130 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (503, N'ABC-HVN-11-85-66', CAST(0x0000A62F01403250 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (502, N'ABC-HVN-11-85-66', CAST(0x0000A62F01402FF8 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (501, N'ABC-CYJ-60-22-84', CAST(0x0000A62F013FF1DC AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (500, N'ABC-CYJ-60-22-84', CAST(0x0000A62F013FEF84 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (499, N'ABC-IOO-51-45-26', CAST(0x0000A62F013FE750 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (498, N'ABC-IOO-51-45-26', CAST(0x0000A62F013FE624 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (497, N'ABC-SMU-25-10-71', CAST(0x0000A62F013FB3C0 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (496, N'ABC-SMU-25-10-71', CAST(0x0000A62F013FB294 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (495, N'ABC-DUV-60-54-25', CAST(0x0000A62F013F7B80 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (494, N'ABC-DUV-60-54-25', CAST(0x0000A62F013F7A54 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (493, N'ABC-GGK-87-43-74', CAST(0x0000A62F013E8B44 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-RQD-75-68-31')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (492, N'ABC-GGK-87-43-74', CAST(0x0000A62F013E87C0 AS DateTime), N'1.132.97.59', N'http://www.mydomain.com/page.php?p=DOC-RQD-75-68-31')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (491, N'ABC-QIV-74-66-46', CAST(0x0000A62F0122CC88 AS DateTime), N'121.217.155.151', N'http://www.mydomain.com/page.php?p=DOC-VDT-14-36-70')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (490, N'ABC-UHC-36-86-02', CAST(0x0000A62F0122C1FC AS DateTime), N'121.217.155.151', N'http://www.mydomain.com/page.php?p=DOC-VDT-14-36-70')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (489, N'ABC-NNU-03-87-58', CAST(0x0000A62F01206B28 AS DateTime), N'58.162.223.142', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (488, N'ABC-EBO-40-34-15', CAST(0x0000A62F011FC13C AS DateTime), N'58.162.223.142', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (487, N'ABC-EKA-50-44-25', CAST(0x0000A62F011DA758 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (486, N'ABC-YZG-67-52-33', CAST(0x0000A62F011D9240 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (485, N'ABC-OYO-74-67-40', CAST(0x0000A62F011D774C AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (484, N'ABC-YZG-67-52-33', CAST(0x0000A62F011D50A0 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (483, N'ABC-TMX-13-44-10', CAST(0x0000A62F011BE684 AS DateTime), N'103.9.242.162', N'http://www.mydomain.com/page.php?p=DOC-CIS-28-13-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (482, N'ABC-EBO-40-34-15', CAST(0x0000A62F01178F94 AS DateTime), N'120.151.3.125', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (481, N'ABC-LIQ-63-34-07', CAST(0x0000A62F01176B40 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76&v=VER-NIW-33-17-88')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (480, N'ABC-LIQ-63-34-07', CAST(0x0000A62F0117180C AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76&v=VER-VFU-56-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (479, N'ABC-KBO-02-86-67', CAST(0x0000A62F0113D354 AS DateTime), N'121.217.163.174', N'http://www.mydomain.com/page.php?p=DOC-DGQ-07-22-33')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (478, N'ABC-GPU-71-65-46', CAST(0x0000A62F011014BC AS DateTime), N'141.243.9.161', N'https://www.mydomain.com/page.php?p=DOC-XDP-17-01-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (477, N'ABC-AJW-68-43-24', CAST(0x0000A62F010FC50C AS DateTime), N'141.243.9.161', N'https://www.mydomain.com/page.php?p=DOC-XDP-17-01-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (476, N'ABC-HZA-61-55-36', CAST(0x0000A62F010F7EBC AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (475, N'ABC-WCM-16-01-62', CAST(0x0000A62F010DB35C AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (474, N'ABC-QSH-04-88-60', CAST(0x0000A62F010D9AC0 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (473, N'ABC-EBO-40-34-15', CAST(0x0000A62F010D8A58 AS DateTime), N'1.42.32.160', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (472, N'ABC-HZY-81-75-56', CAST(0x0000A62F010D2EF0 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (471, N'ABC-CCY-48-33-04', CAST(0x0000A62F010CED50 AS DateTime), N'202.161.69.230', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (470, N'ABC-RJV-25-10-81', CAST(0x0000A62F010CBC18 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (469, N'ABC-WCM-16-01-62', CAST(0x0000A62F010C794C AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
GO
print 'Processed 100 total records'
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (468, N'ABC-HND-21-05-76', CAST(0x0000A62F010C5174 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (467, N'ABC-HND-21-05-76', CAST(0x0000A62F01095D98 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (466, N'ABC-AZC-88-73-44', CAST(0x0000A62F01094E5C AS DateTime), N'121.216.152.187', N'https://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (465, N'ABC-AZC-88-73-44', CAST(0x0000A62F010949AC AS DateTime), N'121.216.152.187', N'https://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (464, N'ABC-EAB-40-34-15', CAST(0x0000A62F01091F7C AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (463, N'ABC-AIA-38-12-84', CAST(0x0000A62F0109161C AS DateTime), N'1.127.49.2', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (462, N'ABC-UPI-66-51-32', CAST(0x0000A62F0108F7A4 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (461, N'ABC-FSY-00-84-55', CAST(0x0000A62F0108DDDC AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (460, N'ABC-NQP-23-17-78', CAST(0x0000A62F010891B0 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (459, N'ABC-SPK-25-00-71', CAST(0x0000A62F01087914 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (458, N'ABC-ADV-58-42-24', CAST(0x0000A62F01085844 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (457, N'ABC-CFC-50-11-74', CAST(0x0000A62F01080E70 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (456, N'ABC-CCY-48-33-04', CAST(0x0000A62F01071024 AS DateTime), N'202.161.69.230', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (455, N'ABC-CCY-48-33-04', CAST(0x0000A62F01070598 AS DateTime), N'202.161.69.230', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (454, N'ABC-BRY-58-43-24', CAST(0x0000A62F010537E0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (453, N'ABC-EBO-40-34-15', CAST(0x0000A62F01033C74 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (452, N'ABC-EBO-40-34-15', CAST(0x0000A62F0101A120 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (451, N'ABC-LNT-13-86-68', CAST(0x0000A62F01008330 AS DateTime), N'203.39.225.146', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (450, N'ABC-AGH-78-63-44', CAST(0x0000A62F00FF3408 AS DateTime), N'1.129.96.153', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (449, N'ABC-RFL-35-28-81', CAST(0x0000A62F00FF1A40 AS DateTime), N'1.129.96.153', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (448, N'ABC-XMM-00-22-31', CAST(0x0000A62F00FEF4C0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-BBF-87-11-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (447, N'ABC-QNF-74-68-40', CAST(0x0000A62F00FEC838 AS DateTime), N'1.129.96.153', N'https://www.mydomain.com/page.php?p=DOC-NWA-83-77-48')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (446, N'ABC-OZR-64-57-20', CAST(0x0000A62F00FE7D38 AS DateTime), N'1.129.96.153', N'https://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (445, N'ABC-YKH-47-32-13', CAST(0x0000A62F00FA0C80 AS DateTime), N'118.208.123.33', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (444, N'ABC-CSD-10-83-65', CAST(0x0000A62F00F9FC18 AS DateTime), N'118.208.123.33', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (443, N'ABC-ARO-68-53-34', CAST(0x0000A62F00F934E0 AS DateTime), N'101.178.131.12', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (442, N'ABC-ARO-68-53-34', CAST(0x0000A62F00F925A4 AS DateTime), N'101.178.131.12', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (441, N'ABC-WOI-06-81-52', CAST(0x0000A62F00F12408 AS DateTime), N'122.150.228.34', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (440, N'ABC-EBO-40-34-15', CAST(0x0000A62F00EFCDD8 AS DateTime), N'58.162.223.142', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (439, N'ABC-ITN-81-75-56', CAST(0x0000A62F00EF7144 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (438, N'ABC-CKB-18-03-64', CAST(0x0000A62F00EEF764 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (437, N'ABC-NAK-23-17-88', CAST(0x0000A62F00EDE784 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (436, N'ABC-RGH-23-47-58', CAST(0x0000A62F00ECF040 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-YIO-07-82-63')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (435, N'ABC-CJN-61-81-33', CAST(0x0000A62F00EC7534 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-YIO-07-82-63')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (434, N'ABC-EBO-40-34-15', CAST(0x0000A62F00E8D898 AS DateTime), N'203.56.30.29', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (433, N'ABC-NQU-13-07-78', CAST(0x0000A62F00E85EB8 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-GEF-57-18-82')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (432, N'ABC-IWW-22-82-87', CAST(0x0000A62F00E6AAC8 AS DateTime), N'49.180.166.187', N'http://www.mydomain.com/page.php?p=DOC-KCR-17-10-14')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (431, N'ABC-UGT-86-70-52', CAST(0x0000A62F00E2A70C AS DateTime), N'49.180.166.187', N'http://www.mydomain.com/page.php?p=DOC-KCR-17-10-14')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (430, N'ABC-WMM-65-88-80', CAST(0x0000A62F00DF8DB0 AS DateTime), N'144.139.19.13', N'https://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (429, N'ABC-GWX-20-21-23', CAST(0x0000A62F00DF7FA0 AS DateTime), N'144.139.19.13', N'https://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (428, N'ABC-GNP-08-21-54', CAST(0x0000A62F00DF7514 AS DateTime), N'144.139.19.13', N'https://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (427, N'ABC-GWX-20-21-23', CAST(0x0000A62F00DDF4B4 AS DateTime), N'144.139.19.13', N'https://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (426, N'ABC-EBO-40-34-15', CAST(0x0000A62F00DD51D0 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (425, N'ABC-LNB-83-76-48', CAST(0x0000A62F00DCD6C4 AS DateTime), N'1.127.49.2', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (424, N'ABC-WUY-87-48-12', CAST(0x0000A62F00DB37EC AS DateTime), N'1.132.96.116', N'https://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (423, N'ABC-WUY-87-48-12', CAST(0x0000A62F00DB333C AS DateTime), N'1.132.96.116', N'https://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (422, N'ABC-EBO-40-34-15', CAST(0x0000A62F00DAA7C8 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (421, N'ABC-BRY-58-43-24', CAST(0x0000A62F00DA6AD8 AS DateTime), N'49.180.166.187', N'http://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (420, N'ABC-QZB-24-18-80', CAST(0x0000A62F00DA6754 AS DateTime), N'180.214.93.114', N'http://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (419, N'ABC-RJV-25-10-81', CAST(0x0000A62F00DA4FE4 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (418, N'ABC-EBO-40-34-15', CAST(0x0000A62F00DA1678 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (417, N'ABC-WOI-06-81-52', CAST(0x0000A62F00D9EC48 AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (416, N'ABC-WOI-06-81-52', CAST(0x0000A62F00D9E9F0 AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (415, N'ABC-EBO-40-34-15', CAST(0x0000A62F00D982D0 AS DateTime), N'60.240.157.143', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (414, N'ABC-WOI-06-81-52', CAST(0x0000A62F00D9218C AS DateTime), N'1.129.96.93', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (413, N'ABC-EBO-40-34-15', CAST(0x0000A62F00D8BB98 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (412, N'ABC-CFC-50-11-74', CAST(0x0000A62F00D5E2B0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (411, N'ABC-EBO-40-34-15', CAST(0x0000A62F00D5E2B0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (410, N'ABC-EZW-20-14-85', CAST(0x0000A62F00D4EDC4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-KBH-12-06-67')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (409, N'ABC-EBO-40-34-15', CAST(0x0000A62F00D43CD0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (408, N'ABC-MTZ-53-25-88', CAST(0x0000A62F00D0A28C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-YEE-55-10-52')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (407, N'ABC-KBO-32-26-07', CAST(0x0000A62F00CD602C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-CUD-30-60-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (406, N'ABC-NUH-83-75-80', CAST(0x0000A62F00CD55A0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-CUD-30-60-34')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (405, N'ABC-EBO-40-34-15', CAST(0x0000A62F00C94E60 AS DateTime), N'192.168.10.150', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (404, N'ABC-FSY-00-84-55', CAST(0x0000A62F00C5D4EC AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (403, N'ABC-ABP-68-52-34', CAST(0x0000A62F00C5BEA8 AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (402, N'ABC-ABP-68-52-34', CAST(0x0000A62F00C5BD7C AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (401, N'ABC-ABP-68-52-34', CAST(0x0000A62F00C5AF6C AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (400, N'ABC-ABP-68-52-34', CAST(0x0000A62F00C5AF6C AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (399, N'ABC-EBO-40-34-15', CAST(0x0000A62F00C529D4 AS DateTime), N'101.175.147.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (398, N'ABC-NNU-03-87-58', CAST(0x0000A62F00C4C188 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (397, N'ABC-EBO-40-34-15', CAST(0x0000A62F00C48948 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (396, N'ABC-MRZ-63-57-38', CAST(0x0000A62F00C31374 AS DateTime), N'166.64.1.2', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (395, N'ABC-AIH-48-33-14', CAST(0x0000A62F00C0FF6C AS DateTime), N'101.175.31.81', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (394, N'ABC-QUI-44-38-10', CAST(0x0000A62F00C0EDD8 AS DateTime), N'101.175.31.81', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (393, N'ABC-BRY-58-43-24', CAST(0x0000A62F00C00378 AS DateTime), N'101.175.31.81', N'http://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (392, N'ABC-TSG-15-00-71', CAST(0x0000A62F00BB7574 AS DateTime), N'120.151.177.12', N'http://mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (391, N'ABC-MAV-03-87-68', CAST(0x0000A62F00BAABE4 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (390, N'ABC-MAV-03-87-68', CAST(0x0000A62F00BAAAB8 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (389, N'ABC-UHQ-46-30-12', CAST(0x0000A62F00BAA734 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (388, N'ABC-UHQ-46-30-12', CAST(0x0000A62F00BAA608 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (387, N'ABC-USK-16-01-62', CAST(0x0000A62F00BA6210 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (386, N'ABC-USK-16-01-62', CAST(0x0000A62F00BA5FB8 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (385, N'ABC-PBF-34-28-00', CAST(0x0000A62F00B9AC6C AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (384, N'ABC-PBF-34-28-00', CAST(0x0000A62F00B9A1E0 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (383, N'ABC-RLO-15-00-71', CAST(0x0000A62F00B9A0B4 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (382, N'ABC-RLO-15-00-71', CAST(0x0000A62F00B97D8C AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (381, N'ABC-XIY-17-02-63', CAST(0x0000A62F00B978DC AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (380, N'ABC-XIY-17-02-63', CAST(0x0000A62F00B9661C AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (379, N'ABC-YLJ-27-12-73', CAST(0x0000A62F00B9616C AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (378, N'ABC-YLJ-27-12-73', CAST(0x0000A62F00B95B90 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (377, N'ABC-BJH-58-43-24', CAST(0x0000A62F00B95A64 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (376, N'ABC-BJH-58-43-24', CAST(0x0000A62F00B9580C AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (375, N'ABC-TZD-85-70-51', CAST(0x0000A62F00B95488 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (374, N'ABC-TZD-85-70-51', CAST(0x0000A62F00B9535C AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (373, N'ABC-HVN-11-85-66', CAST(0x0000A62F00B92800 AS DateTime), N'120.151.237.104', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (372, N'ABC-DSQ-30-24-05', CAST(0x0000A62F00B90604 AS DateTime), N'120.151.237.104', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (371, N'ABC-EJM-30-24-05', CAST(0x0000A62F00B81CD0 AS DateTime), N'125.255.40.127', N'http://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (370, N'ABC-XWF-27-11-83', CAST(0x0000A62F00B7DB30 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (369, N'ABC-XWF-27-11-83', CAST(0x0000A62F00B7D8D8 AS DateTime), N'49.195.108.32', N'https://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (368, N'ABC-XWF-27-11-83', CAST(0x0000A62F00B7A2F0 AS DateTime), N'125.255.41.204', N'http://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
GO
print 'Processed 200 total records'
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (367, N'ABC-XWF-27-11-83', CAST(0x0000A62F00B71C2C AS DateTime), N'125.255.41.204', N'http://www.mydomain.com/page.php?p=DOC-EOG-60-54-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (366, N'ABC-UGT-86-70-52', CAST(0x0000A62F00B5926C AS DateTime), N'202.61.109.133', N'http://www.mydomain.com/page.php?p=DOC-KCR-17-10-14')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (365, N'ABC-AUB-18-02-64', CAST(0x0000A62F00B3AAEC AS DateTime), N'120.150.187.238', N'https://www.mydomain.com/page.php?p=DOC-KBH-12-06-67')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (364, N'ABC-EBO-40-34-15', CAST(0x0000A62F00B2DDD8 AS DateTime), N'120.150.187.238', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (363, N'ABC-QKD-24-18-80', CAST(0x0000A62F00A66DDC AS DateTime), N'49.180.142.113', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (362, N'ABC-QKD-24-18-80', CAST(0x0000A62F00A66CB0 AS DateTime), N'49.180.142.113', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (361, N'ABC-QKD-24-18-80', CAST(0x0000A62F00A644D8 AS DateTime), N'49.180.142.113', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (360, N'ABC-QKD-24-18-80', CAST(0x0000A62F00A643AC AS DateTime), N'49.180.142.113', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (359, N'ABC-EBO-40-34-15', CAST(0x0000A62F00A57B48 AS DateTime), N'220.233.161.165', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76&v=VER-ETW-70-64-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (358, N'ABC-UTB-86-70-52', CAST(0x0000A62F00A3F638 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (357, N'ABC-LNB-83-76-48', CAST(0x0000A62F00A3D310 AS DateTime), N'1.127.49.2', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (356, N'ABC-JVD-72-34-07', CAST(0x0000A62F00A0E9C0 AS DateTime), N'120.29.45.24', N'https://www.mydomain.com/page.php?p=DOC-XTW-15-30-40')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (355, N'ABC-LEY-73-66-38', CAST(0x0000A62F00A0E510 AS DateTime), N'120.29.45.24', N'https://www.mydomain.com/page.php?p=DOC-XTW-15-30-40')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (354, N'ABC-JBU-42-26-07', CAST(0x0000A62F00A0A49C AS DateTime), N'120.29.45.24', N'https://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (353, N'ABC-QZB-24-18-80', CAST(0x0000A62F00A0A244 AS DateTime), N'120.29.45.24', N'https://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (352, N'ABC-USZ-76-50-32', CAST(0x0000A62F00A09D94 AS DateTime), N'120.29.45.24', N'https://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (351, N'ABC-LNB-83-76-48', CAST(0x0000A62F009F51F0 AS DateTime), N'101.175.147.129', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (350, N'ABC-LNB-83-76-48', CAST(0x0000A62F009D5684 AS DateTime), N'101.175.147.129', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (349, N'ABC-EQM-00-84-65', CAST(0x0000A62F009C8010 AS DateTime), N'120.29.40.38', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (348, N'ABC-JHP-32-04-66', CAST(0x0000A62F009BB8D8 AS DateTime), N'101.175.147.129', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (347, N'ABC-RFL-35-28-81', CAST(0x0000A62F00997140 AS DateTime), N'120.29.45.24', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (346, N'ABC-GQH-41-35-16', CAST(0x0000A62F00957F18 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (345, N'ABC-AZC-88-73-44', CAST(0x0000A62F0094AE80 AS DateTime), N'202.6.139.150', N'http://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (344, N'ABC-LNB-83-76-48', CAST(0x0000A62F009436F8 AS DateTime), N'101.175.147.129', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (343, N'ABC-JHP-32-04-66', CAST(0x0000A62F0092034C AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (342, N'ABC-LNB-83-76-48', CAST(0x0000A62F0090D29C AS DateTime), N'1.127.49.2', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (341, N'ABC-AIA-38-12-84', CAST(0x0000A62F008EB534 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (340, N'ABC-ENX-30-14-85', CAST(0x0000A62F008E89D8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (339, N'ABC-WYG-46-31-12', CAST(0x0000A62F008E3C80 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (338, N'ABC-DND-10-83-65', CAST(0x0000A62F008DF3D8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (337, N'ABC-LNB-83-76-48', CAST(0x0000A62F008DC87C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (336, N'ABC-AIA-38-12-84', CAST(0x0000A62F008D6D14 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (335, N'ABC-DUV-60-54-25', CAST(0x0000A62F008BF164 AS DateTime), N'49.180.142.24', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (334, N'ABC-WYG-46-31-12', CAST(0x0000A62F008ADCD4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (333, N'ABC-IOO-51-45-26', CAST(0x0000A62F0089B584 AS DateTime), N'49.180.142.24', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (332, N'ABC-PWO-74-68-40', CAST(0x0000A62F0088C9F8 AS DateTime), N'1.129.96.202', N'https://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (331, N'ABC-LNT-13-86-68', CAST(0x0000A62F00881580 AS DateTime), N'107.191.36.21', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (330, N'ABC-NNU-03-87-58', CAST(0x0000A62F00844A04 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (329, N'ABC-FSY-00-84-55', CAST(0x0000A62F008426DC AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (328, N'ABC-NQP-23-17-78', CAST(0x0000A62F0083D4D4 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (327, N'ABC-HZA-61-55-36', CAST(0x0000A62F0083BC38 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (326, N'ABC-SPK-25-00-71', CAST(0x0000A62F0083AAA4 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (325, N'ABC-ADV-58-42-24', CAST(0x0000A62F0083A270 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (324, N'ABC-CFC-50-11-74', CAST(0x0000A62F00839910 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61&v=VER-SOA-15-00-71')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (323, N'ABC-SNT-15-00-61', CAST(0x0000A62F0080A660 AS DateTime), N'10.66.22.136', N'http://www.mydomain.com/page.php?p=DOC-QOY-84-78-50')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (322, N'ABC-JVD-72-34-07', CAST(0x0000A62F0051F540 AS DateTime), N'211.31.30.152', N'https://www.mydomain.com/page.php?p=DOC-ZAF-68-20-03')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (321, N'ABC-UTB-86-70-52', CAST(0x0000A62F0045B2F8 AS DateTime), N'49.181.201.0', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (320, N'ABC-ARO-68-53-34', CAST(0x0000A62E017EF5E4 AS DateTime), N'101.191.143.51', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (319, N'ABC-AIH-48-33-14', CAST(0x0000A62E017EC380 AS DateTime), N'101.191.143.51', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (318, N'ABC-QUI-44-38-10', CAST(0x0000A62E017E50A8 AS DateTime), N'101.191.143.51', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (317, N'ABC-WOI-06-81-52', CAST(0x0000A62E017CD174 AS DateTime), N'101.191.143.51', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (316, N'ABC-LKU-43-36-18', CAST(0x0000A62E017BE714 AS DateTime), N'101.191.143.51', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (315, N'ABC-LNB-83-76-48', CAST(0x0000A62E016B17F4 AS DateTime), N'124.149.37.113', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (314, N'ABC-JHP-32-04-66', CAST(0x0000A62E016ADE88 AS DateTime), N'124.149.37.113', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (313, N'ABC-AIA-38-12-84', CAST(0x0000A62E0169E744 AS DateTime), N'124.149.37.113', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (312, N'ABC-AIA-38-12-84', CAST(0x0000A62E0169C8CC AS DateTime), N'124.149.37.113', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (311, N'ABC-ENX-30-14-85', CAST(0x0000A62E01698AB0 AS DateTime), N'124.149.37.113', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (310, N'ABC-NEZ-03-77-58', CAST(0x0000A62E01671B40 AS DateTime), N'122.148.31.5', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (309, N'ABC-IEG-82-75-47', CAST(0x0000A62E0163C044 AS DateTime), N'210.50.134.57', N'http://www.mydomain.com/page.php?p=DOC-BMN-38-13-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (308, N'ABC-AFP-38-23-04', CAST(0x0000A62E016380FC AS DateTime), N'210.50.134.57', N'http://www.mydomain.com/page.php?p=DOC-BMN-38-13-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (307, N'ABC-FRE-61-54-36', CAST(0x0000A62E0161F994 AS DateTime), N'210.50.134.57', N'http://www.mydomain.com/page.php?p=DOC-KSM-23-42-26')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (306, N'ABC-DIN-40-33-15', CAST(0x0000A62E0136C7C4 AS DateTime), N'125.168.189.51', N'http://www.mydomain.com/page.php?p=DOC-NYL-51-73-26')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (305, N'ABC-AZC-88-73-44', CAST(0x0000A62E0135F600 AS DateTime), N'203.40.61.67', N'http://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (304, N'ABC-WUY-87-48-12', CAST(0x0000A62E012E2B78 AS DateTime), N'111.220.255.116', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (303, N'ABC-ABN-48-32-14', CAST(0x0000A62E0124DAB4 AS DateTime), N'49.180.131.173', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (302, N'ABC-HBI-01-85-56', CAST(0x0000A62E01249EF0 AS DateTime), N'49.180.131.173', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (301, N'ABC-NQD-13-07-68', CAST(0x0000A62E01247E20 AS DateTime), N'49.180.131.173', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (300, N'ABC-ENV-40-34-05', CAST(0x0000A62E012452C4 AS DateTime), N'49.180.131.173', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (299, N'ABC-DOQ-40-34-05', CAST(0x0000A62E01242F9C AS DateTime), N'121.218.48.36', N'http://www.mydomain.com/page.php?p=DOC-NSX-53-45-40')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (298, N'ABC-MWS-43-27-08', CAST(0x0000A62E01241250 AS DateTime), N'49.180.131.173', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (297, N'ABC-PGZ-34-28-00', CAST(0x0000A62E01105FBC AS DateTime), N'1.144.96.85', N'https://www.mydomain.com/page.php?p=DOC-QLJ-44-05-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (296, N'ABC-PGZ-34-28-00', CAST(0x0000A62E01105C38 AS DateTime), N'1.144.96.85', N'https://www.mydomain.com/page.php?p=DOC-QLJ-44-05-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (295, N'ABC-WCM-16-01-62', CAST(0x0000A62E010E2AE4 AS DateTime), N'202.52.166.222', N'http://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (294, N'ABC-KHR-22-16-87', CAST(0x0000A62E010E22B0 AS DateTime), N'92.225.87.74', N'http://www.mydomain.com/page.php?p=DOC-FBH-50-44-15')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (293, N'ABC-DWP-67-67-03', CAST(0x0000A62E0109B450 AS DateTime), N'110.143.226.37', N'https://www.mydomain.com/page.php?p=DOC-SWQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (292, N'ABC-LNB-83-76-48', CAST(0x0000A62E010891B0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (291, N'ABC-SNG-75-50-31', CAST(0x0000A62E00FFF7BC AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (290, N'ABC-RQG-85-60-41', CAST(0x0000A62E00FFDCC8 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (289, N'ABC-AGH-78-63-44', CAST(0x0000A62E00FFB748 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (288, N'ABC-SCS-15-80-61', CAST(0x0000A62E00FFAF14 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-CFK-74-67-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (287, N'ABC-BTX-78-63-44', CAST(0x0000A62E00FF7A58 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (286, N'ABC-CPC-10-03-65', CAST(0x0000A62E00FF53AC AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (285, N'ABC-EZS-20-72-45', CAST(0x0000A62E00FF3660 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (284, N'ABC-GQH-41-35-16', CAST(0x0000A62E00FF3084 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (283, N'ABC-RFL-35-28-81', CAST(0x0000A62E00FF2148 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (282, N'ABC-YZO-87-72-53', CAST(0x0000A62E00FEE6B0 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (281, N'ABC-GLK-51-45-16', CAST(0x0000A62E00FEBED8 AS DateTime), N'58.162.218.240', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (280, N'ABC-JHP-32-04-66', CAST(0x0000A62E00F9D698 AS DateTime), N'202.93.163.42', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (279, N'ABC-JHP-32-04-66', CAST(0x0000A62E00F99F84 AS DateTime), N'210.10.189.221', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (278, N'ABC-MDB-23-17-88', CAST(0x0000A62E00F90D08 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TGF-61-54-57')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (277, N'ABC-MDB-23-17-88', CAST(0x0000A62E00F9027C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TGF-61-54-57')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (276, N'ABC-LNB-83-76-48', CAST(0x0000A62E00F87708 AS DateTime), N'202.93.163.42', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (275, N'ABC-EEM-40-34-15', CAST(0x0000A62E00F6642C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (274, N'ABC-THI-75-50-31', CAST(0x0000A62E00F322F8 AS DateTime), N'49.181.210.162', N'http://www.mydomain.com/page.php?p=DOC-KSM-23-42-26')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (273, N'ABC-DHU-80-74-55', CAST(0x0000A62E00F22CE0 AS DateTime), N'49.181.210.162', N'http://www.mydomain.com/page.php?p=DOC-HLO-81-75-56')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (272, N'ABC-LNB-83-76-48', CAST(0x0000A62E00F047B8 AS DateTime), N'202.93.163.42', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (271, N'ABC-ICF-71-65-46', CAST(0x0000A62E00E8D76C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (270, N'ABC-LNT-13-86-68', CAST(0x0000A62E00E8C704 AS DateTime), N'10.10.2.166, 101.178.145.96', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (269, N'ABC-QIV-74-66-46', CAST(0x0000A62E00E8A634 AS DateTime), N'59.100.84.227', N'http://www.mydomain.com/page.php?p=DOC-VDT-14-36-70')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (268, N'ABC-LNT-13-86-68', CAST(0x0000A62E00E5248C AS DateTime), N'115.70.62.198', N'http://intranet2.mydomain.com/page.php?p=DOC-UNF-85-78-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (267, N'ABC-ZGM-58-42-24', CAST(0x0000A62E00E41128 AS DateTime), N'121.216.229.219', N'https://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
GO
print 'Processed 300 total records'
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (266, N'ABC-HJU-11-05-66', CAST(0x0000A62E00E40A20 AS DateTime), N'121.216.229.219', N'https://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (265, N'ABC-DSQ-30-24-05', CAST(0x0000A62E00E2E1A4 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (264, N'ABC-WIP-64-85-51', CAST(0x0000A62E00E2C458 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-KGN-40-78-43')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (263, N'ABC-DSQ-30-24-05', CAST(0x0000A62E00E2C458 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (262, N'ABC-IOO-51-45-26', CAST(0x0000A62E00E2B06C AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (261, N'ABC-LZS-03-86-68', CAST(0x0000A62E00E28AEC AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (260, N'ABC-VGR-76-61-42', CAST(0x0000A62E00E268F0 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (259, N'ABC-XAN-17-01-73', CAST(0x0000A62E00E24820 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (258, N'ABC-IHJ-32-84-66', CAST(0x0000A62E00E22D2C AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (257, N'ABC-LNB-83-76-48', CAST(0x0000A62E00E20680 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (256, N'ABC-PWO-74-68-40', CAST(0x0000A62E00E1FF78 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (255, N'ABC-OZR-64-57-20', CAST(0x0000A62E00E1CF6C AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (254, N'ABC-LNT-13-86-68', CAST(0x0000A62E00E164C8 AS DateTime), N'115.70.62.198', N'http://intranet2.mydomain.com/page.php?p=DOC-UNF-85-78-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (253, N'ABC-QES-24-18-80', CAST(0x0000A62E00E0ACCC AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (252, N'ABC-DSQ-30-24-05', CAST(0x0000A62E00E08D28 AS DateTime), N'122.148.35.210', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (251, N'ABC-DSQ-30-24-05', CAST(0x0000A62E00E08BFC AS DateTime), N'122.148.35.210', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (250, N'ABC-DSQ-30-24-05', CAST(0x0000A62E00E084F4 AS DateTime), N'122.148.35.210', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (249, N'ABC-THK-25-10-81', CAST(0x0000A62E00E07F18 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (248, N'ABC-ODQ-54-37-10', CAST(0x0000A62E00E05BF0 AS DateTime), N'1.129.97.86', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (247, N'ABC-ZPH-57-40-20', CAST(0x0000A62E00DEBAC0 AS DateTime), N'1.144.96.221', N'https://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (246, N'ABC-NAK-23-17-88', CAST(0x0000A62E00DE2010 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (245, N'ABC-BRY-58-43-24', CAST(0x0000A62E00DE051C AS DateTime), N'101.176.246.48', N'https://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (244, N'ABC-ENX-30-14-85', CAST(0x0000A62E00DB540C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (243, N'ABC-EHZ-70-64-45', CAST(0x0000A62E00D929C0 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-QUM-64-48-20')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (242, N'ABC-EHZ-70-64-45', CAST(0x0000A62E00D5B4FC AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-QUM-64-48-20')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (241, N'ABC-EHZ-70-64-45', CAST(0x0000A62E00D30518 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-QUM-64-48-20')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (240, N'ABC-NGI-63-57-38', CAST(0x0000A62E00D03590 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-THZ-04-04-38')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (239, N'ABC-VJU-56-41-12', CAST(0x0000A62E00CF8BA4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-JIF-61-52-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (238, N'ABC-GFI-30-23-03', CAST(0x0000A62E00CF8244 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-JIF-61-52-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (237, N'ABC-VIK-53-16-56', CAST(0x0000A62E00CF3618 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-JIF-61-52-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (236, N'ABC-TGQ-35-20-01', CAST(0x0000A62E00CE7CF0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-YXP-67-52-23')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (235, N'ABC-IOP-72-65-47', CAST(0x0000A62E00CE45DC AS DateTime), N'101.174.51.99', N'https://www.mydomain.com/page.php?p=DOC-CHM-38-23-04')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (234, N'ABC-NEZ-03-77-58', CAST(0x0000A62E00CE0568 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (233, N'ABC-BMZ-38-13-84', CAST(0x0000A62E00CD41B4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-THZ-04-04-38')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (232, N'ABC-WOI-06-81-52', CAST(0x0000A62E00CD27EC AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (231, N'ABC-LNB-83-76-48', CAST(0x0000A62E00CCD968 AS DateTime), N'103.19.60.7', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (230, N'ABC-KBO-02-86-67', CAST(0x0000A62E00CCA830 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-DGQ-07-22-33')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (229, N'ABC-MVL-33-17-88', CAST(0x0000A62E00C4CF98 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (228, N'ABC-MVL-33-17-88', CAST(0x0000A62E00C499B0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (227, N'ABC-LNT-13-86-68', CAST(0x0000A62E00C3A848 AS DateTime), N'203.49.149.90', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (226, N'ABC-LNB-83-76-48', CAST(0x0000A62E00C36DB0 AS DateTime), N'58.162.223.142', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (225, N'ABC-LNB-83-76-48', CAST(0x0000A62E00C338F4 AS DateTime), N'58.162.223.142', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (224, N'ABC-LNB-83-76-48', CAST(0x0000A62E00C13D88 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (223, N'ABC-DTF-50-12-74', CAST(0x0000A62E00BF2BD8 AS DateTime), N'115.70.62.198', N'https://www.mydomain.com/page.php?p=DOC-GOJ-01-85-66')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (222, N'ABC-UGT-86-70-52', CAST(0x0000A62E00BBF788 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-KCR-17-10-14')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (221, N'ABC-UGT-86-70-52', CAST(0x0000A62E00BBE39C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-KCR-17-10-14')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (220, N'ABC-RUU-15-75-46', CAST(0x0000A62E00BBBF48 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-WTQ-77-61-43')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (219, N'ABC-JHP-32-04-66', CAST(0x0000A62E00BB2F24 AS DateTime), N'203.35.13.28', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (218, N'ABC-EZH-10-84-65', CAST(0x0000A62E00BA183C AS DateTime), N'1.144.96.13', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (217, N'ABC-KDU-62-56-37', CAST(0x0000A62E00B9ECE0 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (216, N'ABC-LNT-13-86-68', CAST(0x0000A62E00B92350 AS DateTime), N'14.203.121.214', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (215, N'ABC-LNT-13-86-68', CAST(0x0000A62E00B8D274 AS DateTime), N'14.203.121.214', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (214, N'ABC-DND-10-83-65', CAST(0x0000A62E00B8C0E0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (213, N'ABC-WUY-87-48-12', CAST(0x0000A62E00AA1D38 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (212, N'ABC-WUY-87-48-12', CAST(0x0000A62E00AA1AE0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (211, N'ABC-TXT-85-70-51', CAST(0x0000A62E00A8D068 AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (210, N'ABC-TXT-85-70-51', CAST(0x0000A62E00A8CF3C AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (209, N'ABC-RFL-35-28-81', CAST(0x0000A62E00A84878 AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (208, N'ABC-RFL-35-28-81', CAST(0x0000A62E00A8474C AS DateTime), N'121.44.19.135', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (207, N'ABC-JAU-52-36-17', CAST(0x0000A62E00A5D6B0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-CFK-74-67-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (206, N'ABC-OUE-03-87-58', CAST(0x0000A62E00A39F80 AS DateTime), N'153.107.192.206', N'http://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (205, N'ABC-BFF-28-13-84', CAST(0x0000A62E00A0B75C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (204, N'ABC-NEZ-03-77-58', CAST(0x0000A62E00A09C68 AS DateTime), N'101.187.72.34', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (203, N'ABC-BFF-28-13-84', CAST(0x0000A62E00A05294 AS DateTime), N'165.228.140.83', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (202, N'ABC-WUY-87-48-12', CAST(0x0000A62E009FCF54 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (201, N'ABC-WUY-87-48-12', CAST(0x0000A62E009DF4B8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (200, N'ABC-DND-10-83-65', CAST(0x0000A62E009DB1EC AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (199, N'ABC-WUY-87-48-12', CAST(0x0000A62E009D911C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (198, N'ABC-DUP-80-74-55', CAST(0x0000A62E009D0800 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-KBH-12-06-67')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (197, N'ABC-OZR-64-57-20', CAST(0x0000A62E009B3DCC AS DateTime), N'210.9.152.88', N'https://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (196, N'ABC-PWO-74-68-40', CAST(0x0000A62E009B2404 AS DateTime), N'210.9.152.88', N'https://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (195, N'ABC-VLP-46-31-12', CAST(0x0000A62E009A78EC AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-XUK-27-12-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (194, N'ABC-WOI-06-81-52', CAST(0x0000A62E008F9C10 AS DateTime), N'1.132.96.4', N'https://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (193, N'ABC-WOI-06-81-52', CAST(0x0000A62E008F9184 AS DateTime), N'1.132.96.4', N'https://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (192, N'ABC-VAT-76-61-32', CAST(0x0000A62E0084F9CC AS DateTime), N'49.195.42.61', N'http://mydomain.com/page.php?p=DOC-HEI-52-13-86')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (191, N'ABC-NHG-13-07-78', CAST(0x0000A62E007654F8 AS DateTime), N'124.184.0.234', N'http://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (190, N'ABC-ALM-58-43-14', CAST(0x0000A62E007615B0 AS DateTime), N'124.184.0.234', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (189, N'ABC-TXT-85-70-51', CAST(0x0000A62E00745158 AS DateTime), N'121.216.49.232', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (188, N'ABC-KOQ-22-16-87', CAST(0x0000A62E0008DDEC AS DateTime), N'92.225.87.74', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (187, N'ABC-DTF-50-12-74', CAST(0x0000A62D01722828 AS DateTime), N'14.200.205.220', N'https://www.mydomain.com/page.php?p=DOC-GOJ-01-85-66&v=VER-RWX-05-88-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (186, N'ABC-NEZ-03-77-58', CAST(0x0000A62D015BB8CC AS DateTime), N'121.217.241.2', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (185, N'ABC-NEZ-03-77-58', CAST(0x0000A62D015BB674 AS DateTime), N'121.217.241.2', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (184, N'ABC-GWX-20-21-23', CAST(0x0000A62D0157CC80 AS DateTime), N'49.181.212.244', N'http://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (183, N'ABC-SUO-35-20-81', CAST(0x0000A62D01511C64 AS DateTime), N'1.144.96.91', N'http://www.mydomain.com/page.php?p=DOC-YOA-75-07-31')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (182, N'ABC-TXT-85-70-51', CAST(0x0000A62D0148758C AS DateTime), N'121.216.49.232', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (181, N'ABC-RFL-35-28-81', CAST(0x0000A62D01480AE8 AS DateTime), N'121.216.49.232', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (180, N'ABC-TXT-85-70-51', CAST(0x0000A62D0147CCCC AS DateTime), N'49.180.140.32', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (179, N'ABC-TXT-85-70-51', CAST(0x0000A62D0147C948 AS DateTime), N'49.180.140.32', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (178, N'ABC-RFL-35-28-81', CAST(0x0000A62D01478A00 AS DateTime), N'49.180.140.32', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (177, N'ABC-RFL-35-28-81', CAST(0x0000A62D0147867C AS DateTime), N'49.180.140.32', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (176, N'ABC-AXA-18-03-64', CAST(0x0000A62D0144F18C AS DateTime), N'1.144.96.123', N'http://www.mydomain.com/page.php?p=DOC-GEF-57-18-82')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (175, N'ABC-NQU-13-07-78', CAST(0x0000A62D0144E250 AS DateTime), N'1.144.96.123', N'http://www.mydomain.com/page.php?p=DOC-GEF-57-18-82')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (174, N'ABC-NQU-13-07-78', CAST(0x0000A62D0144D8F0 AS DateTime), N'1.144.96.123', N'http://www.mydomain.com/page.php?p=DOC-GEF-57-18-82')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (173, N'ABC-NQU-13-07-78', CAST(0x0000A62D0143E788 AS DateTime), N'1.144.96.123', N'http://www.mydomain.com/page.php?p=DOC-GEF-57-18-82')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (172, N'ABC-NBR-84-55-28', CAST(0x0000A62D013F99F8 AS DateTime), N'124.191.20.20', N'http://www.mydomain.com/page.php?p=DOC-TXR-64-77-88')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (171, N'ABC-NFJ-33-27-08', CAST(0x0000A62D013F7B80 AS DateTime), N'124.191.20.20', N'http://www.mydomain.com/page.php?p=DOC-TXR-64-77-88')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (170, N'ABC-MDL-43-37-18', CAST(0x0000A62D013F4340 AS DateTime), N'124.191.20.20', N'http://www.mydomain.com/page.php?p=DOC-TXR-64-77-88')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (169, N'ABC-TSQ-05-80-61', CAST(0x0000A62D013E9954 AS DateTime), N'14.200.205.220', N'http://www.mydomain.com/page.php?p=DOC-VZZ-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (168, N'ABC-WYG-46-31-12', CAST(0x0000A62D013AC928 AS DateTime), N'103.31.89.139', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (167, N'ABC-DND-10-83-65', CAST(0x0000A62D013A7F54 AS DateTime), N'103.31.89.139', N'https://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (166, N'ABC-KBO-02-86-67', CAST(0x0000A62D01355A24 AS DateTime), N'203.40.84.66', N'http://www.mydomain.com/page.php?p=DOC-DGQ-07-22-33')
GO
print 'Processed 400 total records'
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (165, N'ABC-JVD-72-34-07', CAST(0x0000A62D01343400 AS DateTime), N'1.129.96.35', N'https://www.mydomain.com/page.php?p=DOC-SSQ-14-15-17')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (164, N'ABC-JHP-32-04-66', CAST(0x0000A62D013129E0 AS DateTime), N'1.129.96.155', N'http://mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (163, N'ABC-PWP-83-16-17', CAST(0x0000A62D012A6A88 AS DateTime), N'1.129.96.35', N'http://www.mydomain.com/page.php?p=DOC-QCQ-34-28-00')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (162, N'ABC-GTL-71-54-36', CAST(0x0000A62D01260C90 AS DateTime), N'122.60.113.185', N'http://www.mydomain.com/page.php?p=DOC-ZZA-07-88-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (161, N'ABC-GTL-71-54-36', CAST(0x0000A62D0126090C AS DateTime), N'122.60.113.185', N'http://www.mydomain.com/page.php?p=DOC-ZZA-07-88-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (160, N'ABC-KBK-22-16-87', CAST(0x0000A62D0120ADF4 AS DateTime), N'101.175.33.147', N'http://www.mydomain.com/page.php?p=DOC-ZXO-47-32-03')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (159, N'ABC-JBU-42-26-07', CAST(0x0000A62D011EDDE4 AS DateTime), N'1.129.96.35', N'http://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (158, N'ABC-QZB-24-18-80', CAST(0x0000A62D011E98C0 AS DateTime), N'1.129.96.35', N'http://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (157, N'ABC-JVD-72-34-07', CAST(0x0000A62D011D774C AS DateTime), N'1.129.96.35', N'http://www.mydomain.com/page.php?p=DOC-XTW-15-30-40')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (156, N'ABC-FNW-20-14-86', CAST(0x0000A62D011A7EC0 AS DateTime), N'120.151.3.125', N'https://www.mydomain.com/page.php?p=DOC-XDP-17-01-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (155, N'ABC-GPU-71-65-46', CAST(0x0000A62D011A768C AS DateTime), N'120.151.3.125', N'https://www.mydomain.com/page.php?p=DOC-XDP-17-01-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (154, N'ABC-QIU-54-38-10', CAST(0x0000A62D011A6C00 AS DateTime), N'120.151.3.125', N'https://www.mydomain.com/page.php?p=DOC-XDP-17-01-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (153, N'ABC-QMV-64-58-30', CAST(0x0000A62D0119A5F4 AS DateTime), N'203.134.69.34', N'http://www.mydomain.com/page.php?p=DOC-SYU-25-10-81')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (152, N'ABC-IEG-82-75-47', CAST(0x0000A62D01149834 AS DateTime), N'121.217.144.218', N'http://www.mydomain.com/page.php?p=DOC-QIO-72-25-65')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (151, N'ABC-LBV-22-16-77', CAST(0x0000A62D01149834 AS DateTime), N'121.217.144.218', N'http://www.mydomain.com/page.php?p=DOC-QIO-72-25-65')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (150, N'ABC-KFX-52-46-27', CAST(0x0000A62D0112A04C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (149, N'ABC-AIA-38-12-84', CAST(0x0000A62D011235A8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (148, N'ABC-WYG-46-31-12', CAST(0x0000A62D01121028 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (147, N'ABC-URO-86-71-42', CAST(0x0000A62D011139B4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (146, N'ABC-SQW-65-50-21', CAST(0x0000A62D0111249C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (145, N'ABC-OLZ-34-17-80', CAST(0x0000A62D011117B8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (144, N'ABC-QXE-84-78-50', CAST(0x0000A62D01110AD4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (143, N'ABC-VUB-86-71-52', CAST(0x0000A62D0110DF78 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (142, N'ABC-VUB-86-71-52', CAST(0x0000A62D0110D870 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (141, N'ABC-PTS-74-68-30', CAST(0x0000A62D0110CDE4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (140, N'ABC-XLT-37-21-03', CAST(0x0000A62D0110C22C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (139, N'ABC-RPY-85-78-51', CAST(0x0000A62D0110B548 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (138, N'ABC-RCL-75-58-31', CAST(0x0000A62D0110A4E0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VXX-46-31-02')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (137, N'ABC-HOK-41-35-16', CAST(0x0000A62D01106A48 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-LQV-13-06-68')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (136, N'ABC-ENX-30-14-85', CAST(0x0000A62D01103B68 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (135, N'ABC-WYG-46-31-12', CAST(0x0000A62D01100454 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (134, N'ABC-KKE-02-86-57', CAST(0x0000A62D010EED6C AS DateTime), N'49.190.16.122', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (133, N'ABC-YOL-77-62-43', CAST(0x0000A62D010EACF8 AS DateTime), N'49.190.16.122', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (132, N'ABC-AZC-88-73-44', CAST(0x0000A62D010E29B8 AS DateTime), N'139.218.80.144', N'https://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (131, N'ABC-ZVW-08-82-64', CAST(0x0000A62D010E2184 AS DateTime), N'49.190.16.122', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (130, N'ABC-WSZ-57-41-13', CAST(0x0000A62D010DEDF4 AS DateTime), N'49.190.16.122', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (129, N'ABC-AUU-38-23-84', CAST(0x0000A62D010D928C AS DateTime), N'49.190.16.122', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (128, N'ABC-DND-10-83-65', CAST(0x0000A62D010D1B04 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (127, N'ABC-ICF-71-65-46', CAST(0x0000A62D010CD004 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (126, N'ABC-KGD-52-46-27', CAST(0x0000A62D010C668C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-LQV-13-06-68')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (125, N'ABC-SLQ-15-80-61', CAST(0x0000A62D010B5B5C AS DateTime), N'139.218.80.144', N'http://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (124, N'ABC-EZS-20-72-45', CAST(0x0000A62D01082004 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (123, N'ABC-EZS-20-72-45', CAST(0x0000A62D01082004 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (122, N'ABC-HVN-11-85-66', CAST(0x0000A62D01080C18 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (121, N'ABC-TXT-85-70-51', CAST(0x0000A62D0107E440 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (120, N'ABC-TXT-85-70-51', CAST(0x0000A62D0107BC68 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (119, N'ABC-OOX-54-47-10', CAST(0x0000A62D01079364 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (118, N'ABC-DSQ-30-24-05', CAST(0x0000A62D010736D0 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (117, N'ABC-LNB-83-76-48', CAST(0x0000A62D01070B74 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (116, N'ABC-OOX-54-47-10', CAST(0x0000A62D0106AB5C AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (115, N'ABC-OOX-54-47-10', CAST(0x0000A62D010677CC AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (114, N'ABC-DSQ-30-24-05', CAST(0x0000A62D01063E60 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (113, N'ABC-HVN-11-85-66', CAST(0x0000A62D01061A0C AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (112, N'ABC-DUV-60-54-25', CAST(0x0000A62D0105E8D4 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (111, N'ABC-SMU-25-10-71', CAST(0x0000A62D0105CB88 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (110, N'ABC-IOO-51-45-26', CAST(0x0000A62D0105B79C AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (109, N'ABC-CPC-10-03-65', CAST(0x0000A62D01058B14 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (108, N'ABC-BTX-78-63-44', CAST(0x0000A62D01056B70 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (107, N'ABC-AGH-78-63-44', CAST(0x0000A62D01055400 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (106, N'ABC-WJV-47-31-03', CAST(0x0000A62D010218A8 AS DateTime), N'203.8.17.239', N'https://www.mydomain.com/page.php?p=DOC-TRB-15-80-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (105, N'ABC-LNT-13-86-68', CAST(0x0000A62D0101C7CC AS DateTime), N'164.53.221.81', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (104, N'ABC-NEZ-03-77-58', CAST(0x0000A62D00FFAA64 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (103, N'ABC-HDU-71-65-46', CAST(0x0000A62D00FEAF9C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (102, N'ABC-HDU-71-65-46', CAST(0x0000A62D00FD7910 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (101, N'ABC-WYG-46-31-12', CAST(0x0000A62D00FB71EC AS DateTime), N'203.45.210.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (100, N'ABC-ENX-30-14-85', CAST(0x0000A62D00FB55CC AS DateTime), N'203.45.210.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (99, N'ABC-RUU-15-75-46', CAST(0x0000A62D00FB4564 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-WTQ-77-61-43')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (98, N'ABC-DND-10-83-65', CAST(0x0000A62D00FB1FE4 AS DateTime), N'203.45.210.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (97, N'ABC-NEZ-03-77-58', CAST(0x0000A62D00FAFDE8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (96, N'ABC-ICF-71-65-46', CAST(0x0000A62D00FA7E2C AS DateTime), N'203.45.210.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (95, N'ABC-DND-10-83-65', CAST(0x0000A62D00FA51A4 AS DateTime), N'203.45.210.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (94, N'ABC-WYG-46-31-12', CAST(0x0000A62D00FA29CC AS DateTime), N'203.45.210.129', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (93, N'ABC-RUU-15-75-46', CAST(0x0000A62D00FA22C4 AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-WTQ-77-61-43')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (92, N'ABC-BRY-58-43-24', CAST(0x0000A62D00F45AB0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (91, N'ABC-MEX-83-77-58', CAST(0x0000A62D00F2CB14 AS DateTime), N'115.70.62.198', N'http://intranet2.mydomain.com/page.php?p=DOC-CSN-58-33-14')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (90, N'ABC-NKQ-13-07-68', CAST(0x0000A62D00EEE5D0 AS DateTime), N'120.21.146.219', N'http://www.mydomain.com/page.php?p=DOC-LTD-41-41-75')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (89, N'ABC-NKQ-13-07-68', CAST(0x0000A62D00EECC08 AS DateTime), N'120.21.146.219', N'http://www.mydomain.com/page.php?p=DOC-LTD-41-41-75')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (88, N'ABC-KBO-02-86-67', CAST(0x0000A62D00EEC62C AS DateTime), N'1.144.96.17', N'https://www.mydomain.com/page.php?p=DOC-DGQ-07-22-33')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (87, N'ABC-NEZ-03-77-58', CAST(0x0000A62D00ECF040 AS DateTime), N'120.22.86.123', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (86, N'ABC-OUE-03-87-58', CAST(0x0000A62D00EBE63C AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (85, N'ABC-CPR-28-13-84', CAST(0x0000A62D00E9DCC0 AS DateTime), N'203.49.251.228', N'https://www.mydomain.com/page.php?p=DOC-JYY-57-42-23')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (84, N'ABC-EKA-50-44-25', CAST(0x0000A62D00E992EC AS DateTime), N'203.49.251.228', N'https://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (83, N'ABC-AGH-78-63-44', CAST(0x0000A62D00E93400 AS DateTime), N'203.49.251.228', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (82, N'ABC-RFL-35-28-81', CAST(0x0000A62D00E91204 AS DateTime), N'203.49.251.228', N'https://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (81, N'ABC-NEZ-03-77-58', CAST(0x0000A62D00E851D4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (80, N'ABC-IQU-30-54-88', CAST(0x0000A62D00E35B84 AS DateTime), N'203.40.129.98', N'http://www.mydomain.com/page.php?p=DOC-ADE-88-72-54')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (79, N'ABC-ZMJ-87-72-54', CAST(0x0000A62D00DF6380 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-CMD-30-23-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (78, N'ABC-LNT-13-86-68', CAST(0x0000A62D00DEFEB8 AS DateTime), N'101.191.55.96', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (77, N'ABC-WTT-76-61-32', CAST(0x0000A62D00DD52FC AS DateTime), N'58.166.84.224', N'http://www.mydomain.com/page.php?p=DOC-WIN-06-81-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (76, N'ABC-LNT-13-86-68', CAST(0x0000A62D00DD3100 AS DateTime), N'101.191.55.96', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (75, N'ABC-NEZ-03-77-58', CAST(0x0000A62D00DCC9E0 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (74, N'ABC-LNT-13-86-68', CAST(0x0000A62D00DC84BC AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-PSY-42-64-07')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (73, N'ABC-NHG-13-07-78', CAST(0x0000A62D00DA8374 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (72, N'ABC-NAH-13-07-78', CAST(0x0000A62D00D9C920 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-CFK-74-67-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (71, N'ABC-LWD-23-16-88', CAST(0x0000A62D00D92AEC AS DateTime), N'101.175.180.212', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (70, N'ABC-LWD-23-16-88', CAST(0x0000A62D00D91BB0 AS DateTime), N'101.175.180.212', N'http://www.mydomain.com/page.php?p=DOC-YFG-47-30-44')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (69, N'ABC-JIH-72-56-37', CAST(0x0000A62D00D90440 AS DateTime), N'115.70.62.198', N'http://intranet2.mydomain.com/page.php?p=DOC-CMP-45-38-11')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (68, N'ABC-QIV-74-66-46', CAST(0x0000A62D00D863B4 AS DateTime), N'220.101.84.14', N'http://www.mydomain.com/page.php?p=DOC-VDT-14-36-70')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (67, N'ABC-UHC-36-86-02', CAST(0x0000A62D00D857FC AS DateTime), N'220.101.84.14', N'http://www.mydomain.com/page.php?p=DOC-VDT-14-36-70')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (66, N'ABC-YZG-67-52-33', CAST(0x0000A62D00D81788 AS DateTime), N'220.233.12.250', N'http://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (65, N'ABC-WOI-06-81-52', CAST(0x0000A62D00D65B64 AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
GO
print 'Processed 500 total records'
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (64, N'ABC-WOI-06-81-52', CAST(0x0000A62D00D6590C AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (63, N'ABC-YZG-67-52-33', CAST(0x0000A62D00D52E38 AS DateTime), N'220.233.12.250', N'http://www.mydomain.com/page.php?p=DOC-FSA-61-31-12')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (62, N'ABC-AZC-88-73-44', CAST(0x0000A62D00D36E90 AS DateTime), N'172.199.55.52', N'https://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (61, N'ABC-AZC-88-73-44', CAST(0x0000A62D00D36D64 AS DateTime), N'172.199.55.52', N'https://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (60, N'ABC-NHG-13-07-78', CAST(0x0000A62D00D33FB0 AS DateTime), N'172.199.55.52', N'https://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (59, N'ABC-NHG-13-07-78', CAST(0x0000A62D00D33D58 AS DateTime), N'172.199.55.52', N'https://www.mydomain.com/page.php?p=DOC-HUJ-08-83-64')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (58, N'ABC-CJN-61-81-33', CAST(0x0000A62D00D2C828 AS DateTime), N'153.107.193.213', N'http://www.mydomain.com/page.php?p=DOC-YIO-07-82-63')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (57, N'ABC-OUE-03-87-58', CAST(0x0000A62D00CE23E0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-LTF-43-36-18')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (56, N'ABC-CJN-61-81-33', CAST(0x0000A62D00CDBB94 AS DateTime), N'220.157.66.243', N'http://www.mydomain.com/page.php?p=DOC-YIO-07-82-63')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (55, N'ABC-CJN-61-81-33', CAST(0x0000A62D00CDB810 AS DateTime), N'220.157.66.243', N'http://www.mydomain.com/page.php?p=DOC-YIO-07-82-63')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (54, N'ABC-GFB-11-04-76', CAST(0x0000A62D00C19DA0 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-OVF-11-62-35')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (53, N'ABC-MTZ-53-25-88', CAST(0x0000A62D00C14364 AS DateTime), N'203.8.16.239', N'http://www.mydomain.com/page.php?p=DOC-YEE-55-10-52')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (52, N'ABC-MTZ-53-25-88', CAST(0x0000A62D00C13EB4 AS DateTime), N'203.8.16.239', N'http://www.mydomain.com/page.php?p=DOC-YEE-55-10-52')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (51, N'ABC-YVC-47-32-03', CAST(0x0000A62D00BDD350 AS DateTime), N'49.181.141.151', N'http://www.mydomain.com/index.php')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (50, N'ABC-XMH-67-52-23', CAST(0x0000A62D00BD02B8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-LQV-13-06-68')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (49, N'ABC-QNC-24-18-70', CAST(0x0000A62D00BAEEB0 AS DateTime), N'147.200.41.115', N'http://www.mydomain.com/page.php?p=DOC-UVE-26-11-72')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (48, N'ABC-NGI-63-57-38', CAST(0x0000A62D00BA8B14 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-THZ-04-04-38')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (47, N'ABC-ICF-71-65-46', CAST(0x0000A62D00B845D4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (46, N'ABC-WYG-46-31-12', CAST(0x0000A62D00B77B18 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (45, N'ABC-EHZ-70-64-45', CAST(0x0000A62D00B2E4E0 AS DateTime), N'101.187.250.82', N'http://www.mydomain.com/page.php?p=DOC-QUM-64-48-20')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (44, N'ABC-QNF-74-68-40', CAST(0x0000A62D00ADD144 AS DateTime), N'124.150.93.11', N'https://www.mydomain.com/page.php?p=DOC-NWA-83-77-48')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (43, N'ABC-VGR-76-61-42', CAST(0x0000A62D00AD96AC AS DateTime), N'124.150.93.11', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (42, N'ABC-IHJ-32-84-66', CAST(0x0000A62D00AD7CE4 AS DateTime), N'124.150.93.11', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (41, N'ABC-XAN-17-01-73', CAST(0x0000A62D00AD5764 AS DateTime), N'124.150.93.11', N'https://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (40, N'ABC-YKH-47-32-13', CAST(0x0000A62D00AD4BAC AS DateTime), N'1.144.96.21', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (39, N'ABC-YKH-47-32-13', CAST(0x0000A62D00AD343C AS DateTime), N'1.144.96.21', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (38, N'ABC-YKH-47-32-13', CAST(0x0000A62D00AD3310 AS DateTime), N'1.144.96.21', N'http://www.mydomain.com/page.php?p=DOC-BCT-06-28-62')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (37, N'ABC-WUY-87-48-12', CAST(0x0000A62D00AC998C AS DateTime), N'121.222.38.9', N'http://www.mydomain.com/page.php?p=DOC-FXX-81-20-84')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (36, N'ABC-EZH-10-84-65', CAST(0x0000A62D00ABC7C8 AS DateTime), N'203.36.67.252', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (35, N'ABC-MWS-43-27-08', CAST(0x0000A62D00ABBAE4 AS DateTime), N'203.36.67.252', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (34, N'ABC-XTB-87-71-43', CAST(0x0000A62D00ABA11C AS DateTime), N'203.36.67.252', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (33, N'ABC-NDO-63-57-38', CAST(0x0000A62D00AB82A4 AS DateTime), N'203.36.67.252', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (32, N'ABC-TIX-85-70-41', CAST(0x0000A62D00AB6EB8 AS DateTime), N'203.36.67.252', N'http://www.mydomain.com/page.php?p=DOC-THQ-85-70-51')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (31, N'ABC-ASN-48-22-04', CAST(0x0000A62D00A88D9C AS DateTime), N'141.243.9.161', N'http://www.mydomain.com/page.php?p=DOC-UTC-56-40-22')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (30, N'ABC-SNT-15-00-61', CAST(0x0000A62D00A5D0D4 AS DateTime), N'121.222.38.9', N'http://www.mydomain.com/page.php?p=DOC-QOY-84-78-50')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (29, N'ABC-JGO-12-06-77', CAST(0x0000A62D00A0A5C8 AS DateTime), N'139.218.49.15', N'http://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (28, N'ABC-JGO-12-06-77', CAST(0x0000A62D00A0A49C AS DateTime), N'139.218.49.15', N'http://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (27, N'ABC-OZR-64-57-20', CAST(0x0000A62D00A04F10 AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-MGH-41-63-06')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (26, N'ABC-GLK-51-45-16', CAST(0x0000A62D00A02F6C AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-DQG-20-13-85')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (25, N'ABC-TXT-85-70-51', CAST(0x0000A62D009EDDEC AS DateTime), N'202.74.137.36', N'http://www.mydomain.com/page.php?p=DOC-JNW-32-16-87')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (24, N'ABC-YOJ-87-72-43', CAST(0x0000A62D009DCCE0 AS DateTime), N'141.243.9.161', N'http://www.mydomain.com/page.php?p=DOC-XUK-27-12-73')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (23, N'ABC-NWZ-04-55-38', CAST(0x0000A62D009BC10C AS DateTime), N'141.243.9.161', N'http://www.mydomain.com/page.php?p=DOC-LQV-13-06-68')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (22, N'ABC-PRZ-54-38-10', CAST(0x0000A62D009B2080 AS DateTime), N'141.243.9.161', N'http://www.mydomain.com/page.php?p=DOC-LQV-13-06-68')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (21, N'ABC-DIP-70-63-45', CAST(0x0000A62D009ADDB4 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-VAT-22-46-58')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (20, N'ABC-MDL-43-37-18', CAST(0x0000A62D00982344 AS DateTime), N'203.5.105.77', N'http://www.mydomain.com/page.php?p=DOC-TXR-64-77-88')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (19, N'ABC-QUI-44-38-10', CAST(0x0000A62D009575B8 AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (18, N'ABC-QUI-44-38-10', CAST(0x0000A62D00957360 AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (17, N'ABC-QUI-44-38-10', CAST(0x0000A62D00956D84 AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (16, N'ABC-QUI-44-38-10', CAST(0x0000A62D00956B2C AS DateTime), N'1.132.96.116', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (15, N'ABC-UGL-76-60-32', CAST(0x0000A62D00933D5C AS DateTime), N'220.233.161.165', N'http://www.mydomain.com/page.php?p=DOC-GEF-57-18-82')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (14, N'ABC-USZ-76-50-32', CAST(0x0000A62D0092F004 AS DateTime), N'101.187.63.240', N'http://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (13, N'ABC-BPQ-88-63-44', CAST(0x0000A62D0092A2AC AS DateTime), N'101.187.63.240', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (12, N'ABC-QUI-44-38-10', CAST(0x0000A62D00928FEC AS DateTime), N'101.187.63.240', N'http://www.mydomain.com/page.php?p=DOC-EUE-77-32-74')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (11, N'ABC-USZ-76-50-32', CAST(0x0000A62D00924F78 AS DateTime), N'101.187.63.240', N'http://www.mydomain.com/page.php?p=DOC-LKG-53-46-28')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (10, N'ABC-AZC-88-73-44', CAST(0x0000A62D008D291C AS DateTime), N'1.144.96.87', N'http://www.mydomain.com/page.php?p=DOC-BMM-64-56-61')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (9, N'ABC-LNB-83-76-48', CAST(0x0000A62D007A7AB0 AS DateTime), N'110.146.165.57', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (8, N'ABC-JHP-32-04-66', CAST(0x0000A62D0079B378 AS DateTime), N'110.146.165.57', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (7, N'ABC-LNB-83-76-48', CAST(0x0000A62D0078C33C AS DateTime), N'110.146.165.57', N'http://www.mydomain.com/page.php?p=DOC-GFV-21-15-76')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (6, N'ABC-MDB-23-17-88', CAST(0x0000A62D00789EE8 AS DateTime), N'115.70.62.198', N'http://www.mydomain.com/page.php?p=DOC-TGF-61-54-57')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (5, N'ABC-KBO-02-86-67', CAST(0x0000A62D00780B40 AS DateTime), N'1.144.96.17', N'https://www.mydomain.com/page.php?p=DOC-DGQ-07-22-33')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (4, N'ABC-BRY-58-43-24', CAST(0x0000A62D0065E014 AS DateTime), N'120.19.181.205', N'http://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (3, N'ABC-WOI-06-81-52', CAST(0x0000A62D0061B480 AS DateTime), N'101.190.67.145', N'http://www.mydomain.com/page.php?p=DOC-ZPL-17-08-01')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (2, N'ABC-IEG-82-75-47', CAST(0x0000A62D001FF284 AS DateTime), N'120.151.132.120', N'http://www.mydomain.com/page.php?p=DOC-QIO-72-25-65')
INSERT [dbo].[tblStats] ([teID], [teGUID], [teTimestamp], [teIP], [teReferrer]) VALUES (1, N'ABC-BRY-58-43-24', CAST(0x0000A62D000DC3D4 AS DateTime), N'123.243.10.30', N'https://www.mydomain.com/page.php?p=DOC-RLJ-20-45-47')


--

Solution 1


--

SELECT [Date], [Hour] HourStart , RIGHT(CONCAT('0',([Hour] + 1)),2) HourEnd , COUNT(*) #Hits 
FROM 
(
	SELECT CAST(teTimestamp AS DATE) [Date], LEFT(CAST(teTimestamp AS TIME),2) [Hour]
	FROM [dbo].[tblStats]
)r
GROUP BY [Date],[Hour]
ORDER BY [Date],[Hour]


--

Add a comment if you have any other solution in mind. I would love to learn it. We all need to learn.

Enjoy !!! Keep Learning

Pawan Khowal

Http://MSBISkills.com

Share this

Related

Leave a comment Cancel reply