SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Area_Table](
	[AreaId] [int] IDENTITY(1,1) NOT NULL,
	[AreaName] [varchar](100) NULL,
	[City] [varchar](100) NULL,
	[Region] [varchar](100) NULL,
	[State] [varchar](100) NULL,
	[Country] [varchar](100) NULL,
	[CreatedBy] [int] NULL,
	[CreatedOn] [datetime] NULL,
	[ModifiedOn] [datetime] NULL,
	[ModifiedBy] [int] NULL,
	[isActive] [bit] NULL,
 CONSTRAINT [PK_Area_Table] PRIMARY KEY CLUSTERED 
(
	[AreaId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[DeviceLocation]    Script Date: 10/25/2018 3:07:55 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[DeviceLocation](
	[pkey] [int] IDENTITY(1,1) NOT NULL,
	[ipAddress] [varchar](50) NULL,
	[ipLocation] [varchar](100) NULL,
	[ipCountry] [varchar](100) NULL,
	[AreaId] [int] NULL,
	[AppCity] [varchar](100) NULL,
	[UpdatedOn] [datetime] NULL,
 CONSTRAINT [PK_DeviceLocation] PRIMARY KEY CLUSTERED 
(
	[pkey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[Area_Table] ON

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (1, N'Jumbo House', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (2, N'DCC', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (3, N'Dubai Mall', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (5, N'MCC', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (6, N'MOE – Cashier 1', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (7, N'MOE - Service Centre', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (8, N'MOE – Cashier 2', N'Dubai', N'Dubai', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (9, N'Al Wahda Mall', N'Abu Dhabi', N'Abu Dhabi', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (10, N'Hamdan Street', N'Abu Dhabi', N'Abu Dhabi', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (11, N'Dalma Mall', N'Abu Dhabi', N'Abu Dhabi', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (12, N'Sharjah City Centre', N'Sharjah', N'Sharjah', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (13, N'Sahara Mall', N'Sharjah', N'Sharjah', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (14, N'Sahara Mall Kiosk', N'Sharjah', N'Sharjah', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (15, N'Al Ain Mall', N'Al Ain', N'Sharjah', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (16, N'Oman Street RAK', N'Ras Al Khaimah', N'Ras Al Khaimah', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (17, N'Web Browsing', N'Web Browsing', N'Web Browsing', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

INSERT [dbo].[Area_Table] ([AreaId], [AreaName], [City], [Region], [State], [Country], [CreatedBy], [CreatedOn], [ModifiedOn], [ModifiedBy], [isActive]) VALUES (18, N'Post Purchase', N'Post Purchase', N'Post Purchase', N'UAE', N'UAE', NULL, NULL, NULL, NULL, 1)

SET IDENTITY_INSERT [dbo].[Area_Table] OFF

SET IDENTITY_INSERT [dbo].[DeviceLocation] ON 
INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6756, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T08:55:56.053' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6757, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:00:35.990' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6758, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:00:57.473' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6759, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:00:58.067' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6760, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:05:39.270' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6761, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:05:56.817' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6762, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:05:57.803' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6763, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:10:40.677' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6764, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:10:58.117' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6765, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:10:59.177' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6766, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:15:43.980' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6767, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:15:59.697' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6768, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:16:00.480' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6769, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:20:46.463' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6770, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:21:01.027' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6771, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:21:01.777' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6772, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:25:48.603' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6773, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:26:02.010' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6774, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:26:03.010' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6775, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:30:50.263' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6776, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:31:03.500' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6777, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:31:05.407' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6778, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:35:53.877' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6779, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:36:04.877' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6780, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:36:05.877' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6781, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:37:20.767' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6782, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:37:23.893' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6783, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:40:59.393' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6784, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:41:06.253' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6785, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:41:07.190' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6786, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:42:22.283' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6787, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:42:22.317' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6788, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:46:07.457' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6789, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:46:08.443' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6790, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:47:23.347' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6791, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:47:23.393' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6792, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:51:06.160' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6793, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:51:10.347' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6794, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:51:10.397' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6795, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:52:24.897' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6796, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:52:25.303' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6797, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T09:56:06.927' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6798, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:56:10.210' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6799, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T09:56:11.130' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6800, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:57:26.117' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6801, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T09:57:26.240' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6802, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:01:10.070' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6803, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:01:11.493' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6804, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:01:12.477' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6805, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:02:27.963' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6806, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:02:28.383' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6807, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:06:11.617' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6808, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:06:12.867' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6809, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:06:13.867' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6810, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:07:28.837' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6811, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:07:28.947' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6812, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:11:14.243' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6813, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:11:15.257' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6814, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:11:15.463' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6815, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:12:30.117' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6816, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:12:32.510' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6817, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:16:15.697' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6818, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:16:16.637' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6819, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:16:18.387' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6820, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:17:32.370' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6821, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:17:32.387' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6822, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:21:17.023' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6823, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:21:18.023' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6824, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:21:19.867' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6825, NULL, NULL, NULL, 8, N'Dubai', CAST(N'2018-08-16T10:22:32.727' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6826, NULL, NULL, NULL, 8, N'Dubai', CAST(N'2018-08-16T10:22:33.023' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6827, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:26:18.367' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6828, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:26:19.337' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6829, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:26:23.307' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6830, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:27:34.040' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6831, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:27:34.367' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6832, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:31:19.637' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6833, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:31:20.620' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6834, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T10:31:29.213' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6835, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:32:35.637' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6836, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:32:36.323' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6837, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:36:21.263' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6838, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:36:22.403' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6839, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:37:36.637' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6840, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:37:37.060' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6841, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:41:22.173' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6842, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:41:23.173' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6843, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:42:37.907' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6844, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:42:38.297' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6845, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:46:23.530' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6846, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:46:24.497' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6847, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:47:39.497' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6848, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:47:39.670' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6849, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:51:24.777' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6850, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:51:26.013' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6851, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:52:40.467' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6852, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:52:40.967' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6853, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:56:26.293' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6854, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T10:56:27.277' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6855, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:57:41.793' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6856, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T10:57:42.213' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6857, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:01:28.977' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6858, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:01:33.243' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6859, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:02:43.320' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6860, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:02:43.557' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6861, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:06:29.023' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6862, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:06:29.913' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6863, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:07:44.413' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6864, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:07:44.803' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6865, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:09:25.757' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6866, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:11:30.193' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6867, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:11:31.177' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6868, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:12:45.717' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6869, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:12:46.687' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6870, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:14:40.293' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6871, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:16:31.387' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6872, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:16:32.387' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6873, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:17:47.387' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6874, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:17:47.607' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6875, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:19:42.543' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6876, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:21:32.697' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6877, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:21:33.683' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6878, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:22:48.417' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6879, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:22:48.603' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6880, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:24:43.993' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6881, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:26:33.960' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6882, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:26:35.057' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6883, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:27:49.743' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6884, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:27:49.883' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6885, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:29:46.143' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6886, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:31:35.317' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6887, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:31:36.317' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6888, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:32:51.300' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6889, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:32:51.470' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6890, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:34:49.690' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6891, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:36:36.737' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6892, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:36:37.657' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6893, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:37:52.533' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6894, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:37:52.563' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6895, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:39:49.627' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6896, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:41:38.093' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6897, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:41:39.563' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6898, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T11:42:12.530' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6899, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:42:53.810' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6900, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:42:53.827' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6901, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:44:51.093' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6902, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:46:39.437' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6903, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:46:40.420' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6904, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T11:47:14.267' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6905, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:47:55.453' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6906, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:47:55.483' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6907, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:49:53.890' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6908, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:51:40.827' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6909, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:51:41.827' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6910, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T11:52:16.420' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6911, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:52:56.637' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6912, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:52:56.763' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6913, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:54:56.840' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6914, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:56:42.167' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6915, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T11:56:47.073' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6916, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T11:57:18.900' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6917, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:58:00.213' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6918, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T11:58:00.573' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6919, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T11:59:59.087' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6920, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:01:43.540' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6921, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:01:44.917' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6922, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T12:02:20.400' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6923, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:02:59.837' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6924, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:03:01.070' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6925, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T12:05:03.233' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6926, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:06:44.937' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6927, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:06:45.937' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6928, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T12:07:23.497' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6929, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:08:00.233' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6930, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:08:00.263' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6931, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T12:10:03.357' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6932, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:11:46.293' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6933, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:11:47.293' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6934, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T12:12:26.043' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6935, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:13:01.450' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6936, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:13:02.260' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6937, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T12:15:05.463' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6938, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:16:47.790' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6939, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 6, N'Dubai', CAST(N'2018-08-16T12:16:48.760' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6940, N'86.98.6.83', N'Dubai, Dubayy', N'United Arab Emirates', 1, N'Dubai', CAST(N'2018-08-16T12:17:28.727' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6941, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:18:02.993' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6942, N'86.98.79.18', N'Dubai, Dubayy', N'United Arab Emirates', 8, N'Dubai', CAST(N'2018-08-16T12:18:03.073' AS DateTime))

INSERT [dbo].[DeviceLocation] ([pkey], [ipAddress], [ipLocation], [ipCountry], [AreaId], [AppCity], [UpdatedOn]) VALUES (6943, N'86.98.42.105', N'Dubai, Dubayy', N'United Arab Emirates', 3, N'Dubai', CAST(N'2018-08-16T12:20:06.930' AS DateTime))

SET IDENTITY_INSERT [dbo].[DeviceLocation] OFF

ALTER TABLE [dbo].[Area_Table] ADD  CONSTRAINT [DF_Area_Table_isActive]  DEFAULT ((0)) FOR [isActive]

CREATE TABLE #TimeTable (hrs DATETIME)
CREATE TABLE #pingData (pid INT , areaId INT , pingTime DATETIME)
CREATE TABLE #AreaTime (areaId INT , areaName NVARCHAR(100), pingTime DATETIME)
CREATE TABLE #FinalTable (areaId INT , areaName NVARCHAR(100), checkTime DATETIME ,Devicestatus VARCHAR(MAX))

DECLARE 
  @start DATETIME = '2018-08-08 1:00', 
  @end   DATETIME =  '2018-08-08 15:00';

WITH x(n) AS 
(
  SELECT TOP (DATEDIFF(HOUR, @start, @end) + 1) 
  rn = ROW_NUMBER() OVER (ORDER BY [object_id]) 
  FROM sys.all_columns ORDER BY [object_id]
)
INSERT INTO #TimeTable(hrs) SELECT t = DATEADD(HOUR, n-1, @start) FROM x ORDER BY t;

INSERT INTO #AreaTime(areaId , areaName ,pingTime )
select m.[AreaId] ,m.[AreaName], b.hrs from Area_Table m cross join  #TimeTable b

INSERT INTO #pingData ( areaId  , pingTime )

SELECT DISTINCT [AreaId],CAST(FORMAT([UpdatedOn],'yyyy-MM-dd HH')+':00:00.000' as datetime) as pingtime 
FROM [dbo].[DeviceLocation] 
where UpdatedOn > @start and UpdatedOn < @end
order by [AreaId] , [pingtime]

INSERT INTO #FinalTable (areaId  , areaName , checkTime  ,Devicestatus )
select DISTINCT c.areaId ,c.areaName,  c.pingTime as checkedTime , CASE WHEN  p.pingTime IS NULL THEN 'INACTIVE' ELSE 'ACTIVE' END as DeviceStatus 
 from #AreaTime c
left   join #pingData p  on p.areaId = c.areaId AND  c.pingTime = P.pingTime
ORDER BY c.areaId ,  c.pingTime

/*your code starts from here */

SELECT t2.AreaId, coalesce(Status,'Active') Status
FROM (
SELECT distinct AreaId,DeviceStatus,
       STUFF((
         SELECT ' and ' + CONVERT(VARCHAR(5),checkTime,108) + ' hrs' + ' to ' + CONVERT(VARCHAR(5),DATEADD(HOUR,1,checkTime),108) + ' hrs'
         FROM #FinalTable tt
         WHERE tt.AreaId = t1.AreaId and tt.DeviceStatus =  t1.DeviceStatus
         FOR XML PATH(''),TYPE).value('(./text())[1]','VARCHAR(MAX)')
       ,1,4,'') Status
  
FROM #FinalTable t1
WHERE DeviceStatus = 'Inactive'
) t1 RIGHT JOIN 
(
SELECT distinct AreaId
FROM #FinalTable
) t2
on t1.AreaId = t2.AreaId

drop table #TimeTable ;
drop table #pingData ;
drop table #AreaTime ; 
drop table #FinalTable;

AreaId	Status
1	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
2	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
3	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
5	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
6	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
7	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
8	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
9	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
10	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
11	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
12	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
13	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
14	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
15	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
16	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
17	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs
18	01:00 hrs to 02:00 hrs and 02:00 hrs to 03:00 hrs and 03:00 hrs to 04:00 hrs and 04:00 hrs to 05:00 hrs and 05:00 hrs to 06:00 hrs and 06:00 hrs to 07:00 hrs and 07:00 hrs to 08:00 hrs and 08:00 hrs to 09:00 hrs and 09:00 hrs to 10:00 hrs and 10:00 hrs to 11:00 hrs and 11:00 hrs to 12:00 hrs and 12:00 hrs to 13:00 hrs and 13:00 hrs to 14:00 hrs and 14:00 hrs to 15:00 hrs and 15:00 hrs to 16:00 hrs