SQL Data Compare 8

Help for older versions available.

These pages cover SQL Data Compare 8, which is not the latest version. Help for other versions is also available.

SQL creation script

Page last updated 27 November 2013

To copy the SQL below, double-click on a line of code in the box, then press Ctrl+A followed by Ctrl+C.

  1. -- Drop if exist
  2. if @@trancount > 0 begin rollback end
  3. use tempdb
  4. go
  5. IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'WidgetDev')
  6.     DROP DATABASE WidgetDev
  7. IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'WidgetLive')
  8.     DROP DATABASE WidgetLive
  9. IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'WidgetTest')
  10. 	DROP DATABASE WidgetTest
  11.  
  12. --Create the databases and structure
  13. CREATE DATABASE WidgetDev
  14. GO
  15.  
  16. USE WidgetDev
  17. GO
  18.  
  19. CREATE TABLE [dbo].[WidgetDescriptions] (
  20.  [WidgetID] [int] NOT NULL ,
  21.  [ShortDescription] nvarchar(2000) NULL ,
  22.  [Description] [text] ,
  23.  [Picture] [image] NULL 
  24. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  25. GO
  26.  
  27. CREATE TABLE [dbo].[WidgetPrices] (
  28.  [RecordID] [int] IDENTITY (1, 1) NOT NULL ,
  29.  [WidgetID] [int] NULL ,
  30.  [Price] [money] NULL ,
  31.  [ValidFrom] [datetime] NULL ,
  32.  [ValidTo] [datetime] NULL ,
  33.  [Active] [char] (1) NULL 
  34. ) ON [PRIMARY]
  35. GO
  36.  
  37. CREATE TABLE [dbo].[WidgetReferences] (
  38.  [WidgetID] [int] NOT NULL ,
  39.  [Reference] [varchar] (50) NULL 
  40. ) ON [PRIMARY]
  41. GO
  42.  
  43. CREATE TABLE [dbo].[Widgets] (
  44.  [RecordID] [int] IDENTITY (1, 1) NOT NULL ,
  45.  [Description] [varchar] (50) NULL ,
  46.  [SKU] [varchar] (20) NULL 
  47. ) ON [PRIMARY]
  48. GO
  49.  
  50. CREATE TABLE [dbo].[WidgetPurchases] (
  51.  [PurchaseID] [int] IDENTITY (1, 1) NOT NULL ,
  52.  [WidgetPriceID] [int] NOT NULL ,
  53.  [Quantity] [int] NOT NULL DEFAULT (1) ,
  54.  [InvoiceNumber] [nvarchar](20) NULL ,
  55.  [Date] [datetime] NOT NULL DEFAULT (getdate())
  56. )
  57. GO
  58.  
  59. CREATE TABLE [dbo].[Contacts] (
  60.  [ID] [int] IDENTITY (1, 1) NOT NULL ,
  61.  [Name] [nvarchar](100) NOT NULL ,
  62.  [PhoneWork] [nvarchar](25) NULL ,
  63.  [PhoneMobile] [nvarchar](25) NULL ,
  64.  [Address1] [nvarchar](128) NULL ,
  65.  [Address2] [nvarchar](128) NULL ,
  66.  [Address3] [nvarchar](128) NULL ,
  67.  [JoiningDate] [datetime] NULL DEFAULT (getdate()),
  68.  [Email] [nvarchar](256) NULL
  69. )
  70. GO
  71.  
  72. ALTER TABLE [dbo].[WidgetDescriptions] WITH NOCHECK ADD 
  73.  CONSTRAINT [PK_WidgetDescriptions] PRIMARY KEY  CLUSTERED 
  74.  (
  75.   [WidgetID]
  76.  )  ON [PRIMARY] 
  77. GO
  78.  
  79. ALTER TABLE [dbo].[WidgetPrices] WITH NOCHECK ADD 
  80.  CONSTRAINT [DF_WidgetPrices_ValidFrom] DEFAULT (getdate()) FOR [ValidFrom],
  81.  CONSTRAINT [DF_WidgetPrices_Active] DEFAULT ('N') FOR [Active],
  82.  CONSTRAINT [PK_WidgetPrices] PRIMARY KEY  NONCLUSTERED 
  83.  (
  84.   [RecordID]
  85.  )  ON [PRIMARY] 
  86. GO
  87.  
  88. ALTER TABLE [dbo].[WidgetReferences] WITH NOCHECK ADD 
  89.  CONSTRAINT [PK_WidgetReferences] PRIMARY KEY  NONCLUSTERED 
  90.  (
  91.   [WidgetID]
  92.  )  ON [PRIMARY] 
  93. GO
  94.  
  95. ALTER TABLE [dbo].[Widgets] WITH NOCHECK ADD 
  96.  CONSTRAINT [PK_Widgets] PRIMARY KEY  NONCLUSTERED 
  97.  (
  98.   [RecordID]
  99.  )  ON [PRIMARY] 
  100. GO
  101.  
  102. ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD
  103.  CONSTRAINT [PK_Contacts] PRIMARY KEY CLUSTERED
  104.  (
  105.   [ID]
  106.  )
  107. GO
  108.  
  109.  CREATE  INDEX [IX_WidgetPrices] ON [dbo].[WidgetPrices]([WidgetID]) ON [PRIMARY]
  110. GO
  111.  
  112.  CREATE  INDEX [IX_WidgetPrices_1] ON [dbo].[WidgetPrices]([ValidFrom]) ON [PRIMARY]
  113. GO
  114.  
  115.  CREATE  INDEX [IX_WidgetPrices_2] ON [dbo].[WidgetPrices]([ValidTo]) ON [PRIMARY]
  116. GO
  117.  
  118.  CREATE UNIQUE CLUSTERED INDEX [IX_WidgetPurchases] ON [dbo].[WidgetPurchases]([PurchaseID]) ON [PRIMARY]
  119. GO
  120.  
  121. -- Create indexed view
  122.  
  123. CREATE VIEW dbo.WidgetPriceList
  124. WITH SCHEMABINDING 
  125. AS
  126. SELECT     dbo.Widgets.RecordID, dbo.Widgets.Description AS Widget, dbo.WidgetPrices.Price
  127. FROM       dbo.Widgets INNER JOIN
  128.            dbo.WidgetPrices ON dbo.Widgets.RecordID = dbo.WidgetPrices.RecordID
  129. GO
  130.  
  131. CREATE UNIQUE CLUSTERED INDEX [IX_WidgetPriceList] ON [dbo].[WidgetPriceList] ([RecordID])
  132. GO
  133.  
  134.  
  135.  
  136. -- *********************************** WidgetLive begins here *********************************
  137. CREATE DATABASE WidgetLive
  138. GO
  139.  
  140. USE WidgetLive
  141. GO
  142.  
  143. CREATE TABLE [dbo].[WidgetDescriptions] (
  144.  [WidgetID] [int] NOT NULL ,
  145.  [ShortDescription] nvarchar(2000) NULL ,
  146.  [Description] [text] NULL ,
  147.  [Picture] [image] NULL 
  148. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  149. GO
  150.  
  151. CREATE TABLE [dbo].[WidgetPrices] (
  152.  [RecordID] [int] IDENTITY (1, 1) NOT NULL ,
  153.  [WidgetID] [int] NULL ,
  154.  [Price] [money] NULL ,
  155.  [DateValidFrom] [datetime] NULL ,
  156.  [DateValidTo] [datetime] NULL ,
  157.  [Active] [char] (1) NULL 
  158. ) ON [PRIMARY]
  159. GO
  160.  
  161. CREATE TABLE [dbo].[WidgetReferences] (
  162.  [WidgetID] [int] NOT NULL ,
  163.  [Reference] [varchar] (50) NULL 
  164. ) ON [PRIMARY]
  165. GO
  166.  
  167. CREATE TABLE [dbo].[Widgets] (
  168.  [RecordID] [int] IDENTITY (1, 1) NOT NULL ,
  169.  [Description] [varchar] (50) NULL ,
  170.  [SKU] [varchar] (20) NULL 
  171. ) ON [PRIMARY]
  172. GO
  173.  
  174. CREATE TABLE [dbo].[WidgetPurchases] (
  175.  [PurchaseID] [int] IDENTITY (1, 1) NOT NULL ,
  176.  [WidgetPriceID] [int] NOT NULL ,
  177.  [Quantity] [int] NOT NULL DEFAULT (1) ,
  178.  [InvoiceNumber] [nvarchar] (20) NULL ,
  179.  [Date] [datetime] NOT NULL DEFAULT (getdate())
  180. )
  181. GO
  182.  
  183. CREATE TABLE [dbo].[Contacts] (
  184.  [ID] [int] IDENTITY (1, 1) NOT NULL ,
  185.  [Name] [nvarchar](100) NOT NULL ,
  186.  [PhoneWork] [nvarchar](25) NULL ,
  187.  [PhoneMobile] [nvarchar](25) NULL ,
  188.  [Address1] [nvarchar](128) NULL ,
  189.  [Address2] [nvarchar](128) NULL ,
  190.  [Address3] [nvarchar](128) NULL ,
  191.  [JoiningDate] [datetime] NULL DEFAULT (getdate()),
  192.  [Email] [nvarchar](256) NULL
  193. )
  194. GO
  195.  
  196. ALTER TABLE [dbo].[WidgetDescriptions] WITH NOCHECK ADD 
  197.  CONSTRAINT [PK_WidgetDescriptions] PRIMARY KEY  CLUSTERED 
  198.  (
  199.   [WidgetID]
  200.  )  ON [PRIMARY] 
  201. GO
  202.  
  203. ALTER TABLE [dbo].[WidgetPrices] WITH NOCHECK ADD 
  204.  CONSTRAINT [DF_WidgetPrices_DateValidFrom] DEFAULT (getdate()) FOR [DateValidFrom],
  205.  CONSTRAINT [DF_WidgetPrices_Active] DEFAULT ('N') FOR [Active],
  206.  CONSTRAINT [PK_WidgetPrices] PRIMARY KEY  NONCLUSTERED 
  207.  (
  208.   [RecordID]
  209.  )  ON [PRIMARY] 
  210. GO
  211.  
  212. ALTER TABLE [dbo].[WidgetReferences] WITH NOCHECK ADD 
  213.  CONSTRAINT [PK_WidgetReferences] PRIMARY KEY  NONCLUSTERED 
  214.  (
  215.   [WidgetID]
  216.  )  ON [PRIMARY] 
  217. GO
  218.  
  219. ALTER TABLE [dbo].[Widgets] WITH NOCHECK ADD 
  220.  CONSTRAINT [PK_Widgets] PRIMARY KEY  NONCLUSTERED 
  221.  (
  222.   [RecordID]
  223.  )  ON [PRIMARY] 
  224. GO
  225.  
  226. ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD
  227.  CONSTRAINT [PK_Contacts] PRIMARY KEY CLUSTERED
  228.  (
  229.   [ID]
  230.  )
  231. GO
  232.  
  233.  CREATE  INDEX [IX_WidgetPrices] ON [dbo].[WidgetPrices]([WidgetID]) ON [PRIMARY]
  234. GO
  235.  
  236.  CREATE  INDEX [IX_WidgetPrices_1] ON [dbo].[WidgetPrices]([DateValidFrom]) ON [PRIMARY]
  237. GO
  238.  
  239.  CREATE  INDEX [IX_WidgetPrices_2] ON [dbo].[WidgetPrices]([DateValidTo]) ON [PRIMARY]
  240. GO
  241.  
  242.  CREATE UNIQUE CLUSTERED INDEX [IX_WidgetPurchases] ON [dbo].[WidgetPurchases]([PurchaseID]) ON [PRIMARY]
  243. GO
  244.  
  245. -- Create indexed view
  246.  
  247. CREATE VIEW dbo.WidgetPriceList
  248. WITH SCHEMABINDING 
  249. AS
  250. SELECT     dbo.Widgets.RecordID, dbo.Widgets.Description AS Widget, dbo.WidgetPrices.Price
  251. FROM       dbo.Widgets INNER JOIN
  252.            dbo.WidgetPrices ON dbo.Widgets.RecordID = dbo.WidgetPrices.RecordID
  253. GO
  254.  
  255. CREATE UNIQUE CLUSTERED INDEX [IX_WidgetPriceList] ON [dbo].[WidgetPriceList] ([RecordID])
  256. GO
  257.  
  258. -- *********************************** WidgetTest begins here *********************************
  259. CREATE DATABASE WidgetTest
  260. GO
  261.  
  262. USE WidgetTest
  263. GO
  264.  
  265. CREATE TABLE [dbo].[WidgetDescriptions] (
  266.  [WidgetID] [int] NOT NULL ,
  267.  [ShortDescription] nvarchar(2000) NULL ,
  268.  [Description] [text] NULL ,
  269.  [Picture] [image] NULL 
  270. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  271. GO
  272.  
  273. CREATE TABLE [dbo].[WidgetPrices] (
  274.  [RecordID] [int] IDENTITY (1, 1) NOT NULL ,
  275.  [WidgetID] [int] NULL ,
  276.  [Price] [money] NULL ,
  277.  [DateValidFrom] [datetime] NULL ,
  278.  [DateValidTo] [datetime] NULL ,
  279.  [Active] [char] (1) NULL 
  280. ) ON [PRIMARY]
  281. GO
  282.  
  283. CREATE TABLE [dbo].[WidgetReferences] (
  284.  [WidgetID] [int] NOT NULL ,
  285.  [Reference] [varchar] (50) NULL 
  286. ) ON [PRIMARY]
  287. GO
  288.  
  289. CREATE TABLE [dbo].[Widgets] (
  290.  [RecordID] [int] IDENTITY (1, 1) NOT NULL ,
  291.  [Description] [varchar] (50) NULL ,
  292.  [SKU] [varchar] (20) NULL 
  293. ) ON [PRIMARY]
  294. GO
  295.  
  296. CREATE TABLE [dbo].[WidgetPurchases] (
  297.  [PurchaseID] [int] IDENTITY (1, 1) NOT NULL ,
  298.  [WidgetPriceID] [int] NOT NULL ,
  299.  [Quantity] [int] NOT NULL DEFAULT (1) ,
  300.  [InvoiceNumber] [nvarchar] (20) NULL ,
  301.  [Date] [datetime] NOT NULL DEFAULT (getdate())
  302. )
  303. GO
  304.  
  305. CREATE TABLE [dbo].[Contacts] (
  306.  [ID] [int] IDENTITY (1, 1) NOT NULL ,
  307.  [Name] [nvarchar](100) NULL ,
  308.  [PhoneWork] [nvarchar](25) NULL ,
  309.  [PhoneMobile] [nvarchar](25) NULL ,
  310.  [Address1] [nvarchar](128) NULL ,
  311.  [Address2] [nvarchar](128) NULL ,
  312.  [Address3] [nvarchar](128) NULL ,
  313.  [JoiningDate] [datetime] NULL DEFAULT (getdate()),
  314.  [Email] [nvarchar](256) NULL
  315. )
  316. GO
  317.  
  318. ALTER TABLE [dbo].[WidgetDescriptions] WITH NOCHECK ADD 
  319.  CONSTRAINT [PK_WidgetDescriptions] PRIMARY KEY  CLUSTERED 
  320.  (
  321.   [WidgetID]
  322.  )  ON [PRIMARY] 
  323. GO
  324.  
  325. ALTER TABLE [dbo].[WidgetPrices] WITH NOCHECK ADD 
  326.  CONSTRAINT [DF_WidgetPrices_DateValidFrom] DEFAULT (getdate()) FOR [DateValidFrom],
  327.  CONSTRAINT [DF_WidgetPrices_Active] DEFAULT ('N') FOR [Active],
  328.  CONSTRAINT [PK_WidgetPrices] PRIMARY KEY  NONCLUSTERED 
  329.  (
  330.   [RecordID]
  331.  )  ON [PRIMARY] 
  332. GO
  333.  
  334. ALTER TABLE [dbo].[WidgetReferences] WITH NOCHECK ADD 
  335.  CONSTRAINT [PK_WidgetReferences] PRIMARY KEY  NONCLUSTERED 
  336.  (
  337.   [WidgetID]
  338.  )  ON [PRIMARY] 
  339. GO
  340.  
  341. ALTER TABLE [dbo].[Widgets] WITH NOCHECK ADD 
  342.  CONSTRAINT [PK_Widgets] PRIMARY KEY  NONCLUSTERED 
  343.  (
  344.   [RecordID]
  345.  )  ON [PRIMARY] 
  346. GO
  347.  
  348. ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD
  349.  CONSTRAINT [PK_Contacts] PRIMARY KEY CLUSTERED
  350.  (
  351.   [ID]
  352.  )
  353. GO
  354.  
  355.  CREATE  INDEX [IX_WidgetPrices] ON [dbo].[WidgetPrices]([WidgetID]) ON [PRIMARY]
  356. GO
  357.  
  358.  CREATE  INDEX [IX_WidgetPrices_1] ON [dbo].[WidgetPrices]([DateValidFrom]) ON [PRIMARY]
  359. GO
  360.  
  361.  CREATE  INDEX [IX_WidgetPrices_2] ON [dbo].[WidgetPrices]([DateValidTo]) ON [PRIMARY]
  362. GO
  363.  
  364.  CREATE UNIQUE CLUSTERED INDEX [IX_WidgetPurchases] ON [dbo].[WidgetPurchases]([PurchaseID]) ON [PRIMARY]
  365. GO
  366.  
  367. -- Create indexed view
  368.  
  369. CREATE VIEW dbo.WidgetPriceList
  370. WITH SCHEMABINDING 
  371. AS
  372. SELECT     dbo.Widgets.RecordID, dbo.Widgets.Description AS Widget, dbo.WidgetPrices.Price
  373. FROM       dbo.Widgets INNER JOIN
  374.            dbo.WidgetPrices ON dbo.Widgets.RecordID = dbo.WidgetPrices.RecordID
  375. GO
  376.  
  377. CREATE UNIQUE CLUSTERED INDEX [IX_WidgetPriceList] ON [dbo].[WidgetPriceList] ([RecordID])
  378. GO
  379.  
  380.  
  381.  
  382.  
  383. -- **************************************** Insert data ****************************************
  384.  
  385. USE WidgetDev
  386. GO
  387.  
  388. BEGIN TRANSACTION
  389. SET IDENTITY_INSERT [dbo].[Widgets] ON
  390. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (1, 'Red widget', 'RW')
  391. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (2, 'Extended widget2', 'EW')
  392. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (4, 'Grow-your-own widget', 'GW')
  393. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (5, 'Widget access kit', 'AW')
  394. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (6, 'Test kit', 'TK')
  395. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (7, 'Exploded widget diagram', 'ED')
  396. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (8, 'New widget', 'NW')
  397. SET IDENTITY_INSERT [dbo].[Widgets] OFF
  398. INSERT INTO [dbo].[WidgetReferences] ([WidgetID], [Reference]) VALUES (1, 'Widget 1')
  399. INSERT INTO [dbo].[WidgetReferences] ([WidgetID], [Reference]) VALUES (2, 'Widget 2')
  400. SET IDENTITY_INSERT [dbo].[WidgetPrices] ON
  401. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [ValidFrom], [ValidTo], [Active]) VALUES (1, 1, 100, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  402. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [ValidFrom], [ValidTo], [Active]) VALUES (2, 2, 50, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  403. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [ValidFrom], [ValidTo], [Active]) VALUES (3, 4, 25, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  404. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [ValidFrom], [ValidTo], [Active]) VALUES (4, 1, 110, '2002-01-01 00:00:00.000', '2003-01-01 00:00:00.000', 'N')
  405. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [ValidFrom], [ValidTo], [Active]) VALUES (5, 2, 55, '2002-01-01 00:00:00.000', '2003-01-01 00:00:00.000', 'N')
  406. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [ValidFrom], [ValidTo], [Active]) VALUES (6, 4, 30, '2002-01-01 00:00:00.000', '2003-01-01 00:00:00.000', 'N')
  407. SET IDENTITY_INSERT [dbo].[WidgetPrices] OFF
  408. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (1, N'A widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  409.   <descriptiveText>A cunning widget</descriptiveText>
  410.   <manufacturer>Acme Inc</manufacturer>
  411.   <countryOfOrigin>UK</countryOfOrigin>
  412.   <size length="12" width="4" height="7" />
  413. </description>', 0x474946383961db00d800e64300000000698495465863cccccc010f1b003366000b14333333666666999999ffffff032d51808080021e3600333334424aafafaf01162884a5bae0e0e07b9aae586e7c1116186699991a21252020201f1f1f4f4f4fb0b0b0dfdfdf4f636f7f7f7f6079883d4d57505050021a2f00003303294ac6d8e399cccc84a9c1b7cedc739bb61e517de9f0f494b5cad4e1ea336699e2ebf15a85a5517d9f7b878d365165144876b0c9d8333366afb3b613395a0916204d5d678fa3af2d4252bed3df7f8386d0dae3cddce68db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000043002c00000000db00d8000007ff804382838485868788898a8b8c8d8e8f430907080390969798999a9b9c9d9e890900a20019081c9fa8a9aaabacad8708a21a1aa3a222090aaeb9babbbcabb000070a0a031f07b4c00913bdcbcccdce0a22a21bc2d40a1d091bc7a595cedddedf9a0ac60008d5e6c209bfb4a6b8e0eeeff0e2a2e5e7f5c308b3b4b6caf0fdfebb0346ddb2477098a463071870fbc7b0e1a680a206169c782d1bad52a71c6adca888c3280813439a83a06e14825b1c536e0c256a80c897e606e043984ca54d782c01b884c9b3dab571a3262dbc49b4d7af603d939ec3a6cd54d1a7ae8e2a9d5a8f643e5107a06afd248f1cd5aff5208ada4a36dc387a60d30a030aa0ac5b4813ffceaa552b76c482b66ff32a122b712ed59c0e0adcd54bd8105fbf60d515583c3891020efc0a13cdb913f1548b061633c67b48ec819a925352b64c751c09cd9b1189a5f53972e87f0cb05626cdb32eead4863cb62449d3f56b7052692785302af0ed020e380f1a4d8d376bd0bfbb0517ce33e782e3c8c915627ece7950e8d17775454bfda562ecc913149a5ed03b56f0e1578d2fcff35766ec1100a827c45ea47b64bec5d7c9001988f2017d308d13017605e4b79f200afc32cd54ffb526e08002212852070a32e82021f3a555217c173a729886138965dc711f0e12a25f2306582222dca1688f8a0c92a01321038cd3976531ce08ca28b3d9b8d4280c1660c0ff8e839c485f90420e72540746129453924b0ee5248a5096d85f95d55cc9609684d4586585198517215660dac3d27dd81970c05066b6a9807bf1bd6827356f26094c3b82b0a441917bf23956747a16da27837ff2c766a1f6e070682f1c5808508690a2230a9cc7352ae5a3999a03440e93eab2e677327eb2a5a29bfa198ca37f865acd003fd4709772aef4184b6faae8060048a142c4e96d5eb92897acd40494d9adbbe4444f979bd469670748a2a79db1f3209b2c00f731eb0a341f755712809a486be7380c26870088c76aabac66deb24220a8f640dbc897ac02b0226aeaf258a07eda0af32ebca5a6129b8130d98b08be851a4380b5eb3689a9bbdcde162fff2a71c542a87fe35a6a48a2a18a52c271e9f13831b203a376b127be4ef815b420870cc075a8b52888581b439ab2ca0573a2ce8f60c598b157010b234a0335eb57269145efcc33ae9ae80a4cce228e7b72c0bf186773244c07ecf4d39e38aba17b40070c948e0f72a00ed57b7e0df626e08a02ac8d107cc036b2161dc3dadd6dbafd7626f3024365d1eee6fd1ce17eff7d494e0712eef80090433e78d315274930d48e98ebf8e65e576ef9669837121b527c736e7adf9e7f2e58cf8e8cde020ff3cc7dfaec76268eddca8f8c2e841012547056e9b4073f97edb7b32e3a30bb274f81071800a00125c2474f1bf1c587ce88eec9674f410816389fc0e4d2873f15fff5d567827df6e85fc03d32e08bef7e8aa9abae3824e7a36f3f080f4853f6fbfc0f13bffc97cb044bec47c0ece14f1ab2eb9ffbc89724dc994814058ce0ee7a7796042a30780c6ca0f1180111097a907715681e398077c160fd0f80f37b44073ff8c1e535ef7925345d062de7c046ac90852cbc40f3f617c34ccd90861b5cc40d71e8c10a10ad879d1b160acb87892112b180f9e32112db76c2255a2c887b81e0132318c52926d18aaaab2107b5b845fb75d18b28ab221853f8400094117d12681e09d188a01f02508c4224e31be3a8133acaca8e77c462229cf8440a6060507e34a112d7c8203c66d18d6fbc40ac12a9333532f28ad6cb2324b72849a450b2ff50805ca22307a9471c0660929fac9d252f8949c095f28346244f2ac1144a2b8e5235af94602c6749c545b25283997c24113d0080c6f19296abfc652b9b984b029ef19855aae51a6fd99966a2ef99d0b49134a729485c02e002129480312c984dfa6c939bc15484280210413eceb19c6939273a35b1ce02ba139eda4ca6321bd94d44d4d37e3a9c133e51244f4652f310ffcc5e27076aa30f706b5ffb44e1410d91d0dd2d94a174fb0509201a5120a633111505c111316a24e79060641df5283d01c0cedded92a47b620a002280d2942e1313ff7c294c217510008cc0a66c74443d4300b09dcaea27a2f8a94d275a887562d3a87f9c8901387a49a612421433ff282a5411679f9a56b59f8669c956677710655a7508be6a1fa43a50b70f24e09dbc7401ef00803456e6e7a3dbe95ab00c370a63c254aebb130000ec3a0f4b080aaed4c989dee406d314644f0274656472aef50886d949b18b652c431d8b3ec1ae71b2afaa2cbd3285d9cc8a82a127202064a9fa39363d22663135ed62a548c9d44271b04b24d26bdb152a87ca566f7ee5250b5a20410ae80b854b62522386264b4859edb75ae55c2836405b9ec080b81ecc1f0093fba03146445bcffdad2739e7d008fc0e2c806de1713f77d7ee6a32ba990aef6f67078bc0484002cc73de07d42a92203c51bb96bb6bc41aa1b936f115ba62355d7d0b400001244f7dddfb0cff4f384b44e3b2363b94654481c1c41604279873c6d04c83ef973f7290d31c3678238049e65a026b4c5b1df63062ab1462113b58b5be731ef4ea61db325a183b2d668465cfe5e163cc589b0718d6888b2b8008f785053d56316e51a3db7b8db69245a6c59109fabf257ff00225a6ee70dfa8bdf52e26b943710c6f7d98652dcbf0845ec6618e01400132676fc5dc6d046c55d9e60f3b2e140bc24e9c8928010b3cc0ceca9b59832262c3710497a77df633e1009da44113d1887546b4100e4000013bc247da2aad8c151cd94adff88d86d6b4102ed0bd0c2fc218cdcd579fb7aca1055bced24414293811ad021d78aa11c6d8010c6425dfdfd21a41b6bef5a9dfff788003f09ac1006000248ce16013c437d27d04f1943f876b229eb2a5658cc1620810ed6903e0c62770c19e8a2ddb63d3a7c6f2eb36119bfd461988b8dc8fa076f64e606d1a63dbddd41980067cc920799b92a55b7c016ac82ded7c9fdb7ea7dcc0892d13e3516fee8706c721bd718802852f1cdf9f7e38fa4e190b04f0772e154730c0851390875931e32cfc360b51b082e330dcdccbde1dc90f8798d5b479e5b4a1341861cec28d4b500535b739c8812df2eced5c6f3b068bcfb30c74d2087de83927b3244170f44a2f9d11fa1eb978ab5b90a917b9ea964936d655bdbb0758208217b8f5d75fddf4e43d5db60898b895b09d6dc7a97ded6c376e0508286effb9373ce459bffb6f35b0df9788dae28ecbc6850148741cbadd7e1e373cce211e690917c4b791d67ba6e0cdcacab350f0d9cbbce61d9e78be8fb01eec962dd9f744fad2671dd1971702cd293f774584dde9ae7f4f35626fdad9a38ee080f72005022001f55660f7bc3f3cd35b1f7c934020e508363e32919ffc0282a0d5c0c874040fd08397f73e11bfb77bf5d70f5f6d11e734293578fe025d8225edba8007a82b0a6fce7aceb3dff5da572557d751f2664410a523cd877ffa177d9b2776ff876d016824034880b737574a452c87a680e6277d6057773af78091168136f277145840c4942e74a6814bc47f88e77f20586422882224588204840117d8291ea0ff82fb777e88907e1ff8821ee63245630c5e0554b8065934831fce4640f9b7810d087c40586451272bb507540c767ba76439c9a1830cd87f0e188545a601df93291cb26d56386eb7674440c485f1c68387e08342a078608860d4d54b676873b727002ec74f6ca83a2c387d2e38877d36851a5250f196866678457dc86d6e680870288782188663882013788768484059982425b049e8d3842bd88885f08891587d75985833658982767bc6653923b084f6e3893bc88174477da3587d84a816a17083a868630564010b482c21b088abd7825f588bd5278627971433b88bdd4654fc747f9df88b7e088a84208ac6f880a54815cbc88c15f86336e78aaf288d8c28ff8bbee78171788d40788b22610c49b88b7818419e751bf9018dd1e8845e0885e8f882c8982089e88e0b57816d67663a3278e3278ec30888c5988f2f286613010bfea86c1e2458a360015c2741b0d885c4888f0a1985ec740227e00326109229e09142a0870f696a1f2401015001e0669106e975e4887ee608891bc97e2d4940267992a9c876d973916d18933d389335098637693f39a993b7617a1af79205478d83608d43f98245d9597b8894bcc893bbe393d308946f28945129951159955679855899954c29684e290850f995ff478f46299656a9944577964ac7958ee8956cf97f1f749463499665a995e3f884ea97977a19967d79955809984932597619ff8a784998d5b79770899472f9418a692dbf86901a0999ae074bfda89395e941978949a1758f83c999c1f741997898a1e99200340aa9528eb4889a7ca79a9f7992ad5990f2536596b096b41969b6799897f89774c99bbdf998bfd967c1299cb9298c9a81669ae09bc99965cb79980b207e3c399a79169dc8399d45569d8759966689258cb609d2e99d08069e56991c0f5091d969903aa2349c709ee8f95beaa99393350aedc97680e9699d409ff599596fe741ab899477d56cc7f0006ef9445ae99fffd99d016a5ae05840057a92078a0b13c000ff220a1610020b6a99bf380285f509001aa108719fee78a18520131b0a001dfaa15c085aa950a2261a14288aff8a2aaa1a08d0a22f3a979a015a80e209345aa3c843a0b779860e2a443b4a0b18e001d8198e8b01a4aa30a4353aa19878a44095a48ea036c7d0a44f3a9e05200a1910a4240aa144ca1a376a855a6a095ccaa44eda9348639ca840a5266aa59ce78fe4e66a9ad0a6a3800115d07c34909f6936a7667aa65891a629955c03860a1c100dac7103723aa3e6284e869a59762a76bba8a8df92008e4a0bee35a5e6b83bdb53a9276aa4a8a8a9e2c1a9e5e90a70883e2144aa452a41156a53dbb90c0a109b840a900a5562677aa9c07787b52a19e320005faa5a1e007e11aaab1f7886c12a198af500538989bc5a9fca7a8e56d8aca131012561017f7a7a4d46ad88caff480251220a90002d1a02c54a4020807d7959adb3fa4be31a2503d0a9c010adf633aabfe9ae586a45f11a2582a0adb460011e9080b0c4ae1ba9af1dd5affeea223d250a0f90ae0035ad5f89b0fb14a90bdb24257100eee941bd83ac3549b1f0da1217bb08191ab0036b4a129b8f207b49163bb287d0b000a0a0382401dfaa902b0b469b28b22eab42194b902cb4ae2a1bae5ad8b23bab080aa0a113290004ab7c12598b378b42825ab4e5c216d07a6906cb7e3e1b41efaa3a512bb50f51127e5a61290b82f6aa7e6034591930a85e8b09e5daa2c43ab3af0a8465bbac4b24a56bcba8543bb74e37b6c1a7b75b8b829979b79f00b013d9ad2c845f1eeb7a7ebbffaf3f1a6482ab0a6d4b0be8ea6d578b608b0b40221ab88fbb0af3ca1a7aab3c358b6d97ab3a39bab9ba40b81c7ab27256b98b35ba01e6b8a66b2ae64a0b0f5b6144d566aeeb21b01bbbbc2013acb1b11c1bb7968ba877250264cabbcb50b213a9ba39c4b7c790bbf238a2c80b0e302bb3337bacb205bd9ab1a6d3eb0dbe1b1459ab9a7cabbd8ba6a7dd0b0e47bba116a0b41516bad6f4ab4929bde7fb0fd50ba3ea0a14316786a83abf0ef1bda210b6b6cb895abb6dfbcbbf1a11b9a3f0b6e2891a056cc01c5129b4fbb944f49cf2ebc02a81ba00e0a74b6b6767b6aa164c14082c0a938b684ae2c11ffc148deab9642601d87ac24f81c1dcbac11c2b429fea39c25a11c2310bb10a45c3365c189d1b14c0fb8535dcc36ea1bca94bb02a995f264cc48501b396aab64cecc3cf8511514cae910339c7ebc28100003b)
  414. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (2, N'A medium-sized widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  415.   <descriptiveText>This is a medium-sized widget, ideally suited for the home and garden environment</descriptiveText>
  416.   <manufacturer>Magic Widget Company</manufacturer>
  417.   <countryOfOrigin>USA</countryOfOrigin>
  418.   <size length="15" width="12" height="2" />
  419. </description>', 0x474946383961db00d800e64300000000698495465863cccccc010f1b003366000b14333333666666999999ffffff032d51808080021e3600333334424aafafaf01162884a5bae0e0e07b9aae586e7c1116186699991a21252020201f1f1f4f4f4fb0b0b0dfdfdf4f636f7f7f7f6079883d4d57505050021a2f00003303294ac6d8e399cccc84a9c1b7cedc739bb61e517de9f0f494b5cad4e1ea336699e2ebf15a85a5517d9f7b878d365165144876b0c9d8333366afb3b613395a0916204d5d678fa3af2d4252bed3df7f8386d0dae3cddce68db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000043002c00000000db00d8000007ff804382838485868788898a8b8c8d8e8f430907080390969798999a9b9c9d9e890900a20019081c9fa8a9aaabacad8708a21a1aa3a222090aaeb9babbbcabb000070a0a031f07b4c00913bdcbcccdce0a22a21bc2d40a1d091bc7a595cedddedf9a0ac60008d5e6c209bfb4a6b8e0eeeff0e2a2e5e7f5c308b3b4b6caf0fdfebb0346ddb2477098a463071870fbc7b0e1a680a206169c782d1bad52a71c6adca888c3280813439a83a06e14825b1c536e0c256a80c897e606e043984ca54d782c01b884c9b3dab571a3262dbc49b4d7af603d939ec3a6cd54d1a7ae8e2a9d5a8f643e5107a06afd248f1cd5aff5208ada4a36dc387a60d30a030aa0ac5b4813ffceaa552b76c482b66ff32a122b712ed59c0e0adcd54bd8105fbf60d515583c3891020efc0a13cdb913f1548b061633c67b48ec819a925352b64c751c09cd9b1189a5f53972e87f0cb05626cdb32eead4863cb62449d3f56b7052692785302af0ed020e380f1a4d8d376bd0bfbb0517ce33e782e3c8c915627ece7950e8d17775454bfda562ecc913149a5ed03b56f0e1578d2fcff35766ec1100a827c45ea47b64bec5d7c9001988f2017d308d13017605e4b79f200afc32cd54ffb526e08002212852070a32e82021f3a555217c173a729886138965dc711f0e12a25f2306582222dca1688f8a0c92a01321038cd3976531ce08ca28b3d9b8d4280c1660c0ff8e839c485f90420e72540746129453924b0ee5248a5096d85f95d55cc9609684d4586585198517215660dac3d27dd81970c05066b6a9807bf1bd6827356f26094c3b82b0a441917bf23956747a16da27837ff2c766a1f6e070682f1c5808508690a2230a9cc7352ae5a3999a03440e93eab2e677327eb2a5a29bfa198ca37f865acd003fd4709772aef4184b6faae8060048a142c4e96d5eb92897acd40494d9adbbe4444f979bd469670748a2a79db1f3209b2c00f731eb0a341f755712809a486be7380c26870088c76aabac66deb24220a8f640dbc897ac02b0226aeaf258a07eda0af32ebca5a6129b8130d98b08be851a4380b5eb3689a9bbdcde162fff2a71c542a87fe35a6a48a2a18a52c271e9f13831b203a376b127be4ef815b420870cc075a8b52888581b439ab2ca0573a2ce8f60c598b157010b234a0335eb57269145efcc33ae9ae80a4cce228e7b72c0bf186773244c07ecf4d39e38aba17b40070c948e0f72a00ed57b7e0df626e08a02ac8d107cc036b2161dc3dadd6dbafd7626f3024365d1eee6fd1ce17eff7d494e0712eef80090433e78d315274930d48e98ebf8e65e576ef9669837121b527c736e7adf9e7f2e58cf8e8cde020ff3cc7dfaec76268eddca8f8c2e841012547056e9b4073f97edb7b32e3a30bb274f81071800a00125c2474f1bf1c587ce88eec9674f410816389fc0e4d2873f15fff5d567827df6e85fc03d32e08bef7e8aa9abae3824e7a36f3f080f4853f6fbfc0f13bffc97cb044bec47c0ece14f1ab2eb9ffbc89724dc994814058ce0ee7a7796042a30780c6ca0f1180111097a907715681e398077c160fd0f80f37b44073ff8c1e535ef7925345d062de7c046ac90852cbc40f3f617c34ccd90861b5cc40d71e8c10a10ad879d1b160acb87892112b180f9e32112db76c2255a2c887b81e0132318c52926d18aaaab2107b5b845fb75d18b28ab221853f8400094117d12681e09d188a01f02508c4224e31be3a8133acaca8e77c462229cf8440a6060507e34a112d7c8203c66d18d6fbc40ac12a9333532f28ad6cb2324b72849a450b2ff50805ca22307a9471c0660929fac9d252f8949c095f28346244f2ac1144a2b8e5235af94602c6749c545b25283997c24113d0080c6f19296abfc652b9b984b029ef19855aae51a6fd99966a2ef99d0b49134a729485c02e002129480312c984dfa6c939bc15484280210413eceb19c6939273a35b1ce02ba139eda4ca6321bd94d44d4d37e3a9c133e51244f4652f310ffcc5e27076aa30f706b5ffb44e1410d91d0dd2d94a174fb0509201a5120a633111505c111316a24e79060641df5283d01c0cedded92a47b620a002280d2942e1313ff7c294c217510008cc0a66c74443d4300b09dcaea27a2f8a94d275a887562d3a87f9c8901387a49a612421433ff282a5411679f9a56b59f8669c956677710655a7508be6a1fa43a50b70f24e09dbc7401ef00803456e6e7a3dbe95ab00c370a63c254aebb130000ec3a0f4b080aaed4c989dee406d314644f0274656472aef50886d949b18b652c431d8b3ec1ae71b2afaa2cbd3285d9cc8a82a127202064a9fa39363d22663135ed62a548c9d44271b04b24d26bdb152a87ca566f7ee5250b5a20410ae80b854b62522386264b4859edb75ae55c2836405b9ec080b81ecc1f0093fba03146445bcffdad2739e7d008fc0e2c806de1713f77d7ee6a32ba990aef6f67078bc0484002cc73de07d42a92203c51bb96bb6bc41aa1b936f115ba62355d7d0b400001244f7dddfb0cff4f384b44e3b2363b94654481c1c41604279873c6d04c83ef973f7290d31c3678238049e65a026b4c5b1df63062ab1462113b58b5be731ef4ea61db325a183b2d668465cfe5e163cc589b0718d6888b2b8008f785053d56316e51a3db7b8db69245a6c59109fabf257ff00225a6ee70dfa8bdf52e26b943710c6f7d98652dcbf0845ec6618e01400132676fc5dc6d046c55d9e60f3b2e140bc24e9c8928010b3cc0ceca9b59832262c3710497a77df633e1009da44113d1887546b4100e4000013bc247da2aad8c151cd94adff88d86d6b4102ed0bd0c2fc218cdcd579fb7aca1055bced24414293811ad021d78aa11c6d8010c6425dfdfd21a41b6bef5a9dfff788003f09ac1006000248ce16013c437d27d04f1943f876b229eb2a5658cc1620810ed6903e0c62770c19e8a2ddb63d3a7c6f2eb36119bfd461988b8dc8fa076f64e606d1a63dbddd41980067cc920799b92a55b7c016ac82ded7c9fdb7ea7dcc0892d13e3516fee8706c721bd718802852f1cdf9f7e38fa4e190b04f0772e154730c0851390875931e32cfc360b51b082e330dcdccbde1dc90f8798d5b479e5b4a1341861cec28d4b500535b739c8812df2eced5c6f3b068bcfb30c74d2087de83927b3244170f44a2f9d11fa1eb978ab5b90a917b9ea964936d655bdbb0758208217b8f5d75fddf4e43d5db60898b895b09d6dc7a97ded6c376e0508286effb9373ce459bffb6f35b0df9788dae28ecbc6850148741cbadd7e1e373cce211e690917c4b791d67ba6e0cdcacab350f0d9cbbce61d9e78be8fb01eec962dd9f744fad2671dd1971702cd293f774584dde9ae7f4f35626fdad9a38ee080f72005022001f55660f7bc3f3cd35b1f7c934020e508363e32919ffc0282a0d5c0c874040fd08397f73e11bfb77bf5d70f5f6d11e734293578fe025d8225edba8007a82b0a6fce7aceb3dff5da572557d751f2664410a523cd877ffa177d9b2776ff876d016824034880b737574a452c87a680e6277d6057773af78091168136f277145840c4942e74a6814bc47f88e77f20586422882224588204840117d8291ea0ff82fb777e88907e1ff8821ee63245630c5e0554b8065934831fce4640f9b7810d087c40586451272bb507540c767ba76439c9a1830cd87f0e188545a601df93291cb26d56386eb7674440c485f1c68387e08342a078608860d4d54b676873b727002ec74f6ca83a2c387d2e38877d36851a5250f196866678457dc86d6e680870288782188663882013788768484059982425b049e8d3842bd88885f08891587d75985833658982767bc6653923b084f6e3893bc88174477da3587d84a816a17083a868630564010b482c21b088abd7825f588bd5278627971433b88bdd4654fc747f9df88b7e088a84208ac6f880a54815cbc88c15f86336e78aaf288d8c28ff8bbee78171788d40788b22610c49b88b7818419e751bf9018dd1e8845e0885e8f882c8982089e88e0b57816d67663a3278e3278ec30888c5988f2f286613010bfea86c1e2458a360015c2741b0d885c4888f0a1985ec740227e00326109229e09142a0870f696a1f2401015001e0669106e975e4887ee608891bc97e2d4940267992a9c876d973916d18933d389335098637693f39a993b7617a1af79205478d83608d43f98245d9597b8894bcc893bbe393d308946f28945129951159955679855899954c29684e290850f995ff478f46299656a9944577964ac7958ee8956cf97f1f749463499665a995e3f884ea97977a19967d79955809984932597619ff8a784998d5b79770899472f9418a692dbf86901a0999ae074bfda89395e941978949a1758f83c999c1f741997898a1e99200340aa9528eb4889a7ca79a9f7992ad5990f2536596b096b41969b6799897f89774c99bbdf998bfd967c1299cb9298c9a81669ae09bc99965cb79980b207e3c399a79169dc8399d45569d8759966689258cb609d2e99d08069e56991c0f5091d969903aa2349c709ee8f95beaa99393350aedc97680e9699d409ff599596fe741ab899477d56cc7f0006ef9445ae99fffd99d016a5ae05840057a92078a0b13c000ff220a1610020b6a99bf380285f509001aa108719fee78a18520131b0a001dfaa15c085aa950a2261a14288aff8a2aaa1a08d0a22f3a979a015a80e209345aa3c843a0b779860e2a443b4a0b18e001d8198e8b01a4aa30a4353aa19878a44095a48ea036c7d0a44f3a9e05200a1910a4240aa144ca1a376a855a6a095ccaa44eda9348639ca840a5266aa59ce78fe4e66a9ad0a6a3800115d07c34909f6936a7667aa65891a629955c03860a1c100dac7103723aa3e6284e869a59762a76bba8a8df92008e4a0bee35a5e6b83bdb53a9276aa4a8a8a9e2c1a9e5e90a70883e2144aa452a41156a53dbb90c0a109b840a900a5562677aa9c07787b52a19e320005faa5a1e007e11aaab1f7886c12a198af500538989bc5a9fca7a8e56d8aca131012561017f7a7a4d46ad88caff480251220a90002d1a02c54a4020807d7959adb3fa4be31a2503d0a9c010adf633aabfe9ae586a45f11a2582a0adb460011e9080b0c4ae1ba9af1dd5affeea223d250a0f90ae0035ad5f89b0fb14a90bdb24257100eee941bd83ac3549b1f0da1217bb08191ab0036b4a129b8f207b49163bb287d0b000a0a0382401dfaa902b0b469b28b22eab42194b902cb4ae2a1bae5ad8b23bab080aa0a113290004ab7c12598b378b42825ab4e5c216d07a6906cb7e3e1b41efaa3a512bb50f51127e5a61290b82f6aa7e6034591930a85e8b09e5daa2c43ab3af0a8465bbac4b24a56bcba8543bb74e37b6c1a7b75b8b829979b79f00b013d9ad2c845f1eeb7a7ebbffaf3f1a6482ab0a6d4b0be8ea6d578b608b0b40221ab88fbb0af3ca1a7aab3c358b6d97ab3a39bab9ba40b81c7ab27256b98b35ba01e6b8a66b2ae64a0b0f5b6144d566aeeb21b01bbbbc2013acb1b11c1bb7968ba877250264cabbcb50b213a9ba39c4b7c790bbf238a2c80b0e302bb3337bacb205bd9ab1a6d3eb0dbe1b1459ab9a7cabbd8ba6a7dd0b0e47bba116a0b41516bad6f4ab4929bde7fb0fd50ba3ea0a14316786a83abf0ef1bda210b6b6cb895abb6dfbcbbf1a11b9a3f0b6e2891a056cc01c5129b4fbb944f49cf2ebc02a81ba00e0a74b6b6767b6aa164c14082c0a938b684ae2c11ffc148deab9642601d87ac24f81c1dcbac11c2b429fea39c25a11c2310bb10a45c3365c189d1b14c0fb8535dcc36ea1bca94bb02a995f264cc48501b396aab64cecc3cf8511514cae910339c7ebc28100003b)
  420.  
  421. -- Populate Contacts
  422. SET IDENTITY_INSERT [dbo].[Contacts] ON
  423. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (1, N'Christopher Martin', N'01446 175923', N'07634 717173', N'17 High Street', N'Darlington', N'Cheshire', '20070914 16:09:21.383', N'Christopher.Martin@example.com')
  424. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (2, N'Joseph Bennett', N'01147 771824', N'07956 758471', N'37 Green Lane', N'Portsmouth', N'County Durham', '20070914 16:09:21.400', N'Joseph.Bennett@example.com')
  425. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (3, N'Joshua Scott', N'01940 919059', N'07331 757163', N'33 George Street', N'Llandudno', N'County Durham', '20070914 16:09:21.400', N'Joshua.Scott@example.com')
  426. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (4, N'Daniel Powell', N'01659 216066', N'07272 134093', N'93 North Street', N'Newport', N'Cheshire', '20070914 16:09:21.417', N'Daniel.Powell@example.com')
  427. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (5, N'Jennifer Washington', N'01502 976179', N'07225 483640', N'43 The Grove', N'Hull', N'Berkshire', '20070914 16:09:21.430', N'Jennifer.Washington@example.com')
  428. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (6, N'Anthony Lee', N'01200 660059', N'07696 849723', N'97 Stanley Road', N'Newport', N'Berkshire', '20070914 16:09:21.430', N'Anthony.Lee@example.com')
  429. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (7, N'Rebecca Foster', N'01340 503829', N'07960 669272', N'79 Springfield Road', N'Salisbury', N'Licolnshire', '20070914 16:09:21.447', N'Rebecca.Foster@example.com')
  430. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (8, N'Ava Walker', N'01978 657197', N'07610 445571', N'29 North Street', N'Southall', N'Oxfordshire', '20070914 16:09:21.463', N'Ava.Walker@example.com')
  431. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (9, N'Matthew Ward', N'01324 940147', N'07903 833764', N'71 Kingsway', N'London EC', N'Staffordshire', '20070914 16:09:21.477', N'Matthew.Ward@example.com')
  432. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (10, N'Matthew Mitchell', N'01661 434756', N'07822 453924', N'70 King Street', N'Worcester', N'Rutland', '20070914 16:09:21.477', N'Matthew.Mitchell@example.com')
  433. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (11, N'Megan Stewart', N'01653 610021', N'07363 920914', N'59 Broadway', N'Chelmsford', N'Berkshire', '20070914 16:09:21.493', N'Megan.Stewart@example.com')
  434. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (12, N'Mia Robinson', N'01594 360107', N'07295 889232', N'22 The Avenue', N'Wigan', N'Norfolk', '20070914 16:09:21.510', N'Mia.Robinson@example.com')
  435. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (13, N'Cameron Davis', N'01594 360107', N'07295 889232', N'35 Windsor Road', N'Watford', N'Rutland', '20070914 16:09:21.523', N'Cameron.Davis@example.com')
  436. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (14, N'Emma Howard', N'01788 915553', N'07736 274237', N'43 Park Avenue', N'Wigan', N'Derbyshire', '20070914 16:09:21.540', N'Emma.Howard@example.com')
  437. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (15, N'Liam Taylor', N'01286 103534', N'07939 391131', N'47 York Road', N'Harrow', N'Shropshire', '20070914 16:09:21.540', N'Liam.Taylor@example.com')
  438. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (16, N'Ross Ramirez', N'01945 464335', N'07126 593543', N'33 Kingsway', N'London WC', N'Herefordshire', '20070914 16:09:21.557', N'Ross.Ramirez@example.com')
  439. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (17, N'Sarah Lewis', N'01287 924924', N'07149 593067', N'91 George Street', N'Bristol', N'Cumberland', '20070914 16:09:21.570', N'Sarah.Lewis@example.com')
  440. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (18, N'Emma Taylor', N'01287 924924', N'07149 593067', N'92 Queen Street', N'Dundee', N'Kent', '20070914 16:09:21.587', N'Emma.Taylor@example.com')
  441. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (19, N'Anthony Rivera', N'01788 915553', N'07736 274237', N'97 Church Road', N'Southampton', N'Huntingdonshire', '20070914 16:09:21.587', N'Anthony.Rivera@example.com')
  442. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (20, N'Ellie King', N'01945 464335', N'07126 593543', N'29 George Street', N'Lincoln', N'Lancashire', '20070914 16:09:21.603', N'Ellie.King@example.com')
  443. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (21, N'Megan Barnes', N'01469 486350', N'07759 520189', N'92 West Street', N'York', N'Surrey', '20070914 16:09:21.620', N'Megan.Barnes@example.com')
  444. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (22, N'Scott Watson', N'01630 240971', N'07886 967048', N'91 Mill Road', N'Chester', N'Norfolk', '20070914 16:09:21.633', N'Scott.Watson@example.com')
  445. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (23, N'Emily Anderson', N'01487 403649', N'07449 889487', N'100 George Street', N'Dorchester', N'Hertfordshire', '20070914 16:09:21.633', N'Emily.Anderson@example.com')
  446. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (24, N'Nicole Martin', N'01721 599988', N'07525 825680', N'62 Kingsway', N'Colchester', N'Hertfordshire', '20070914 16:09:21.650', N'Nicole.Martin@example.com')
  447. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (25, N'David Perry', N'01212 359994', N'07270 368607', N'59 Queen Street', N'London N', N'Cheshire', '20070914 16:09:21.667', N'David.Perry@example.com')
  448. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (26, N'Abbie Rogers', N'01120 243659', N'07237 275885', N'62 Manchester Road', N'Kirkcaldy', N'Cornwall', '20070914 16:09:21.680', N'Abbie.Rogers@example.com')
  449. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (27, N'Liam Kelly', N'01140 882420', N'07354 721715', N'88 St. John''s Road', N'Manchester', N'Northamptonshire', '20070914 16:09:21.680', N'Liam.Kelly@example.com')
  450. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (28, N'Christopher Walker', N'01889 655242', N'07332 289915', N'73 North Street', N'Paisley', N'Yorkshire', '20070914 16:09:21.697', N'Christopher.Walker@example.com')
  451. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (29, N'Matthew Collins', N'01305 665775', N'07352 869339', N'60 York Road', N'Outer Hebrides', N'Staffordshire', '20070914 16:09:21.713', N'Matthew.Collins@example.com')
  452. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (30, N'Elidh Peterson', N'01183 454781', N'07295 215265', N'59 Albert Road', N'Norwich', N'Cheshire', '20070914 16:09:21.727', N'Elidh.Peterson@example.com')
  453. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (31, N'Jamie Price', N'01624 725814', N'07773 220491', N'40 Manor Road', N'Kingston upon Thames', N'Rutland', '20070914 16:09:21.743', N'Jamie.Price@example.com')
  454. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (32, N'Katie Sanchez', N'01192 635557', N'07695 694205', N'50 New Street', N'Hemel Hempstead', N'Cornwall', '20070914 16:09:21.743', N'Katie.Sanchez@example.com')
  455. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (33, N'Erin Rodriguez', N'01701 154719', N'07699 485122', N'8 York Road', N'Swindon', N'Derbyshire', '20070914 16:09:21.760', N'Erin.Rodriguez@example.com')
  456. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (34, N'Abbie Brooks', N'01287 924924', N'07149 593067', N'73 Springfield Road', N'Ipswich', N'County Durham', '20070914 16:09:21.773', N'Abbie.Brooks@example.com')
  457. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (35, N'Lauren Simmons', N'01442 337633', N'07986 644216', N'98 London Road', N'London E', N'Cheshire', '20070914 16:09:21.790', N'Lauren.Simmons@example.com')
  458. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (36, N'Emily Bennett', N'01907 200803', N'07636 884168', N'90 West Street', N'Salisbury', N'Herefordshire', '20070914 16:09:21.790', N'Emily.Bennett@example.com')
  459. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (37, N'Christopher Flores', N'01198 529461', N'07207 549127', N'74 Queens Road', N'Crewe', N'Cheshire', '20070914 16:09:21.807', N'Christopher.Flores@example.com')
  460. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (38, N'Alexander Rivera', N'01120 243659', N'07237 275885', N'25 Grange Road', N'Dudley', N'Huntingdonshire', '20070914 16:09:21.820', N'Alexander.Rivera@example.com')
  461. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (39, N'Rachel Williams', N'01512 965727', N'07889 215998', N'62 Victoria Road', N'Dundee', N'Hampshire', '20070914 16:09:21.837', N'Rachel.Williams@example.com')
  462. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (40, N'Olvia Howard', N'01547 693549', N'07341 808038', N'17 Kings Road', N'Guildford', N'Warwickshire', '20070914 16:09:21.837', N'Olvia.Howard@example.com')
  463. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (41, N'Elizabeth Flores', N'01231 471798', N'07493 384582', N'64 The Green', N'Bournemouth', N'Staffordshire', '20070914 16:09:21.853', N'Elizabeth.Flores@example.com')
  464. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (42, N'Kyle Griffin', N'01558 179557', N'07522 904690', N'21 Manchester Road', N'Kirkcaldy', N'Hampshire', '20070914 16:09:21.870', N'Kyle.Griffin@example.com')
  465. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (43, N'Laura Evan', N'01495 153619', N'07390 958114', N'68 Station Road', N'St Albans', N'Berkshire', '20070914 16:09:21.883', N'Laura.Evan@example.com')
  466. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (44, N'Katie Martinez', N'01285 948244', N'07424 397578', N'99 Windsor Road', N'Lerwick', N'Oxfordshire', '20070914 16:09:21.883', N'Katie.Martinez@example.com')
  467. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (45, N'Sophie Griffin', N'01965 513379', N'07605 294144', N'10 The Green', N'Sheffield', N'Surrey', '20070914 16:09:21.900', N'Sophie.Griffin@example.com')
  468. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (46, N'Elidh Wood', N'01198 529461', N'07207 549127', N'88 North Road', N'Northampton', N'Essex', '20070914 16:09:21.917', N'Elidh.Wood@example.com')
  469. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (47, N'Abigail Hill', N'01555 443077', N'07439 738948', N'86 The Drive', N'Sunderland', N'Hampshire', '20070914 16:09:21.930', N'Abigail.Hill@example.com')
  470. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (48, N'Scott Bell', N'01469 486350', N'07759 520189', N'25 Park Avenue', N'Harrogate', N'Surrey', '20070914 16:09:21.930', N'Scott.Bell@example.com')
  471. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (49, N'Chloe Martin', N'01329 343662', N'07783 161081', N'33 New Street', N'Telford', N'Dorset', '20070914 16:09:21.947', N'Chloe.Martin@example.com')
  472. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (50, N'Lauren Bryant', N'01752 908316', N'07676 584363', N'70 School Lane', N'Swindon', N'Middlesex', '20070914 16:09:21.963', N'Lauren.Bryant@example.com')
  473. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (51, N'Lucy Rivera', N'01287 924924', N'07149 593067', N'31 The Grove', N'Rochester', N'Cumberland', '20070914 16:09:21.977', N'Lucy.Rivera@example.com')
  474. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (52, N'Chloe Davis', N'01346 526218', N'07291 685237', N'99 The Crescent', N'Coventry', N'Shropshire', '20070914 16:09:21.977', N'Chloe.Davis@example.com')
  475. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (53, N'Joseph Thompson', N'01237 661433', N'07302 871821', N'75 Grove road', N'Truro', N'Northumberland', '20070914 16:09:21.993', N'Joseph.Thompson@example.com')
  476. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (54, N'William Wright', N'01417 502667', N'07177 363555', N'57 Station Road', N'Romford', N'Middlesex', '20070914 16:09:22.010', N'William.Wright@example.com')
  477. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (55, N'William Hughes', N'01407 629329', N'07309 884547', N'34 High Street', N'Torquay', N'Dorset', '20070914 16:09:22.023', N'William.Hughes@example.com')
  478. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (56, N'Samantha Miller', N'01333 824728', N'07634 606994', N'60 Park Lane', N'Cardiff', N'Surrey', '20070914 16:09:22.040', N'Samantha.Miller@example.com')
  479. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (57, N'William Ramirez', N'01626 530682', N'07768 951632', N'95 Grange Road', N'Cardiff', N'Berkshire', '20070914 16:09:22.040', N'William.Ramirez@example.com')
  480. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (58, N'Lauren Green', N'01811 269842', N'07316 264705', N'28 Main Street', N'Huddersfield', N'Somerset', '20070914 16:09:22.057', N'Lauren.Green@example.com')
  481. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (59, N'Jordan Henderson', N'01624 725814', N'07773 220491', N'67 The Drive', N'Tonbridge', N'Surrey', '20070914 16:09:22.070', N'Jordan.Henderson@example.com')
  482. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (60, N'Michael Richardson', N'01346 526218', N'07291 685237', N'76 Highfield Road', N'Kilmarnock', N'County Durham', '20070914 16:09:22.087', N'Michael.Richardson@example.com')
  483. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (61, N'Caitlin Washington', N'01291 914147', N'07913 286110', N'55 School Lane', N'Peterborough', N'Licolnshire', '20070914 16:09:22.103', N'Caitlin.Washington@example.com')
  484. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (62, N'Anna Long', N'01131 669331', N'07113 804523', N'41 The Avenue', N'Stevenage', N'Cornwall', '20070914 16:09:22.103', N'Anna.Long@example.com')
  485. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (63, N'Ethan Parker', N'01940 919059', N'07331 757163', N'76 York Road', N'Blackpool', N'Middlesex', '20070914 16:09:22.120', N'Ethan.Parker@example.com')
  486. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (64, N'Lauren Ramirez', N'01417 502667', N'07177 363555', N'74 Albert Road', N'Crewe', N'Kent', '20070914 16:09:22.133', N'Lauren.Ramirez@example.com')
  487. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (65, N'Joshua Price', N'01404 421474', N'07720 314778', N'24 The Green', N'Southend on Sea', N'Yorkshire', '20070914 16:09:22.150', N'Joshua.Price@example.com')
  488. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (66, N'Kyle Hall', N'01291 914147', N'07913 286110', N'25 Kingsway', N'Aberdeen', N'Lancashire', '20070914 16:09:22.150', N'Kyle.Hall@example.com')
  489. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (67, N'Bethany Hughes', N'01210 611735', N'07709 761071', N'6 New Street', N'Stevenage', N'Buckinghamshire', '20070914 16:09:22.167', N'Bethany.Hughes@example.com')
  490. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (68, N'Kyle Smith', N'01555 443077', N'07439 738948', N'90 Main Street', N'Cardiff', N'Buckinghamshire', '20070914 16:09:22.180', N'Kyle.Smith@example.com')
  491. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (69, N'Caitlin Griffin', N'01469 486350', N'07759 520189', N'100 Mill Road', N'Oxford', N'Sussex', '20070914 16:09:22.197', N'Caitlin.Griffin@example.com')
  492. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (70, N'Jamie Perez', N'01572 459202', N'07858 711874', N'86 Queens Road', N'Nottingham', N'Staffordshire', '20070914 16:09:22.213', N'Jamie.Perez@example.com')
  493. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (71, N'Jennifer Turner', N'01192 635557', N'07695 694205', N'46 London Road', N'Brighton', N'Derbyshire', '20070914 16:09:22.213', N'Jennifer.Turner@example.com')
  494. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (72, N'Alexander Barnes', N'01281 554917', N'07800 642581', N'78 North Street', N'London W', N'Lancashire', '20070914 16:09:22.227', N'Alexander.Barnes@example.com')
  495. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (73, N'Megan Campbell', N'01205 396727', N'07198 312473', N'20 Park Avenue', N'Blackburn', N'Suffolk', '20070914 16:09:22.243', N'Megan.Campbell@example.com')
  496. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (74, N'Lewis Collins', N'01237 661433', N'07302 871821', N'10 Victoria Road', N'Southall', N'Norfolk', '20070914 16:09:22.260', N'Lewis.Collins@example.com')
  497. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (75, N'Bethany Peterson', N'01784 976829', N'07885 861269', N'43 The Crescent', N'Worcester', N'Surrey', '20070914 16:09:22.260', N'Bethany.Peterson@example.com')
  498. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (76, N'Erin Martin', N'01428 428418', N'07377 251946', N'39 The Avenue', N'Milton Keynes', N'Suffolk', '20070914 16:09:22.273', N'Erin.Martin@example.com')
  499. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (77, N'Joseph Coleman', N'01788 915553', N'07736 274237', N'95 Park Avenue', N'Wolverhampton', N'Leicestershire', '20070914 16:09:22.290', N'Joseph.Coleman@example.com')
  500. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (78, N'Jordan Scott', N'01500 424473', N'07824 778422', N'12 Stanley Road', N'Galashiels', N'Cambridgeshire', '20070914 16:09:22.307', N'Jordan.Scott@example.com')
  501. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (79, N'Kieran Kelly', N'01633 392324', N'07960 870808', N'91 London Road', N'Twickenham', N'Northumberland', '20070914 16:09:22.320', N'Kieran.Kelly@example.com')
  502. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (80, N'Anthony Brown', N'01231 471798', N'07493 384582', N'41 Queensway', N'Falkirk', N'Berkshire', '20070914 16:09:22.337', N'Anthony.Brown@example.com')
  503. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (81, N'Joshua Sanders', N'01902 365096', N'07414 740869', N'12 Albert Road', N'Dundee', N'Hampshire', '20070914 16:09:22.353', N'Joshua.Sanders@example.com')
  504. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (82, N'Bethany Rivera', N'01784 976829', N'07885 861269', N'54 Church Street', N'London E', N'Northumberland', '20070914 16:09:22.353', N'Bethany.Rivera@example.com')
  505. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (83, N'Laura Hayes', N'01982 956405', N'07109 544766', N'56 Station Road', N'Brighton', N'Devon', '20070914 16:09:22.370', N'Laura.Hayes@example.com')
  506. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (84, N'Anna Griffin', N'01231 471798', N'07493 384582', N'40 Windsor Road', N'Guildford', N'Cornwall', '20070914 16:09:22.383', N'Anna.Griffin@example.com')
  507. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (85, N'Samantha Jackson', N'01231 471798', N'07493 384582', N'14 New Street', N'Llandudno', N'County Durham', '20070914 16:09:22.400', N'Samantha.Jackson@example.com')
  508. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (86, N'Kyle Sanchez', N'01978 657197', N'07610 445571', N'3 Windsor Road', N'Bromley', N'Oxfordshire', '20070914 16:09:22.400', N'Kyle.Sanchez@example.com')
  509. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (87, N'Shannon King', N'01624 725814', N'07773 220491', N'56 King Street', N'Paisley', N'Gloucestershire', '20070914 16:09:22.417', N'Shannon.King@example.com')
  510. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (88, N'Joseph Gray', N'01211 864653', N'07375 760438', N'56 South Street', N'London E', N'Gloucestershire', '20070914 16:09:22.430', N'Joseph.Gray@example.com')
  511. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (89, N'Courtney Perry', N'01210 611735', N'07709 761071', N'13 St. John''s Road', N'York', N'Berkshire', '20070914 16:09:22.447', N'Courtney.Perry@example.com')
  512. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (90, N'Matthew Campbell', N'01743 360803', N'07394 612512', N'68 Queen Street', N'Romford', N'Essex', '20070914 16:09:22.463', N'Matthew.Campbell@example.com')
  513. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (91, N'Alexis Cook', N'01624 725814', N'07773 220491', N'36 Queen Street', N'Falkirk', N'Norfolk', '20070914 16:09:22.463', N'Alexis.Cook@example.com')
  514. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (92, N'Jamie Mitchell', N'01776 202627', N'07185 505540', N'90 High Street', N'Kingston upon Thames', N'Warwickshire', '20070914 16:09:22.477', N'Jamie.Mitchell@example.com')
  515. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (93, N'Chloe Morris', N'01725 222331', N'07526 574605', N'97 Main Street', N'Bradford', N'Cambridgeshire', '20070914 16:09:22.493', N'Chloe.Morris@example.com')
  516. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (94, N'Lauren Morris', N'01914 784723', N'07264 945002', N'44 Church Street', N'Durham', N'Warwickshire', '20070914 16:09:22.510', N'Lauren.Morris@example.com')
  517. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (95, N'Olvia Barnes', N'01811 269842', N'07316 264705', N'78 Stanley Road', N'Lincoln', N'Herefordshire', '20070914 16:09:22.510', N'Olvia.Barnes@example.com')
  518. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (96, N'Olvia Hall', N'01571 657822', N'07694 711784', N'14 Windsor Road', N'Coventry', N'Middlesex', '20070914 16:09:22.523', N'Olvia.Hall@example.com')
  519. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (97, N'Scott Turner', N'01555 443077', N'07439 738948', N'87 Station Road', N'Salisbury', N'Surrey', '20070914 16:09:22.540', N'Scott.Turner@example.com')
  520. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (98, N'Rebecca Hayes', N'01802 342584', N'07296 315860', N'94 George Street', N'Bournemouth', N'Somerset', '20070914 16:09:22.557', N'Rebecca.Hayes@example.com')
  521. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (99, N'Kyle Perry', N'01653 610021', N'07363 920914', N'82 The Grove', N'Derby', N'Gloucestershire', '20070914 16:09:22.570', N'Kyle.Perry@example.com')
  522. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (100, N'Kieran Patterson', N'01389 465402', N'07266 836025', N'3 St. John''s Road', N'Bolton', N'County Durham', '20070914 16:09:22.570', N'Kieran.Patterson@example.com')
  523. SET IDENTITY_INSERT [dbo].[Contacts] OFF
  524.  
  525. -- Populate WidgetPurchases with lots of data
  526. DECLARE @purchaseCount int
  527. SET @purchaseCount = 0
  528. SET NOCOUNT ON
  529. DECLARE @temp float
  530. -- First the base set which will be common with WidgetLive
  531. SET @temp = RAND(1)
  532. WHILE (@purchaseCount < 97425) BEGIN
  533. 	INSERT INTO [dbo].[WidgetPurchases] ([WidgetPriceID], [Quantity], [InvoiceNumber], [Date]) VALUES (
  534. 		CONVERT (int, RAND() * 3) + 1, -- WidgetPriceID
  535. 		CONVERT (int, RAND() * 100) + 1, -- Quantity 
  536. 		'WIDG' + convert (nvarchar(10), convert (int, RAND() * 10000) + 1), -- InvoiceNumber
  537. 		CONVERT (datetime, -- Date
  538. 			CONVERT (nvarchar (50), 
  539. 				'2007-' + 
  540. 				CONVERT (nvarchar (2), CONVERT (int, RAND() * 11) + 1) + '-' + 
  541. 				CONVERT (nvarchar (2), CONVERT (int, RAND () * 27) + 1)
  542. 			)
  543. 		)
  544. 	)
  545. 	SET @purchaseCount = @purchaseCount + 1
  546. END
  547. -- Now some more, which won't be, to simulate "development" data entry
  548. SET @temp = RAND(314159)
  549. SET @purchaseCount = 0
  550. WHILE (@purchaseCount < 854) BEGIN
  551. 	INSERT INTO [dbo].[WidgetPurchases] ([WidgetPriceID], [Quantity], [InvoiceNumber], [Date]) VALUES (
  552. 		CONVERT (int, RAND() * 3) + 1, -- WidgetPriceID
  553. 		CONVERT (int, RAND() * 100) + 1, -- Quantity 
  554. 		'WIDG' + convert (nvarchar(10), convert (int, RAND() * 10000) + 1), -- InvoiceNumber
  555. 		CONVERT (datetime, -- Date
  556. 			CONVERT (nvarchar (50), 
  557. 				'2007-' + 
  558. 				CONVERT (nvarchar (2), CONVERT (int, RAND() * 11) + 1) + '-' + 
  559. 				CONVERT (nvarchar (2), CONVERT (int, RAND () * 27) + 1)
  560. 			)
  561. 		)
  562. 	)
  563. 	SET @purchaseCount = @purchaseCount + 1
  564. END
  565. SET NOCOUNT OFF
  566.  
  567. COMMIT TRANSACTION
  568. GO
  569.  
  570. -- **************************************** Insert data ****************************************
  571.  
  572. USE WidgetLive
  573. GO
  574.  
  575. BEGIN TRANSACTION
  576. SET IDENTITY_INSERT [dbo].[Widgets] ON
  577. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (1, 'Red widget', 'RW')
  578. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (2, 'Extended widget2', 'EW')
  579. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (3, 'Dark widget', 'DW')
  580. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (4, 'Grow-your-own widget', 'GW')
  581. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (5, 'Widget access kit', 'AW')
  582. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (6, 'Test kit', 'TK')
  583. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (7, 'Exploded widget diagram', 'ED')
  584. SET IDENTITY_INSERT [dbo].[Widgets] OFF
  585. INSERT INTO [dbo].[WidgetReferences] ([WidgetID], [Reference]) VALUES (1, 'Widget 1')
  586. INSERT INTO [dbo].[WidgetReferences] ([WidgetID], [Reference]) VALUES (2, 'Widget 2')
  587. SET IDENTITY_INSERT [dbo].[WidgetPrices] ON
  588. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [DateValidFrom], [DateValidTo], [Active]) VALUES (1, 1, 100, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  589. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [DateValidFrom], [DateValidTo], [Active]) VALUES (2, 2, 50, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  590. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [DateValidFrom], [DateValidTo], [Active]) VALUES (3, 3, 25, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  591. SET IDENTITY_INSERT [dbo].[WidgetPrices] OFF
  592. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (1, N'A widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  593.   <descriptiveText>A widget</descriptiveText>
  594.   <manufacturer>Acme Incorporated</manufacturer>
  595.   <countryOfOrigin>United Kingdom</countryOfOrigin>
  596.   <size length="12" width="4" height="7" />
  597. </description>', 0x474946383961db00d800e64300000000698495465863cccccc010f1b003366000b14333333666666999999ffffff032d51808080021e3600333334424aafafaf01162884a5bae0e0e07b9aae586e7c1116186699991a21252020201f1f1f4f4f4fb0b0b0dfdfdf4f636f7f7f7f6079883d4d57505050021a2f00003303294ac6d8e399cccc84a9c1b7cedc739bb61e517de9f0f494b5cad4e1ea336699e2ebf15a85a5517d9f7b878d365165144876b0c9d8333366afb3b613395a0916204d5d678fa3af2d4252bed3df7f8386d0dae3cddce68db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000043002c00000000db00d8000007ff804382838485868788898a8b8c8d8e8f430907080390969798999a9b9c9d9e890900a20019081c9fa8a9aaabacad8708a21a1aa3a222090aaeb9babbbcabb000070a0a031f07b4c00913bdcbcccdce0a22a21bc2d40a1d091bc7a595cedddedf9a0ac60008d5e6c209bfb4a6b8e0eeeff0e2a2e5e7f5c308b3b4b6caf0fdfebb0346ddb2477098a463071870fbc7b0e1a680a206169c782d1bad52a71c6adca888c3280813439a83a06e14825b1c536e0c256a80c897e606e043984ca54d782c01b884c9b3dab571a3262dbc49b4d7af603d939ec3a6cd54d1a7ae8e2a9d5a8f643e5107a06afd248f1cd5aff5208ada4a36dc387a60d30a030aa0ac5b4813ffceaa552b76c482b66ff32a122b712ed59c0e0adcd54bd8105fbf60d515583c3891020efc0a13cdb913f1548b061633c67b48ec819a925352b64c751c09cd9b1189a5f53972e87f0cb05626cdb32eead4863cb62449d3f56b7052692785302af0ed020e380f1a4d8d376bd0bfbb0517ce33e782e3c8c915627ece7950e8d17775454bfda562ecc913149a5ed03b56f0e1578d2fcff35766ec1100a827c45ea47b64bec5d7c9001988f2017d308d13017605e4b79f200afc32cd54ffb526e08002212852070a32e82021f3a555217c173a729886138965dc711f0e12a25f2306582222dca1688f8a0c92a01321038cd3976531ce08ca28b3d9b8d4280c1660c0ff8e839c485f90420e72540746129453924b0ee5248a5096d85f95d55cc9609684d4586585198517215660dac3d27dd81970c05066b6a9807bf1bd6827356f26094c3b82b0a441917bf23956747a16da27837ff2c766a1f6e070682f1c5808508690a2230a9cc7352ae5a3999a03440e93eab2e677327eb2a5a29bfa198ca37f865acd003fd4709772aef4184b6faae8060048a142c4e96d5eb92897acd40494d9adbbe4444f979bd469670748a2a79db1f3209b2c00f731eb0a341f755712809a486be7380c26870088c76aabac66deb24220a8f640dbc897ac02b0226aeaf258a07eda0af32ebca5a6129b8130d98b08be851a4380b5eb3689a9bbdcde162fff2a71c542a87fe35a6a48a2a18a52c271e9f13831b203a376b127be4ef815b420870cc075a8b52888581b439ab2ca0573a2ce8f60c598b157010b234a0335eb57269145efcc33ae9ae80a4cce228e7b72c0bf186773244c07ecf4d39e38aba17b40070c948e0f72a00ed57b7e0df626e08a02ac8d107cc036b2161dc3dadd6dbafd7626f3024365d1eee6fd1ce17eff7d494e0712eef80090433e78d315274930d48e98ebf8e65e576ef9669837121b527c736e7adf9e7f2e58cf8e8cde020ff3cc7dfaec76268eddca8f8c2e841012547056e9b4073f97edb7b32e3a30bb274f81071800a00125c2474f1bf1c587ce88eec9674f410816389fc0e4d2873f15fff5d567827df6e85fc03d32e08bef7e8aa9abae3824e7a36f3f080f4853f6fbfc0f13bffc97cb044bec47c0ece14f1ab2eb9ffbc89724dc994814058ce0ee7a7796042a30780c6ca0f1180111097a907715681e398077c160fd0f80f37b44073ff8c1e535ef7925345d062de7c046ac90852cbc40f3f617c34ccd90861b5cc40d71e8c10a10ad879d1b160acb87892112b180f9e32112db76c2255a2c887b81e0132318c52926d18aaaab2107b5b845fb75d18b28ab221853f8400094117d12681e09d188a01f02508c4224e31be3a8133acaca8e77c462229cf8440a6060507e34a112d7c8203c66d18d6fbc40ac12a9333532f28ad6cb2324b72849a450b2ff50805ca22307a9471c0660929fac9d252f8949c095f28346244f2ac1144a2b8e5235af94602c6749c545b25283997c24113d0080c6f19296abfc652b9b984b029ef19855aae51a6fd99966a2ef99d0b49134a729485c02e002129480312c984dfa6c939bc15484280210413eceb19c6939273a35b1ce02ba139eda4ca6321bd94d44d4d37e3a9c133e51244f4652f310ffcc5e27076aa30f706b5ffb44e1410d91d0dd2d94a174fb0509201a5120a633111505c111316a24e79060641df5283d01c0cedded92a47b620a002280d2942e1313ff7c294c217510008cc0a66c74443d4300b09dcaea27a2f8a94d275a887562d3a87f9c8901387a49a612421433ff282a5411679f9a56b59f8669c956677710655a7508be6a1fa43a50b70f24e09dbc7401ef00803456e6e7a3dbe95ab00c370a63c254aebb130000ec3a0f4b080aaed4c989dee406d314644f0274656472aef50886d949b18b652c431d8b3ec1ae71b2afaa2cbd3285d9cc8a82a127202064a9fa39363d22663135ed62a548c9d44271b04b24d26bdb152a87ca566f7ee5250b5a20410ae80b854b62522386264b4859edb75ae55c2836405b9ec080b81ecc1f0093fba03146445bcffdad2739e7d008fc0e2c806de1713f77d7ee6a32ba990aef6f67078bc0484002cc73de07d42a92203c51bb96bb6bc41aa1b936f115ba62355d7d0b400001244f7dddfb0cff4f384b44e3b2363b94654481c1c41604279873c6d04c83ef973f7290d31c3678238049e65a026b4c5b1df63062ab1462113b58b5be731ef4ea61db325a183b2d668465cfe5e163cc589b0718d6888b2b8008f785053d56316e51a3db7b8db69245a6c59109fabf257ff00225a6ee70dfa8bdf52e26b943710c6f7d98652dcbf0845ec6618e01400132676fc5dc6d046c55d9e60f3b2e140bc24e9c8928010b3cc0ceca9b59832262c3710497a77df633e1009da44113d1887546b4100e4000013bc247da2aad8c151cd94adff88d86d6b4102ed0bd0c2fc218cdcd579fb7aca1055bced24414293811ad021d78aa11c6d8010c6425dfdfd21a41b6bef5a9dfff788003f09ac1006000248ce16013c437d27d04f1943f876b229eb2a5658cc1620810ed6903e0c62770c19e8a2ddb63d3a7c6f2eb36119bfd461988b8dc8fa076f64e606d1a63dbddd41980067cc920799b92a55b7c016ac82ded7c9fdb7ea7dcc0892d13e3516fee8706c721bd718802852f1cdf9f7e38fa4e190b04f0772e154730c0851390875931e32cfc360b51b082e330dcdccbde1dc90f8798d5b479e5b4a1341861cec28d4b500535b739c8812df2eced5c6f3b068bcfb30c74d2087de83927b3244170f44a2f9d11fa1eb978ab5b90a917b9ea964936d655bdbb0758208217b8f5d75fddf4e43d5db60898b895b09d6dc7a97ded6c376e0508286effb9373ce459bffb6f35b0df9788dae28ecbc6850148741cbadd7e1e373cce211e690917c4b791d67ba6e0cdcacab350f0d9cbbce61d9e78be8fb01eec962dd9f744fad2671dd1971702cd293f774584dde9ae7f4f35626fdad9a38ee080f72005022001f55660f7bc3f3cd35b1f7c934020e508363e32919ffc0282a0d5c0c874040fd08397f73e11bfb77bf5d70f5f6d11e734293578fe025d8225edba8007a82b0a6fce7aceb3dff5da572557d751f2664410a523cd877ffa177d9b2776ff876d016824034880b737574a452c87a680e6277d6057773af78091168136f277145840c4942e74a6814bc47f88e77f20586422882224588204840117d8291ea0ff82fb777e88907e1ff8821ee63245630c5e0554b8065934831fce4640f9b7810d087c40586451272bb507540c767ba76439c9a1830cd87f0e188545a601df93291cb26d56386eb7674440c485f1c68387e08342a078608860d4d54b676873b727002ec74f6ca83a2c387d2e38877d36851a5250f196866678457dc86d6e680870288782188663882013788768484059982425b049e8d3842bd88885f08891587d75985833658982767bc6653923b084f6e3893bc88174477da3587d84a816a17083a868630564010b482c21b088abd7825f588bd5278627971433b88bdd4654fc747f9df88b7e088a84208ac6f880a54815cbc88c15f86336e78aaf288d8c28ff8bbee78171788d40788b22610c49b88b7818419e751bf9018dd1e8845e0885e8f882c8982089e88e0b57816d67663a3278e3278ec30888c5988f2f286613010bfea86c1e2458a360015c2741b0d885c4888f0a1985ec740227e00326109229e09142a0870f696a1f2401015001e0669106e975e4887ee608891bc97e2d4940267992a9c876d973916d18933d389335098637693f39a993b7617a1af79205478d83608d43f98245d9597b8894bcc893bbe393d308946f28945129951159955679855899954c29684e290850f995ff478f46299656a9944577964ac7958ee8956cf97f1f749463499665a995e3f884ea97977a19967d79955809984932597619ff8a784998d5b79770899472f9418a692dbf86901a0999ae074bfda89395e941978949a1758f83c999c1f741997898a1e99200340aa9528eb4889a7ca79a9f7992ad5990f2536596b096b41969b6799897f89774c99bbdf998bfd967c1299cb9298c9a81669ae09bc99965cb79980b207e3c399a79169dc8399d45569d8759966689258cb609d2e99d08069e56991c0f5091d969903aa2349c709ee8f95beaa99393350aedc97680e9699d409ff599596fe741ab899477d56cc7f0006ef9445ae99fffd99d016a5ae05840057a92078a0b13c000ff220a1610020b6a99bf380285f509001aa108719fee78a18520131b0a001dfaa15c085aa950a2261a14288aff8a2aaa1a08d0a22f3a979a015a80e209345aa3c843a0b779860e2a443b4a0b18e001d8198e8b01a4aa30a4353aa19878a44095a48ea036c7d0a44f3a9e05200a1910a4240aa144ca1a376a855a6a095ccaa44eda9348639ca840a5266aa59ce78fe4e66a9ad0a6a3800115d07c34909f6936a7667aa65891a629955c03860a1c100dac7103723aa3e6284e869a59762a76bba8a8df92008e4a0bee35a5e6b83bdb53a9276aa4a8a8a9e2c1a9e5e90a70883e2144aa452a41156a53dbb90c0a109b840a900a5562677aa9c07787b52a19e320005faa5a1e007e11aaab1f7886c12a198af500538989bc5a9fca7a8e56d8aca131012561017f7a7a4d46ad88caff480251220a90002d1a02c54a4020807d7959adb3fa4be31a2503d0a9c010adf633aabfe9ae586a45f11a2582a0adb460011e9080b0c4ae1ba9af1dd5affeea223d250a0f90ae0035ad5f89b0fb14a90bdb24257100eee941bd83ac3549b1f0da1217bb08191ab0036b4a129b8f207b49163bb287d0b000a0a0382401dfaa902b0b469b28b22eab42194b902cb4ae2a1bae5ad8b23bab080aa0a113290004ab7c12598b378b42825ab4e5c216d07a6906cb7e3e1b41efaa3a512bb50f51127e5a61290b82f6aa7e6034591930a85e8b09e5daa2c43ab3af0a8465bbac4b24a56bcba8543bb74e37b6c1a7b75b8b829979b79f00b013d9ad2c845f1eeb7a7ebbffaf3f1a6482ab0a6d4b0be8ea6d578b608b0b40221ab88fbb0af3ca1a7aab3c358b6d97ab3a39bab9ba40b81c7ab27256b98b35ba01e6b8a66b2ae64a0b0f5b6144d566aeeb21b01bbbbc2013acb1b11c1bb7968ba877250264cabbcb50b213a9ba39c4b7c790bbf238a2c80b0e302bb3337bacb205bd9ab1a6d3eb0dbe1b1459ab9a7cabbd8ba6a7dd0b0e47bba116a0b41516bad6f4ab4929bde7fb0fd50ba3ea0a14316786a83abf0ef1bda210b6b6cb895abb6dfbcbbf1a11b9a3f0b6e2891a056cc01c5129b4fbb944f49cf2ebc02a81ba00e0a74b6b6767b6aa164c14082c0a938b684ae2c11ffc148deab9642601d87ac24f81c1dcbac11c2b429fea39c25a11c2310bb10a45c3365c189d1b14c0fb8535dcc36ea1bca94bb02a995f264cc48501b396aab64cecc3cf8511514cae910339c7ebc28100003b)
  598. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (2, N'A medium-sized widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  599.   <descriptiveText>This is a medium-sized widget, ideally suited for the home and garden environment</descriptiveText>
  600.   <manufacturer>Magic Widget Company</manufacturer>
  601.   <countryOfOrigin>USA</countryOfOrigin>
  602.   <size length="15" width="12" height="2" />
  603. </description>', 0x474946383961d100ce00e64000000000ffffff465863cccccc698495333333999999666666032d51010f1bdfdfdf84a5ba4f4f4f1f1f1f7f7f7fafafaf003366111618586e7c0116287b9aae003333202020e0e0e0000b1434424a8080806699991a2125b0b0b03d4d575050504f636f607988021e36e2ebf1b7cedc84a9c194b5ca99cccc03294ae9f0f40000336b93b01e517dd4e1ea336699739bb65a85a5021a2fcddce6c6d8e3bed3df97aebc336666a2abb1617d8f11191f164a7849769a666699dbe6ed1a242c8db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000040002c00000000d100ce000007ff804082838485868788898a8b8c8d8e8f90918701061f059797071a1d01929e9fa0a1a2a3a4a3010500a9aaab0007a5afb0b1b2b3a20316a90c0ebaba0ca8a91ab4c1c2c3c4a103aa0601cacbcba9058703c5d2d3d4b106aa03ccda07bf85a7a90717d5e3e4e589d7a9d9dacbdcdd83dfabe1e6f3f4d2ed050aebcbbe1309c082b6521968074e5cbd83084dddd3b72fd50408fe00225be660d5bf84183332827780618001be44408008ec98c07515535988a6b1a54b20015b793409a0c24892e800a8d347b0e3cb9f07692663f84095cd9b097ce9f4a86c4003672c814aad96f381c79c376faa2ab0936900821da68a2d46b0eb365559476270e6755d518163ffe3cafacad6633b0c69216c6dab0f2438b9804df962c0945f5e551df932f4e52ab0e3483113f77d0ae0615ac48a0bff7dcc7991d099460f83cbecd59781cea80d55bdaa0a85680043496bd699ba7659bb685fc796cd5465a7da8fe90228c0f46ede0aaaacf26e6bf203c20b9c803f8247d8a32f15c7b12d579c32aa390d88c34a574453f23aa70eb3a7db9ef9a985791794aab2206f7ca10e1319d23c9a15f970b3ec3165d269e4e087cb0006dcb25532f601911380cbe4e45a5a13d4156066a83c538d70b031330041a97c209e6da93400a1322901901704150e77a16c2679474c4c5c11c5002b07c808183cc4e106005e79b558dd8ba43dd5583139997795ff7c161860905cf18de6d18d0024b0e25a3211295b4ac5c0b354660a1c4099330c8a459303b3599616964a6ac9578cc31808c090bc7d88e3882fe5b4db3a86e585259a6ef206172d1ceeb99d0154aa549f46e0ad675d2afc65955fa0b2dd78642c7efd17a802068c395c990709878f8090ae3829a5a455a4a13598a1da14880088580f8f6da564ea49aeca864e2c017c905caeda3c9028383a4a13195fe8448a8076c0ae938f7ea9c042538fcdae6300934e52f399626326a002965f56bbcc31ca9d176d2904192aee32617afa01a8c1ac9659a6ab98b86e84738206002999da7baf80b0e6184c3bfec2e8c001b9947b2f378042bbaf2849fe9bd9b5abd0f724ff29b44a4ca402a8a8a36e006f8922a7c21ab7c5a9a705c0fb499459961ce031a3720cc0b3daa80a712af99ce8b27eb0cafac9993b07784d62309fc8cdaa3fa7620209b8901cb447c2e258ac227a3ebd1d37435d43279f005c9434003ffcb080048c396db5b5d85e9c48a3e19ead985fea30ec552a787a6252d8782f000207003490a3db1eb5bbcabbbf19222acd80b75554cca828778ca16fa92dc9dd78574e810011f46d00e2892ff340c0d910425de7dc6559b432d750cbccd1a3505ef9eb1b789079caa4a35def01392bd866edebdc9875cbdcec1e8091ada7f2faf1788790012e1f037ef22a4a35cffb471d2b8375431fc3598bf1c877ff4308654fff2aff2b3a4fbf783e32ab733a4337be573cd8de7b3f3663e59f2d2c03f5d75e11d1c33dab757183da1efce2173f0aecad6f7f135f0014d00ab391ce7728021e001aa60f5f38875fdc23a0062920bb4f71ae73146b80033ee836b8290382ca68dc6c2e25400dba106fb1838af80447bbc49d8f7a5f5a5f5f54e1b5f7bdf08762cb9c033bf739629d6d7fcab82125f2053564602a83408cdf02f8963f10a24284245c170a9168bd0932e541b2705d14bbb78108144c81ceba87f45065c200a050664314ce4a6621c631c2ce4568541c9512582d0554a78d3ad4079588438b3ada316c1260621e1513c2cdad4b89ff0b1c630a1746281ef2072068d922e7d50e06acf1ff425ca40b05cde58e6018728ccbfbe426a1b6c72a6ea9430b54216b02684a4b467101a850e52a99f2bc1aba497d9af2488aa6168b0ba46203879c62db76f9b24ec6913791f4510124178c5410c08e653c2333898428235ee87ab3f900258961cd316e008fdb4495021cf0145ff2a67afa6ac538ca09c4446e2d9d6c6cc7019ec9932ca2ce89f304c0357f9849e1e1135521c49d9686590e7aba30950795d83adba94b6952531a0e95622e23ea323bb5c295dab0e038ab91d1ee2913a41c75550847f836c4d4a3a4c7cb264a539a2b1aae514f078169e5cea93a9ada4f9f102a0b42748a4845fad48a9aa3d9202f4a0ea216f4a8e2f368477c41c884e814a250ff45e303ac023d9599a3a4b884655617e9d1f0bc54a0953be958b7d9cdf92c2aa003fd814cd78acfe72d68a4e444ab5cd149d783963544751b4639edd9d7a3462d1ec48485351369d0c21e9462f3c95635052a56c766557000ad64652d4bd7b2e25580cb74db0376e1809972561f27a040294b3132d2a5a85ea33cad62527082b02d0f009ff5c4833a472f56c850b6b33501de54dbb552ec367134f12df980db961608b7721e4805531fb110de2af7ba3d65ae365a80bc056c0614d545ee75c7cb4fced2c07b0290ee277a850bd22577bcac88ad764920c5ef428223ee85ef782b7a3606f0514bb525607a0130dd494c1284fa1def2a51910304fa93340126a0ff77e5f9886d252e27095e6e1e65068115707076fcd5460a9eebc20127961016061c8633cc2c341e032f088800de08705b06949719238ee2ec1a71dc0bb3d8b7a6ede88f46b2acd7cdcf9b5ee1ee1813491baab51870b0fa71904b760d3515197906cc5c031cc910195c72c7e728d194811565168f596255ceca95bd17c339198abe9764f2d4c29bb83267f8ccffba460cd2b2660282cf9b70bee40fc05c083a034e3e3f0e2defb81129220fd08563e39bdf048d37398beec09d43b49417c9e815f5f9871c048004281d36beb90f08f8259da6cdbc485420604510f834103320635213002ea946eeaaefdc6a15c13ad68f8ea26a474d6a54bc6740f94df42a42ffdc5154fcdad182a635a97f80837498a405d655f6a9a6f7e26743fb92aa1500a54bc0026b1b4f06807b8bb637cbbb6e7b1bd8944eef022ef98291981b7e2738db8a13cd6c2a57e6dddfbea477c56dc715684527622441d0f6fde37e6b2ccd008777bc0130ef28c2405208b7e5096ec0e575d939c30e975845441271890b7ae051dcc165321eecb00dd893e2fa788243feaf4e97dce48296f70f5d209a019c72c08879708064ae5f9a2fac26370ff8c9014070029680e73dffb972dd49a45d833c8fce4ebad2734e71a7b300d6f7461ed095fb5ff6587de658f7b5d6717ef20878207e2fd0c1afc37ebcb15f77cb429fcdba8d2e2ea70069ed6c17742229d0bdff7a3f9beeafb33b7c6d0ca3756fbb76ee067ce0051d810c20efe2de467ce5149f608532c7f1b88aea9025bf754a0ffe7598cf3ccbc5ee78aa6be3bdcae67bb5204efac953def27883fabb358f37ce27baec4b04bdec9b45fbdacbdaf40020fcd34bce7b9783be5eb16178c3d168f3da97bebb042040c509587972dfbcf93ff0bde3fdfbfce19319e9d6bfc9f1d37adb547860fbdd13800fbefefdd5d7fdf9f8f7adf97355fdf4db3e6ce7847ec8c101f05777569274e0277ef9177b689475fea77e2d97371cf0775a5100f1230007587f3e674be1b780f9275f99a6760f787dce0776c4267619c87cf697781ef87c8d753691378224f80300407241526b28a8ff7509d8828ef78256138332687b21208287814c3988802bb8793ca86dd945445512847c16813fe0012978184d97785508703bb884da067cfaf66f50a86652580036b82213608147a88152c785eb86452a0686610881dd837eb026026868803a9884bdc786cfe77a1ad37f71687b00f06abf6687f19785bba787cec787f8e78531478781488283f86c8698862ab88111a8808cf8636e782f373221912887c8c301659817958887488889acb7891ee88794e280a1288ac753006ab22209f0769618715bc88a2de8882f028bb14882e9757827888579a88af7c78b4bd889440284c1687be74488d95180bd8788aa878c2ca88c6ce88aa4e18ccfb87e3f5000d608ff00b8978b5aa8881da88d8ce88b5e710dd8f18c79018eb7d668101003c9875ed67878e8a889ea987fcc882c70088f627881902802a27681f93877fbd88fcac88d1e129002298bf1f723226090078990c7b8860ca98c3540033330022019923d300327706b11e9695268391970091e407802969060b7901ba98c46e83d26799251386dc6988a1a39939ba84137899312a9931898911cc88f3e997f40498438098e9754943c799449c98a4b299403a993d568949938953f49404169954e794850a98652c9957c58955639834f0993b7828d4a68966c889669199676349697d89370d98272099629b9964848607899970bb89742499763649789481b812998f847ff984dd99762c9963781252cb1988c097a8e799286194588f96b58422030910ad4889497c9629919919b09449d7925b4040430459aa59960a72990a9f943ab991609d09aaea9576f199bcfc701b3098fb5f942b779132dc24282f09abe897f7768934c89932b809559f96bc78908cab99ca0d79cddf39556199dd2197ef9688f147608d7899deba69dc8c39d27e91f191002d2799bfe813486509ee6a96ce8793cea2990feb10a1e5093398788f1995bbb19577b589f4c189ca1b89f07a020a9e076fe79985918a08b409f06ca62f7f93af9198cfb59990bba0a0e5a9759e81b8c40a1159a60175a39199aa0ce20391fc2a000e0762e499c55880d8d40a2250aff5f273a63cfa9a22e421e1daa0a1c0002318a9107d76423ca9b057aa31996a36193a27128a18dd001b012a4438a8a7a910e8f60a34a3a75081a84500a0952ca0a547a845812588aa0a55bca0a4cfa034e1a842d52559f10a6d02301f057949f1909689aa65bd1a50ff8a6020aa6be32a7f3c6032870a7788aa48ba8a7e37585dbb9a36eca16bc52096a6a032dd2438e005343a8a88bcaa7d6e7a7c14009811a0f9fa0537a93399aca0a8c9a9e8edaa7f6250ca0daaa9040544dda7ea79aaaf8b9aae9579dd570012736a1888a659853ab9c0a78ba2a17ce50a5def3677a6aab188aaba4a702b02a16d0e39e2e146a5bcaac28eaac80c7268f71016cf3a22040ff8ddd23017c53a2d8aaa350c8ada80159a990010fca66b48a9de7daa4da9a74ea5a1b7f5500c528451260aacb39af6c5aaf258725969a1adecaa0112000e29a9ef1ca9800dba6f6aa9be3c1aee4f8ae2615ac97f9b002fb6e86da2085f0571cb0aff1a3ac7929b2b7ea7f1debb186a3012e2a00c8da3dd66a9604daa8e997592a9b081d201f1930b3f143365cc9b3275b7b367bb38a70012012b2a0d6b0ea08b4cd2ab4124bb48940092eda922f14691bc9b4d94a7a430bb58ed001a13a1c588b9f4acb88614baf9247a35cbb32201201745ab520e0af9b58b6010b78689bb6a020b5fcf9b2dd43b27c28b7107b2b466ab7b5f0b50540add50a9bdae6b71b0bff6c582ab8afe0ad1e1aae3fe4b34ba8b837b7a18e3b0b149b017a8b65d1d582961b71989bb9850422fafa43569b7fa1fb6ea34bbac100b9aa90b00b8b3c1b30b63fb6bacfd6baae3b0c9b6bb126f5b68ee74210fba5bb5b0cf96ab2367976d725bcb84abcc52b0d01c0b2abe0b2a086b119c6bcb90ba9cf5b0e9b2bb795c3b7e385bdb0e6bcdb3b0e46bb0a480b6a9f1bbea7e9a9e53b2b0992b7f554aebe25be14a2bdef8b10390b3dde0b430deb42e71424f89bbf0971beb1dbb66eebaf2f3489c639c0048c1178ab0a54fb43340699782382c5fac02f3100846bb8d2991519acc13f61c00d2ab958d9c0e329c262b1b99d1b452311c22a6c26a68bbc40045511d11ac36201bb0daab0c974af38fc18bd7b4be58a9c3fec18c75bb5435cc4d211bd084bbdde430149acc4f6d1bdaf4301cab3b5520c1c24ec0c0540bfaa60a659bcc4f13b755e15c61e8b201a90c61dd0abf91b08003b)
  604. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (3, N'A small widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  605.   <descriptiveText>This widget has been discontinued. It was last sold in 2006.</descriptiveText>
  606.   <manufacturer>Magic Widget Company</manufacturer>
  607.   <countryOfOrigin>United Kingdom</countryOfOrigin>
  608.   <size length="3" width="2" height="1" />
  609. </description>', 0x474946383961d100ce00e64000000000ffffff465863cccccc698495333333999999666666032d51010f1bdfdfdf84a5ba4f4f4f1f1f1f7f7f7fafafaf003366111618586e7c0116287b9aae003333202020e0e0e0000b1434424a8080806699991a2125b0b0b03d4d575050504f636f607988021e36e2ebf1b7cedc84a9c194b5ca99cccc03294ae9f0f40000336b93b01e517dd4e1ea336699739bb65a85a5021a2fcddce6c6d8e3bed3df97aebc336666a2abb1617d8f11191f164a7849769a666699dbe6ed1a242c8db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000040002c00000000d100ce000007ff804082838485868788898a8b8c8d8e8f90918701061f059797071a1d01929e9fa0a1a2a3a4a3010500a9aaab0007a5afb0b1b2b3a20316a90c0ebaba0ca8a91ab4c1c2c3c4a103aa0601cacbcba9058703c5d2d3d4b106aa03ccda07bf85a7a90717d5e3e4e589d7a9d9dacbdcdd83dfabe1e6f3f4d2ed050aebcbbe1309c082b6521968074e5cbd83084dddd3b72fd50408fe00225be660d5bf84183332827780618001be44408008ec98c07515535988a6b1a54b20015b793409a0c24892e800a8d347b0e3cb9f07692663f84095cd9b097ce9f4a86c4003672c814aad96f381c79c376faa2ab0936900821da68a2d46b0eb365559476270e6755d518163ffe3cafacad6633b0c69216c6dab0f2438b9804df962c0945f5e551df932f4e52ab0e3483113f77d0ae0615ac48a0bff7dcc7991d099460f83cbecd59781cea80d55bdaa0a85680043496bd699ba7659bb685fc796cd5465a7da8fe90228c0f46ede0aaaacf26e6bf203c20b9c803f8247d8a32f15c7b12d579c32aa390d88c34a574453f23aa70eb3a7db9ef9a985791794aab2206f7ca10e1319d23c9a15f970b3ec3165d269e4e087cb0006dcb25532f601911380cbe4e45a5a13d4156066a83c538d70b031330041a97c209e6da93400a1322901901704150e77a16c2679474c4c5c11c5002b07c808183cc4e106005e79b558dd8ba43dd5583139997795ff7c161860905cf18de6d18d0024b0e25a3211295b4ac5c0b354660a1c4099330c8a459303b3599616964a6ac9578cc31808c090bc7d88e3882fe5b4db3a86e585259a6ef206172d1ceeb99d0154aa549f46e0ad675d2afc65955fa0b2dd78642c7efd17a802068c395c990709878f8090ae3829a5a455a4a13598a1da14880088580f8f6da564ea49aeca864e2c017c905caeda3c9028383a4a13195fe8448a8076c0ae938f7ea9c042538fcdae6300934e52f399626326a002965f56bbcc31ca9d176d2904192aee32617afa01a8c1ac9659a6ab98b86e84738206002999da7baf80b0e6184c3bfec2e8c001b9947b2f378042bbaf2849fe9bd9b5abd0f724ff29b44a4ca402a8a8a36e006f8922a7c21ab7c5a9a705c0fb499459961ce031a3720cc0b3daa80a712af99ce8b27eb0cafac9993b07784d62309fc8cdaa3fa7620209b8901cb447c2e258ac227a3ebd1d37435d43279f005c9434003ffcb080048c396db5b5d85e9c48a3e19ead985fea30ec552a787a6252d8782f000207003490a3db1eb5bbcabbbf19222acd80b75554cca828778ca16fa92dc9dd78574e810011f46d00e2892ff340c0d910425de7dc6559b432d750cbccd1a3505ef9eb1b789079caa4a35def01392bd866edebdc9875cbdcec1e8091ada7f2faf1788790012e1f037ef22a4a35cffb471d2b8375431fc3598bf1c877ff4308654fff2aff2b3a4fbf783e32ab733a4337be573cd8de7b3f3663e59f2d2c03f5d75e11d1c33dab757183da1efce2173f0aecad6f7f135f0014d00ab391ce7728021e001aa60f5f38875fdc23a0062920bb4f71ae73146b80033ee836b8290382ca68dc6c2e25400dba106fb1838af80447bbc49d8f7a5f5a5f5f54e1b5f7bdf08762cb9c033bf739629d6d7fcab82125f2053564602a83408cdf02f8963f10a24284245c170a9168bd0932e541b2705d14bbb78108144c81ceba87f45065c200a050664314ce4a6621c631c2ce4568541c9512582d0554a78d3ad4079588438b3ada316c1260621e1513c2cdad4b89ff0b1c630a1746281ef2072068d922e7d50e06acf1ff425ca40b05cde58e6018728ccbfbe426a1b6c72a6ea9430b54216b02684a4b467101a850e52a99f2bc1aba497d9af2488aa6168b0ba46203879c62db76f9b24ec6913791f4510124178c5410c08e653c2333898428235ee87ab3f900258961cd316e008fdb4495021cf0145ff2a67afa6ac538ca09c4446e2d9d6c6cc7019ec9932ca2ce89f304c0357f9849e1e1135521c49d9686590e7aba30950795d83adba94b6952531a0e95622e23ea323bb5c295dab0e038ab91d1ee2913a41c75550847f836c4d4a3a4c7cb264a539a2b1aae514f078169e5cea93a9ada4f9f102a0b42748a4845fad48a9aa3d9202f4a0ea216f4a8e2f368477c41c884e814a250ff45e303ac023d9599a3a4b884655617e9d1f0bc54a0953be958b7d9cdf92c2aa003fd814cd78acfe72d68a4e444ab5cd149d783963544751b4639edd9d7a3462d1ec48485351369d0c21e9462f3c95635052a56c766557000ad64652d4bd7b2e25580cb74db0376e1809972561f27a040294b3132d2a5a85ea33cad62527082b02d0f009ff5c4833a472f56c850b6b33501de54dbb552ec367134f12df980db961608b7721e4805531fb110de2af7ba3d65ae365a80bc056c0614d545ee75c7cb4fced2c07b0290ee277a850bd22577bcac88ad764920c5ef428223ee85ef782b7a3606f0514bb525607a0130dd494c1284fa1def2a51910304fa93340126a0ff77e5f9886d252e27095e6e1e65068115707076fcd5460a9eebc20127961016061c8633cc2c341e032f088800de08705b06949719238ee2ec1a71dc0bb3d8b7a6ede88f46b2acd7cdcf9b5ee1ee1813491baab51870b0fa71904b760d3515197906cc5c031cc910195c72c7e728d194811565168f596255ceca95bd17c339198abe9764f2d4c29bb83267f8ccffba460cd2b2660282cf9b70bee40fc05c083a034e3e3f0e2defb81129220fd08563e39bdf048d37398beec09d43b49417c9e815f5f9871c048004281d36beb90f08f8259da6cdbc485420604510f834103320635213002ea946eeaaefdc6a15c13ad68f8ea26a474d6a54bc6740f94df42a42ffdc5154fcdad182a635a97f80837498a405d655f6a9a6f7e26743fb92aa1500a54bc0026b1b4f06807b8bb637cbbb6e7b1bd8944eef022ef98291981b7e2738db8a13cd6c2a57e6dddfbea477c56dc715684527622441d0f6fde37e6b2ccd008777bc0130ef28c2405208b7e5096ec0e575d939c30e975845441271890b7ae051dcc165321eecb00dd893e2fa788243feaf4e97dce48296f70f5d209a019c72c08879708064ae5f9a2fac26370ff8c9014070029680e73dffb972dd49a45d833c8fce4ebad2734e71a7b300d6f7461ed095fb5ff6587de658f7b5d6717ef20878207e2fd0c1afc37ebcb15f77cb429fcdba8d2e2ea70069ed6c17742229d0bdff7a3f9beeafb33b7c6d0ca3756fbb76ee067ce0051d810c20efe2de467ce5149f608532c7f1b88aea9025bf754a0ffe7598cf3ccbc5ee78aa6be3bdcae67bb5204efac953def27883fabb358f37ce27baec4b04bdec9b45fbdacbdaf40020fcd34bce7b9783be5eb16178c3d168f3da97bebb042040c509587972dfbcf93ff0bde3fdfbfce19319e9d6bfc9f1d37adb547860fbdd13800fbefefdd5d7fdf9f8f7adf97355fdf4db3e6ce7847ec8c101f05777569274e0277ef9177b689475fea77e2d97371cf0775a5100f1230007587f3e674be1b780f9275f99a6760f787dce0776c4267619c87cf697781ef87c8d753691378224f80300407241526b28a8ff7509d8828ef78256138332687b21208287814c3988802bb8793ca86dd945445512847c16813fe0012978184d97785508703bb884da067cfaf66f50a86652580036b82213608147a88152c785eb86452a0686610881dd837eb026026868803a9884bdc786cfe77a1ad37f71687b00f06abf6687f19785bba787cec787f8e78531478781488283f86c8698862ab88111a8808cf8636e782f373221912887c8c301659817958887488889acb7891ee88794e280a1288ac753006ab22209f0769618715bc88a2de8882f028bb14882e9757827888579a88af7c78b4bd889440284c1687be74488d95180bd8788aa878c2ca88c6ce88aa4e18ccfb87e3f5000d608ff00b8978b5aa8881da88d8ce88b5e710dd8f18c79018eb7d668101003c9875ed67878e8a889ea987fcc882c70088f627881902802a27681f93877fbd88fcac88d1e129002298bf1f723226090078990c7b8860ca98c3540033330022019923d300327706b11e9695268391970091e407802969060b7901ba98c46e83d26799251386dc6988a1a39939ba84137899312a9931898911cc88f3e997f40498438098e9754943c799449c98a4b299403a993d568949938953f49404169954e794850a98652c9957c58955639834f0993b7828d4a68966c889669199676349697d89370d98272099629b9964848607899970bb89742499763649789481b812998f847ff984dd99762c9963781252cb1988c097a8e799286194588f96b58422030910ad4889497c9629919919b09449d7925b4040430459aa59960a72990a9f943ab991609d09aaea9576f199bcfc701b3098fb5f942b779132dc24282f09abe897f7768934c89932b809559f96bc78908cab99ca0d79cddf39556199dd2197ef9688f147608d7899deba69dc8c39d27e91f191002d2799bfe813486509ee6a96ce8793cea2990feb10a1e5093398788f1995bbb19577b589f4c189ca1b89f07a020a9e076fe79985918a08b409f06ca62f7f93af9198cfb59990bba0a0e5a9759e81b8c40a1159a60175a39199aa0ce20391fc2a000e0762e499c55880d8d40a2250aff5f273a63cfa9a22e421e1daa0a1c0002318a9107d76423ca9b057aa31996a36193a27128a18dd001b012a4438a8a7a910e8f60a34a3a75081a84500a0952ca0a547a845812588aa0a55bca0a4cfa034e1a842d52559f10a6d02301f057949f1909689aa65bd1a50ff8a6020aa6be32a7f3c6032870a7788aa48ba8a7e37585dbb9a36eca16bc52096a6a032dd2438e005343a8a88bcaa7d6e7a7c14009811a0f9fa0537a93399aca0a8c9a9e8edaa7f6250ca0daaa9040544dda7ea79aaaf8b9aae9579dd570012736a1888a659853ab9c0a78ba2a17ce50a5def3677a6aab188aaba4a702b02a16d0e39e2e146a5bcaac28eaac80c7268f71016cf3a22040ff8ddd23017c53a2d8aaa350c8ada80159a990010fca66b48a9de7daa4da9a74ea5a1b7f5500c528451260aacb39af6c5aaf258725969a1adecaa0112000e29a9ef1ca9800dba6f6aa9be3c1aee4f8ae2615ac97f9b002fb6e86da2085f0571cb0aff1a3ac7929b2b7ea7f1debb186a3012e2a00c8da3dd66a9604daa8e997592a9b081d201f1930b3f143365cc9b3275b7b367bb38a70012012b2a0d6b0ea08b4cd2ab4124bb48940092eda922f14691bc9b4d94a7a430bb58ed001a13a1c588b9f4acb88614baf9247a35cbb32201201745ab520e0af9b58b6010b78689bb6a020b5fcf9b2dd43b27c28b7107b2b466ab7b5f0b50540add50a9bdae6b71b0bff6c582ab8afe0ad1e1aae3fe4b34ba8b837b7a18e3b0b149b017a8b65d1d582961b71989bb9850422fafa43569b7fa1fb6ea34bbac100b9aa90b00b8b3c1b30b63fb6bacfd6baae3b0c9b6bb126f5b68ee74210fba5bb5b0cf96ab2367976d725bcb84abcc52b0d01c0b2abe0b2a086b119c6bcb90ba9cf5b0e9b2bb795c3b7e385bdb0e6bcdb3b0e46bb0a480b6a9f1bbea7e9a9e53b2b0992b7f554aebe25be14a2bdef8b10390b3dde0b430deb42e71424f89bbf0971beb1dbb66eebaf2f3489c639c0048c1178ab0a54fb43340699782382c5fac02f3100846bb8d2991519acc13f61c00d2ab958d9c0e329c262b1b99d1b452311c22a6c26a68bbc40045511d11ac36201bb0daab0c974af38fc18bd7b4be58a9c3fec18c75bb5435cc4d211bd084bbdde430149acc4f6d1bdaf4301cab3b5520c1c24ec0c0540bfaa60a659bcc4f13b755e15c61e8b201a90c61dd0abf91b08003b)
  610.  
  611. -- Populate Contacts
  612. SET IDENTITY_INSERT [dbo].[Contacts] ON
  613. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (1, N'Christopher Martin', N'01446 175923', N'07634 717173', N'17 High Street', N'Darlington', N'Cheshire', '20070914 16:09:21.383', N'Christopher.Martin@example.com')
  614. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (2, N'Joseph Bennett', N'01147 771824', N'07956 758471', N'37 Green Lane', N'Portsmouth', N'County Durham', '20070914 16:09:21.400', N'Joseph.Bennett@example.com')
  615. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (3, N'Joshua Scott', N'01940 919059', N'07331 757163', N'33 George Street', N'Llandudno', N'County Durham', '20070914 16:09:21.400', N'Joshua.Scott@example.com')
  616. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (4, N'Daniel Powell', N'01659 216066', N'07272 134093', N'93 North Street', N'Newport', N'Cheshire', '20070914 16:09:21.417', N'Daniel.Powell@example.com')
  617. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (5, N'Jennifer Washington', N'01502 976179', N'07225 483640', N'43 The Grove', N'Hull', N'Berkshire', '20070914 16:09:21.430', N'Jennifer.Washington@example.com')
  618. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (6, N'Anthony Lee', N'01200 660059', N'07696 849723', N'97 Stanley Road', N'Newport', N'Berkshire', '20070914 16:09:21.430', N'Anthony.Lee@example.com')
  619. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (7, N'Rebecca Foster', N'01340 503829', N'07960 669272', N'79 Springfield Road', N'Salisbury', N'Licolnshire', '20070914 16:09:21.447', N'Rebecca.Foster@example.com')
  620. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (8, N'Ava Walker', N'01978 657197', N'07610 445571', N'29 North Street', N'Southall', N'Oxfordshire', '20070914 16:09:21.463', N'Ava.Walker@example.com')
  621. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (9, N'Matthew Ward', N'01324 940147', N'07903 833764', N'71 Kingsway', N'London EC', N'Staffordshire', '20070914 16:09:21.477', N'Matthew.Ward@example.com')
  622. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (10, N'Matthew Mitchell', N'01661 433253', N'07822 453924', N'70 Cowley Street', N'Worcester', N'Rutland', '20070914 16:09:21.477', N'Matthew.Mitchell@example.com')
  623. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (11, N'Megan Stewart', N'01653 610021', N'07363 920914', N'59 Broadway', N'Chelmsford', N'Berkshire', '20070914 16:09:21.493', N'Megan.Stewart@example.com')
  624. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (12, N'Mia Robinson', N'01594 360107', N'07295 889232', N'22 The Avenue', N'Wigan', N'Norfolk', '20070914 16:09:21.510', N'Mia.Robinson@example.com')
  625. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (13, N'Cameron Davis', N'01594 360107', N'07295 889232', N'35 Windsor Road', N'Watford', N'Rutland', '20070914 16:09:21.523', N'Cameron.Davis@example.com')
  626. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (14, N'Emma Howard', N'01788 915553', N'07736 274237', N'43 Park Avenue', N'Wigan', N'Derbyshire', '20070914 16:09:21.540', N'Emma.Howard@example.com')
  627. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (15, N'Liam Taylor', N'01286 103534', N'07939 391131', N'47 York Road', N'Harrow', N'Shropshire', '20070914 16:09:21.540', N'Liam.Taylor@example.com')
  628. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (16, N'Ross Ramirez', N'01945 464335', N'07126 593543', N'33 Kingsway', N'London WC', N'Herefordshire', '20070914 16:09:21.557', N'Ross.Ramirez@example.com')
  629. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (17, N'Sarah Lewis', N'01287 924924', N'07149 593067', N'91 George Street', N'Bristol', N'Cumberland', '20070914 16:09:21.570', N'Sarah.Lewis@example.com')
  630. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (18, N'Emma Taylor', N'01287 924924', N'07149 593067', N'92 Queen Street', N'Dundee', N'Kent', '20070914 16:09:21.587', N'Emma.Taylor@example.com')
  631. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (19, N'Anthony Rivera', N'01788 915553', N'07736 274237', N'97 Church Road', N'Southampton', N'Huntingdonshire', '20070914 16:09:21.587', N'Anthony.Rivera@example.com')
  632. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (20, N'Ellie King', N'01945 464335', N'07126 593543', N'29 George Street', N'Lincoln', N'Lancashire', '20070914 16:09:21.603', N'Ellie.King@example.com')
  633. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (21, N'Megan Barnes', N'01469 486350', N'07759 520189', N'92 West Street', N'York', N'Surrey', '20070914 16:09:21.620', N'Megan.Barnes@example.com')
  634. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (22, N'Scott Watson', N'01630 240971', N'07886 967048', N'91 Mill Road', N'Chester', N'Norfolk', '20070914 16:09:21.633', N'Scott.Watson@example.com')
  635. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (23, N'Emily Anderson', N'01487 403649', N'07449 889487', N'100 George Street', N'Dorchester', N'Hertfordshire', '20070914 16:09:21.633', N'Emily.Anderson@example.com')
  636. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (24, N'Nicole Martin', N'01721 599988', N'07525 825680', N'62 Kingsway', N'Colchester', N'Hertfordshire', '20070914 16:09:21.650', N'Nicole.Martin@example.com')
  637. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (25, N'David Perry', N'01212 359994', N'07270 368607', N'59 Queen Street', N'London North', N'Cheshire', '20070914 16:09:21.667', N'David.Perry@example.com')
  638. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (26, N'Abbie Rogers', N'01120 243659', N'07237 275885', N'62 Manchester Road', N'Kirkcaldy', N'Cornwall', '20070914 16:09:21.680', N'Abbie.Rogers@example.com')
  639. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (27, N'Liam Kelly', N'01140 882420', N'07354 721715', N'88 St. John''s Road', N'Manchester', N'Northamptonshire', '20070914 16:09:21.680', N'Liam.Kelly@example.com')
  640. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (28, N'Christopher Walker', N'01889 655242', N'07332 289915', N'73 North Street', N'Paisley', N'Yorkshire', '20070914 16:09:21.697', N'Christopher.Walker@example.com')
  641. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (29, N'Matthew Collins', N'01305 665775', N'07352 869339', N'60 York Road', N'Outer Hebrides', N'Staffordshire', '20070914 16:09:21.713', N'Matthew.Collins@example.com')
  642. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (30, N'Elidh Peterson', N'01183 454781', N'07295 215265', N'59 Albert Road', N'Norwich', N'Cheshire', '20070914 16:09:21.727', N'Elidh.Peterson@example.com')
  643. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (31, N'Jamie Price', N'01624 725814', N'07773 220491', N'40 Manor Road', N'Kingston upon Thames', N'Rutland', '20070914 16:09:21.743', N'Jamie.Price@example.com')
  644. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (32, N'Katie Sanchez', N'01192 635557', N'07695 694205', N'50 New Street', N'Hemel Hempstead', N'Cornwall', '20070914 16:09:21.743', N'Katie.Sanchez@example.com')
  645. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (33, N'Erin Rodriguez', N'01701 154719', N'07699 485122', N'8 York Road', N'Swindon', N'Derbyshire', '20070914 16:09:21.760', N'Erin.Rodriguez@example.com')
  646. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (34, N'Abbie Brooks', N'01287 924924', N'07149 593067', N'73 Springfield Road', N'Ipswich', N'County Durham', '20070914 16:09:21.773', N'Abbie.Brooks@example.com')
  647. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (35, N'Lauren Simmons', N'01442 337633', N'07986 644216', N'98 London Road', N'London E', N'Cheshire', '20070914 16:09:21.790', N'Lauren.Simmons@example.com')
  648. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (36, N'Emily Bennett', N'01907 200803', N'07636 884168', N'90 West Street', N'Salisbury', N'Herefordshire', '20070914 16:09:21.790', N'Emily.Bennett@example.com')
  649. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (37, N'Christopher Flores', N'01198 529461', N'07207 549127', N'74 Queens Road', N'Crewe', N'Cheshire', '20070914 16:09:21.807', N'Christopher.Flores@example.com')
  650. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (38, N'Alexander Rivera', N'01120 243659', N'07237 275885', N'25 Grange Road', N'Dudley', N'Huntingdonshire', '20070914 16:09:21.820', N'Alexander.Rivera@example.com')
  651. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (39, N'Rachel Williams', N'01512 965727', N'07889 215998', N'62 Victoria Road', N'Dundee', N'Hampshire', '20070914 16:09:21.837', N'Rachel.Williams@example.com')
  652. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (40, N'Olvia Howard', N'01547 693549', N'07341 808038', N'17 Kings Road', N'Guildford', N'Warwickshire', '20070914 16:09:21.837', N'Olvia.Howard@example.com')
  653. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (41, N'Elizabeth Flores', N'01231 471798', N'07493 384582', N'64 The Green', N'Bournemouth', N'Staffordshire', '20070914 16:09:21.853', N'Elizabeth.Flores@example.com')
  654. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (42, N'Kyle Griffin', N'01558 179557', N'07522 904690', N'21 Manchester Road', N'Kirkcaldy', N'Hampshire', '20070914 16:09:21.870', N'Kyle.Griffin@example.com')
  655. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (43, N'Laura Evan', N'01495 153619', N'07390 958114', N'68 Station Road', N'St Albans', N'Berkshire', '20070914 16:09:21.883', N'Laura.Evan@example.com')
  656. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (44, N'Katie Martinez', N'01285 948244', N'07424 397578', N'98 Windsor Road', N'Maidstone', N'Kent', '20070914 16:09:21.883', N'Katie.Martinez@example.com')
  657. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (45, N'Sophie Griffin', N'01965 513379', N'07605 294144', N'10 The Green', N'Sheffield', N'Surrey', '20070914 16:09:21.900', N'Sophie.Griffin@example.com')
  658. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (46, N'Elidh Wood', N'01198 529461', N'07207 549127', N'88 North Road', N'Northampton', N'Essex', '20070914 16:09:21.917', N'Elidh.Wood@example.com')
  659. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (47, N'Abigail Hill', N'01555 443077', N'07439 738948', N'86 The Drive', N'Sunderland', N'Hampshire', '20070914 16:09:21.930', N'Abigail.Hill@example.com')
  660. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (48, N'Scott Bell', N'01469 486350', N'07759 520189', N'25 Park Avenue', N'Harrogate', N'Surrey', '20070914 16:09:21.930', N'Scott.Bell@example.com')
  661. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (49, N'Chloe Martin', N'01329 343662', N'07783 161081', N'33 New Street', N'Telford', N'Dorset', '20070914 16:09:21.947', N'Chloe.Martin@example.com')
  662. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (50, N'Lauren Bryant', N'01752 908316', N'07676 584363', N'70 School Lane', N'Swindon', N'Middlesex', '20070914 16:09:21.963', N'Lauren.Bryant@example.com')
  663. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (51, N'Lucy Rivera', N'01287 924924', N'07149 593067', N'31 The Grove', N'Rochester', N'Cumberland', '20070914 16:09:21.977', N'Lucy.Rivera@example.com')
  664. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (52, N'Chloe Davis', N'01346 526218', N'07291 685237', N'99 The Crescent', N'Coventry', N'Shropshire', '20070914 16:09:21.977', N'Chloe.Davis@example.com')
  665. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (53, N'Joseph Thompson', N'01237 661433', N'07302 871821', N'75 Grove road', N'Truro', N'Northumberland', '20070914 16:09:21.993', N'Joseph.Thompson@example.com')
  666. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (54, N'William Wright', N'01417 502667', N'07177 363555', N'57 Station Road', N'Romford', N'Middlesex', '20070914 16:09:22.010', N'William.Wright@example.com')
  667. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (55, N'William Hughes', N'01407 629329', N'07309 884547', N'34 High Street', N'Torquay', N'Dorset', '20070914 16:09:22.023', N'William.Hughes@example.com')
  668. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (56, N'Samantha Miller', N'01333 824728', N'07634 606994', N'60 Park Lane', N'Cardiff', N'Surrey', '20070914 16:09:22.040', N'Samantha.Miller@example.com')
  669. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (57, N'William Ramirez', N'01626 530682', N'07768 951632', N'95 Grange Road', N'Cardiff', N'Berkshire', '20070914 16:09:22.040', N'William.Ramirez@example.com')
  670. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (58, N'Lauren Green', N'01811 269842', N'07316 264705', N'28 Main Street', N'Huddersfield', N'Somerset', '20070914 16:09:22.057', N'Lauren.Green@example.com')
  671. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (59, N'Jordan Henderson', N'01624 725814', N'07773 220491', N'67 The Drive', N'Tonbridge', N'Surrey', '20070914 16:09:22.070', N'Jordan.Henderson@example.com')
  672. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (60, N'Michael Richardson', N'01346 526218', N'07291 685237', N'76 Highfield Road', N'Kilmarnock', N'County Durham', '20070914 16:09:22.087', N'Michael.Richardson@example.com')
  673. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (61, N'Caitlin Washington', N'01291 914147', N'07913 286110', N'55 School Lane', N'Peterborough', N'Licolnshire', '20070914 16:09:22.103', N'Caitlin.Washington@example.com')
  674. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (62, N'Anna Long', N'01131 669331', N'07113 804523', N'41 The Avenue', N'Stevenage', N'Cornwall', '20070914 16:09:22.103', N'Anna.Long@example.com')
  675. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (63, N'Ethan Parker', N'01940 919059', N'07331 757163', N'76 York Road', N'Blackpool', N'Middlesex', '20070914 16:09:22.120', N'Ethan.Parker@example.com')
  676. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (64, N'Lauren Ramirez', N'01417 502667', N'07177 363555', N'74 Albert Road', N'Crewe', N'Kent', '20070914 16:09:22.133', N'Lauren.Ramirez@example.com')
  677. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (65, N'Joshua Price', N'01404 421474', N'07720 314778', N'24 The Green', N'Southend on Sea', N'Yorkshire', '20070914 16:09:22.150', N'Joshua.Price@example.com')
  678. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (66, N'Kyle Botton', N'01291 914147', N'07913 286110', N'25 Kingsway', N'Aberdeen', N'Lancashire', '20070914 16:09:22.150', N'Kyle.Hall@example.com')
  679. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (67, N'Bethany Hughes', N'01210 611735', N'07709 761071', N'6 New Street', N'Stevenage', N'Buckinghamshire', '20070914 16:09:22.167', N'Bethany.Hughes@example.com')
  680. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (68, N'Kyle Smith', N'01555 443077', N'07439 738948', N'90 Main Street', N'Cardiff', N'Buckinghamshire', '20070914 16:09:22.180', N'Kyle.Smith@example.com')
  681. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (69, N'Caitlin Griffin', N'01469 486350', N'07759 520189', N'100 Mill Road', N'Oxford', N'Sussex', '20070914 16:09:22.197', N'Caitlin.Griffin@example.com')
  682. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (70, N'Jamie Perez', N'01572 459202', N'07858 711874', N'86 Queens Road', N'Nottingham', N'Staffordshire', '20070914 16:09:22.213', N'Jamie.Perez@example.com')
  683. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (71, N'Jennifer Turner', N'01192 635557', N'07695 694205', N'46 London Road', N'Brighton', N'Derbyshire', '20070914 16:09:22.213', N'Jennifer.Turner@example.com')
  684. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (72, N'Alexander Barnes', N'01281 554917', N'07800 642581', N'78 North Street', N'London W', N'Lancashire', '20070914 16:09:22.227', N'Alexander.Barnes@example.com')
  685. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (73, N'Megan Campbell', N'01205 396727', N'07198 312473', N'20 Park Avenue', N'Blackburn', N'Suffolk', '20070914 16:09:22.243', N'Megan.Campbell@example.com')
  686. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (74, N'Lewis Collins', N'01237 661433', N'07302 871821', N'10 Victoria Road', N'Southall', N'Norfolk', '20070914 16:09:22.260', N'Lewis.Collins@example.com')
  687. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (75, N'Bethany Peterson', N'01784 976829', N'07885 861269', N'43 The Crescent', N'Worcester', N'Surrey', '20070914 16:09:22.260', N'Bethany.Peterson@example.com')
  688. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (76, N'Erin Martin', N'01428 428418', N'07377 251946', N'39 The Avenue', N'Milton Keynes', N'Suffolk', '20070914 16:09:22.273', N'Erin.Martin@example.com')
  689. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (77, N'Joseph Coleman', N'01788 915553', N'07736 274237', N'95 Park Avenue', N'Wolverhampton', N'Leicestershire', '20070914 16:09:22.290', N'Joseph.Coleman@example.com')
  690. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (78, N'Jordan Scott', N'01500 424473', N'07824 778422', N'12 Stanley Road', N'Galashiels', N'Cambridgeshire', '20070914 16:09:22.307', N'Jordan.Scott@example.com')
  691. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (79, N'Kieran Kelly', N'01633 392324', N'07960 870808', N'91 London Road', N'Twickenham', N'Northumberland', '20070914 16:09:22.320', N'Kieran.Kelly@example.com')
  692. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (80, N'Tony Brown', N'01231 471798', N'07493 384582', N'41 Queensway', N'Falkirk', N'Berkshire', '20070914 16:09:22.337', N'Anthony.Brown@example.com')
  693. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (81, N'Joshua Sanders', N'01902 365096', N'07414 740869', N'12 Albert Road', N'Dundee', N'Hampshire', '20070914 16:09:22.353', N'Joshua.Sanders@example.com')
  694. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (82, N'Bethany Rivera', N'01784 976829', N'07885 861269', N'54 Church Street', N'London E', N'Northumberland', '20070914 16:09:22.353', N'Bethany.Rivera@example.com')
  695. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (83, N'Laura Hayes', N'01982 956405', N'07109 544766', N'56 Station Road', N'Brighton', N'Devon', '20070914 16:09:22.370', N'Laura.Hayes@example.com')
  696. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (84, N'Anna Griffin', N'01345 471798', N'07493 384582', N'40 Windsor Road', N'Guildford', N'Cornwall', '20070914 16:09:22.383', N'Anna.Griffin@example.com')
  697. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (85, N'Samantha Jackson', N'01231 471798', N'07493 384582', N'14 New Street', N'Llandudno', N'County Durham', '20070914 16:09:22.400', N'Samantha.Jackson@example.com')
  698. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (86, N'Kyle Sanchez', N'01978 657197', N'07610 445571', N'3 Windsor Road', N'Bromley', N'Oxfordshire', '20070914 16:09:22.400', N'Kyle.Sanchez@example.com')
  699. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (87, N'Shannon King', N'01624 725814', N'07773 220491', N'56 King Street', N'Paisley', N'Gloucestershire', '20070914 16:09:22.417', N'Shannon.King@example.com')
  700. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (88, N'Joseph Gray', N'01211 864653', N'07375 760438', N'56 South Street', N'London E', N'Gloucestershire', '20070914 16:09:22.430', N'Joseph.Gray@example.com')
  701. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (89, N'Courtney Perry', N'01210 611735', N'07709 761071', N'13 St. John''s Road', N'York', N'Berkshire', '20070914 16:09:22.447', N'Courtney.Perry@example.com')
  702. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (90, N'Matthew Campbell', N'01743 360803', N'07394 612512', N'68 Queen Street', N'Romford', N'Essex', '20070914 16:09:22.463', N'Matthew.Campbell@example.com')
  703. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (91, N'Alexis Cook', N'01624 725814', N'07773 220491', N'36 Queen Street', N'Falkirk', N'Norfolk', '20070914 16:09:22.463', N'Alexis.Cook@example.com')
  704. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (92, N'Jamie Mitchell', N'01776 202627', N'07185 505540', N'90 High Street', N'Kingston upon Thames', N'Warwickshire', '20070914 16:09:22.477', N'Jamie.Mitchell@example.com')
  705. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (93, N'Chloe Morris', N'01725 222331', N'07526 574605', N'97 Main Street', N'Bradford', N'Cambridgeshire', '20070914 16:09:22.493', N'Chloe.Morris@example.com')
  706. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (94, N'Lauren Morris', N'01914 784723', N'07798 945002', N'44 Church Street', N'Durham', N'Warwickshire', '20070914 16:09:22.510', N'Lauren.Morris@example.com')
  707. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (95, N'Olvia Barnes', N'01811 269842', N'07316 264705', N'78 Stanley Road', N'Lincoln', N'Herefordshire', '20070914 16:09:22.510', N'Olvia.Barnes@example.com')
  708. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (96, N'Olvia Hall', N'01571 657822', N'07694 711784', N'14 Windsor Road', N'Coventry', N'Middlesex', '20070914 16:09:22.523', N'Olvia.Hall@example.com')
  709. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (97, N'Scott Turner', N'01555 443077', N'07439 738948', N'87 Station Road', N'Salisbury', N'Surrey', '20070914 16:09:22.540', N'Scott.Turner@example.com')
  710. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (98, N'Rebecca Hayes', N'01802 342584', N'07296 315860', N'94 George Street', N'Bournemouth', N'Somerset', '20070914 16:09:22.557', N'Rebecca.Hayes@example.com')
  711. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (99, N'Kyle Perry', N'01653 610021', N'07363 920914', N'82 The Grove', N'Derby', N'Gloucestershire', '20070914 16:09:22.570', N'Kyle.Perry@example.com')
  712. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (100, N'Kieran Patterson', N'01389 465402', N'07266 836025', N'3 St. John''s Road', N'Bolton', N'County Durham', '20070914 16:09:22.570', N'Kieran.Patterson@example.com')
  713. SET IDENTITY_INSERT [dbo].[Contacts] OFF
  714.  
  715. -- Populate WidgetPurchases with lots of data
  716. DECLARE @purchaseCount int
  717. SET @purchaseCount = 0
  718. SET NOCOUNT ON
  719. DECLARE @temp float
  720. SET @temp = RAND(1)
  721. WHILE (@purchaseCount < 108435) BEGIN
  722. 	INSERT INTO [dbo].[WidgetPurchases] ([WidgetPriceID], [Quantity], [InvoiceNumber], [Date]) VALUES (
  723. 		CONVERT (int, RAND() * 3) + 1, -- WidgetPriceID
  724. 		CONVERT (int, RAND() * 100) + 1, -- Quantity 
  725. 		'WIDG' + convert (nvarchar(10), convert (int, RAND() * 10000) + 1), -- InvoiceNumber
  726. 		CONVERT (datetime, -- Date
  727. 			CONVERT (nvarchar (50), 
  728. 				'2007-' + 
  729. 				CONVERT (nvarchar (2), CONVERT (int, RAND() * 11) + 1) + '-' + 
  730. 				CONVERT (nvarchar (2), CONVERT (int, RAND () * 27) + 1)
  731. 			)
  732. 		)
  733. 	)
  734. 	SET @purchaseCount = @purchaseCount + 1
  735. END
  736. SET NOCOUNT OFF
  737. COMMIT TRANSACTION
  738.  
  739. -- **************************************** Insert data ****************************************
  740.  
  741. USE WidgetTest
  742. GO
  743.  
  744. BEGIN TRANSACTION
  745. SET IDENTITY_INSERT [dbo].[Widgets] ON
  746. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (1, 'Red widget', 'RW')
  747. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (2, 'Extended widget2', 'EW')
  748. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (3, 'Dark widget', 'DW')
  749. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (4, 'Grow-your-own widget', 'GW')
  750. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (5, 'Widget access kit', 'AW')
  751. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (6, 'Test kit', 'TK')
  752. INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (7, 'Exploded widget diagram', 'ED')
  753. SET IDENTITY_INSERT [dbo].[Widgets] OFF
  754. INSERT INTO [dbo].[WidgetReferences] ([WidgetID], [Reference]) VALUES (1, 'Widget 1')
  755. INSERT INTO [dbo].[WidgetReferences] ([WidgetID], [Reference]) VALUES (2, 'Widget 2')
  756. SET IDENTITY_INSERT [dbo].[WidgetPrices] ON
  757. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [DateValidFrom], [DateValidTo], [Active]) VALUES (1, 1, 100, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  758. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [DateValidFrom], [DateValidTo], [Active]) VALUES (2, 2, 50, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  759. INSERT INTO [dbo].[WidgetPrices] ([RecordID], [WidgetID], [Price], [DateValidFrom], [DateValidTo], [Active]) VALUES (3, 3, 25, '2000-01-01 00:00:00.000', '2002-01-01 00:00:00.000', 'Y')
  760. SET IDENTITY_INSERT [dbo].[WidgetPrices] OFF
  761. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (1, N'A widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  762.   <descriptiveText>A widget</descriptiveText>
  763.   <manufacturer>Acme Incorporated</manufacturer>
  764.   <countryOfOrigin>United Kingdom</countryOfOrigin>
  765.   <size length="12" width="4" height="7" />
  766. </description>', 0x474946383961db00d800e64300000000698495465863cccccc010f1b003366000b14333333666666999999ffffff032d51808080021e3600333334424aafafaf01162884a5bae0e0e07b9aae586e7c1116186699991a21252020201f1f1f4f4f4fb0b0b0dfdfdf4f636f7f7f7f6079883d4d57505050021a2f00003303294ac6d8e399cccc84a9c1b7cedc739bb61e517de9f0f494b5cad4e1ea336699e2ebf15a85a5517d9f7b878d365165144876b0c9d8333366afb3b613395a0916204d5d678fa3af2d4252bed3df7f8386d0dae3cddce68db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000043002c00000000db00d8000007ff804382838485868788898a8b8c8d8e8f430907080390969798999a9b9c9d9e890900a20019081c9fa8a9aaabacad8708a21a1aa3a222090aaeb9babbbcabb000070a0a031f07b4c00913bdcbcccdce0a22a21bc2d40a1d091bc7a595cedddedf9a0ac60008d5e6c209bfb4a6b8e0eeeff0e2a2e5e7f5c308b3b4b6caf0fdfebb0346ddb2477098a463071870fbc7b0e1a680a206169c782d1bad52a71c6adca888c3280813439a83a06e14825b1c536e0c256a80c897e606e043984ca54d782c01b884c9b3dab571a3262dbc49b4d7af603d939ec3a6cd54d1a7ae8e2a9d5a8f643e5107a06afd248f1cd5aff5208ada4a36dc387a60d30a030aa0ac5b4813ffceaa552b76c482b66ff32a122b712ed59c0e0adcd54bd8105fbf60d515583c3891020efc0a13cdb913f1548b061633c67b48ec819a925352b64c751c09cd9b1189a5f53972e87f0cb05626cdb32eead4863cb62449d3f56b7052692785302af0ed020e380f1a4d8d376bd0bfbb0517ce33e782e3c8c915627ece7950e8d17775454bfda562ecc913149a5ed03b56f0e1578d2fcff35766ec1100a827c45ea47b64bec5d7c9001988f2017d308d13017605e4b79f200afc32cd54ffb526e08002212852070a32e82021f3a555217c173a729886138965dc711f0e12a25f2306582222dca1688f8a0c92a01321038cd3976531ce08ca28b3d9b8d4280c1660c0ff8e839c485f90420e72540746129453924b0ee5248a5096d85f95d55cc9609684d4586585198517215660dac3d27dd81970c05066b6a9807bf1bd6827356f26094c3b82b0a441917bf23956747a16da27837ff2c766a1f6e070682f1c5808508690a2230a9cc7352ae5a3999a03440e93eab2e677327eb2a5a29bfa198ca37f865acd003fd4709772aef4184b6faae8060048a142c4e96d5eb92897acd40494d9adbbe4444f979bd469670748a2a79db1f3209b2c00f731eb0a341f755712809a486be7380c26870088c76aabac66deb24220a8f640dbc897ac02b0226aeaf258a07eda0af32ebca5a6129b8130d98b08be851a4380b5eb3689a9bbdcde162fff2a71c542a87fe35a6a48a2a18a52c271e9f13831b203a376b127be4ef815b420870cc075a8b52888581b439ab2ca0573a2ce8f60c598b157010b234a0335eb57269145efcc33ae9ae80a4cce228e7b72c0bf186773244c07ecf4d39e38aba17b40070c948e0f72a00ed57b7e0df626e08a02ac8d107cc036b2161dc3dadd6dbafd7626f3024365d1eee6fd1ce17eff7d494e0712eef80090433e78d315274930d48e98ebf8e65e576ef9669837121b527c736e7adf9e7f2e58cf8e8cde020ff3cc7dfaec76268eddca8f8c2e841012547056e9b4073f97edb7b32e3a30bb274f81071800a00125c2474f1bf1c587ce88eec9674f410816389fc0e4d2873f15fff5d567827df6e85fc03d32e08bef7e8aa9abae3824e7a36f3f080f4853f6fbfc0f13bffc97cb044bec47c0ece14f1ab2eb9ffbc89724dc994814058ce0ee7a7796042a30780c6ca0f1180111097a907715681e398077c160fd0f80f37b44073ff8c1e535ef7925345d062de7c046ac90852cbc40f3f617c34ccd90861b5cc40d71e8c10a10ad879d1b160acb87892112b180f9e32112db76c2255a2c887b81e0132318c52926d18aaaab2107b5b845fb75d18b28ab221853f8400094117d12681e09d188a01f02508c4224e31be3a8133acaca8e77c462229cf8440a6060507e34a112d7c8203c66d18d6fbc40ac12a9333532f28ad6cb2324b72849a450b2ff50805ca22307a9471c0660929fac9d252f8949c095f28346244f2ac1144a2b8e5235af94602c6749c545b25283997c24113d0080c6f19296abfc652b9b984b029ef19855aae51a6fd99966a2ef99d0b49134a729485c02e002129480312c984dfa6c939bc15484280210413eceb19c6939273a35b1ce02ba139eda4ca6321bd94d44d4d37e3a9c133e51244f4652f310ffcc5e27076aa30f706b5ffb44e1410d91d0dd2d94a174fb0509201a5120a633111505c111316a24e79060641df5283d01c0cedded92a47b620a002280d2942e1313ff7c294c217510008cc0a66c74443d4300b09dcaea27a2f8a94d275a887562d3a87f9c8901387a49a612421433ff282a5411679f9a56b59f8669c956677710655a7508be6a1fa43a50b70f24e09dbc7401ef00803456e6e7a3dbe95ab00c370a63c254aebb130000ec3a0f4b080aaed4c989dee406d314644f0274656472aef50886d949b18b652c431d8b3ec1ae71b2afaa2cbd3285d9cc8a82a127202064a9fa39363d22663135ed62a548c9d44271b04b24d26bdb152a87ca566f7ee5250b5a20410ae80b854b62522386264b4859edb75ae55c2836405b9ec080b81ecc1f0093fba03146445bcffdad2739e7d008fc0e2c806de1713f77d7ee6a32ba990aef6f67078bc0484002cc73de07d42a92203c51bb96bb6bc41aa1b936f115ba62355d7d0b400001244f7dddfb0cff4f384b44e3b2363b94654481c1c41604279873c6d04c83ef973f7290d31c3678238049e65a026b4c5b1df63062ab1462113b58b5be731ef4ea61db325a183b2d668465cfe5e163cc589b0718d6888b2b8008f785053d56316e51a3db7b8db69245a6c59109fabf257ff00225a6ee70dfa8bdf52e26b943710c6f7d98652dcbf0845ec6618e01400132676fc5dc6d046c55d9e60f3b2e140bc24e9c8928010b3cc0ceca9b59832262c3710497a77df633e1009da44113d1887546b4100e4000013bc247da2aad8c151cd94adff88d86d6b4102ed0bd0c2fc218cdcd579fb7aca1055bced24414293811ad021d78aa11c6d8010c6425dfdfd21a41b6bef5a9dfff788003f09ac1006000248ce16013c437d27d04f1943f876b229eb2a5658cc1620810ed6903e0c62770c19e8a2ddb63d3a7c6f2eb36119bfd461988b8dc8fa076f64e606d1a63dbddd41980067cc920799b92a55b7c016ac82ded7c9fdb7ea7dcc0892d13e3516fee8706c721bd718802852f1cdf9f7e38fa4e190b04f0772e154730c0851390875931e32cfc360b51b082e330dcdccbde1dc90f8798d5b479e5b4a1341861cec28d4b500535b739c8812df2eced5c6f3b068bcfb30c74d2087de83927b3244170f44a2f9d11fa1eb978ab5b90a917b9ea964936d655bdbb0758208217b8f5d75fddf4e43d5db60898b895b09d6dc7a97ded6c376e0508286effb9373ce459bffb6f35b0df9788dae28ecbc6850148741cbadd7e1e373cce211e690917c4b791d67ba6e0cdcacab350f0d9cbbce61d9e78be8fb01eec962dd9f744fad2671dd1971702cd293f774584dde9ae7f4f35626fdad9a38ee080f72005022001f55660f7bc3f3cd35b1f7c934020e508363e32919ffc0282a0d5c0c874040fd08397f73e11bfb77bf5d70f5f6d11e734293578fe025d8225edba8007a82b0a6fce7aceb3dff5da572557d751f2664410a523cd877ffa177d9b2776ff876d016824034880b737574a452c87a680e6277d6057773af78091168136f277145840c4942e74a6814bc47f88e77f20586422882224588204840117d8291ea0ff82fb777e88907e1ff8821ee63245630c5e0554b8065934831fce4640f9b7810d087c40586451272bb507540c767ba76439c9a1830cd87f0e188545a601df93291cb26d56386eb7674440c485f1c68387e08342a078608860d4d54b676873b727002ec74f6ca83a2c387d2e38877d36851a5250f196866678457dc86d6e680870288782188663882013788768484059982425b049e8d3842bd88885f08891587d75985833658982767bc6653923b084f6e3893bc88174477da3587d84a816a17083a868630564010b482c21b088abd7825f588bd5278627971433b88bdd4654fc747f9df88b7e088a84208ac6f880a54815cbc88c15f86336e78aaf288d8c28ff8bbee78171788d40788b22610c49b88b7818419e751bf9018dd1e8845e0885e8f882c8982089e88e0b57816d67663a3278e3278ec30888c5988f2f286613010bfea86c1e2458a360015c2741b0d885c4888f0a1985ec740227e00326109229e09142a0870f696a1f2401015001e0669106e975e4887ee608891bc97e2d4940267992a9c876d973916d18933d389335098637693f39a993b7617a1af79205478d83608d43f98245d9597b8894bcc893bbe393d308946f28945129951159955679855899954c29684e290850f995ff478f46299656a9944577964ac7958ee8956cf97f1f749463499665a995e3f884ea97977a19967d79955809984932597619ff8a784998d5b79770899472f9418a692dbf86901a0999ae074bfda89395e941978949a1758f83c999c1f741997898a1e99200340aa9528eb4889a7ca79a9f7992ad5990f2536596b096b41969b6799897f89774c99bbdf998bfd967c1299cb9298c9a81669ae09bc99965cb79980b207e3c399a79169dc8399d45569d8759966689258cb609d2e99d08069e56991c0f5091d969903aa2349c709ee8f95beaa99393350aedc97680e9699d409ff599596fe741ab899477d56cc7f0006ef9445ae99fffd99d016a5ae05840057a92078a0b13c000ff220a1610020b6a99bf380285f509001aa108719fee78a18520131b0a001dfaa15c085aa950a2261a14288aff8a2aaa1a08d0a22f3a979a015a80e209345aa3c843a0b779860e2a443b4a0b18e001d8198e8b01a4aa30a4353aa19878a44095a48ea036c7d0a44f3a9e05200a1910a4240aa144ca1a376a855a6a095ccaa44eda9348639ca840a5266aa59ce78fe4e66a9ad0a6a3800115d07c34909f6936a7667aa65891a629955c03860a1c100dac7103723aa3e6284e869a59762a76bba8a8df92008e4a0bee35a5e6b83bdb53a9276aa4a8a8a9e2c1a9e5e90a70883e2144aa452a41156a53dbb90c0a109b840a900a5562677aa9c07787b52a19e320005faa5a1e007e11aaab1f7886c12a198af500538989bc5a9fca7a8e56d8aca131012561017f7a7a4d46ad88caff480251220a90002d1a02c54a4020807d7959adb3fa4be31a2503d0a9c010adf633aabfe9ae586a45f11a2582a0adb460011e9080b0c4ae1ba9af1dd5affeea223d250a0f90ae0035ad5f89b0fb14a90bdb24257100eee941bd83ac3549b1f0da1217bb08191ab0036b4a129b8f207b49163bb287d0b000a0a0382401dfaa902b0b469b28b22eab42194b902cb4ae2a1bae5ad8b23bab080aa0a113290004ab7c12598b378b42825ab4e5c216d07a6906cb7e3e1b41efaa3a512bb50f51127e5a61290b82f6aa7e6034591930a85e8b09e5daa2c43ab3af0a8465bbac4b24a56bcba8543bb74e37b6c1a7b75b8b829979b79f00b013d9ad2c845f1eeb7a7ebbffaf3f1a6482ab0a6d4b0be8ea6d578b608b0b40221ab88fbb0af3ca1a7aab3c358b6d97ab3a39bab9ba40b81c7ab27256b98b35ba01e6b8a66b2ae64a0b0f5b6144d566aeeb21b01bbbbc2013acb1b11c1bb7968ba877250264cabbcb50b213a9ba39c4b7c790bbf238a2c80b0e302bb3337bacb205bd9ab1a6d3eb0dbe1b1459ab9a7cabbd8ba6a7dd0b0e47bba116a0b41516bad6f4ab4929bde7fb0fd50ba3ea0a14316786a83abf0ef1bda210b6b6cb895abb6dfbcbbf1a11b9a3f0b6e2891a056cc01c5129b4fbb944f49cf2ebc02a81ba00e0a74b6b6767b6aa164c14082c0a938b684ae2c11ffc148deab9642601d87ac24f81c1dcbac11c2b429fea39c25a11c2310bb10a45c3365c189d1b14c0fb8535dcc36ea1bca94bb02a995f264cc48501b396aab64cecc3cf8511514cae910339c7ebc28100003b)
  767. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (2, N'A medium-sized widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  768.   <descriptiveText>This is a medium-sized widget, ideally suited for the home and garden environment</descriptiveText>
  769.   <manufacturer>Magic Widget Company</manufacturer>
  770.   <countryOfOrigin>USA</countryOfOrigin>
  771.   <size length="15" width="12" height="2" />
  772. </description>', 0x474946383961d100ce00e64000000000ffffff465863cccccc698495333333999999666666032d51010f1bdfdfdf84a5ba4f4f4f1f1f1f7f7f7fafafaf003366111618586e7c0116287b9aae003333202020e0e0e0000b1434424a8080806699991a2125b0b0b03d4d575050504f636f607988021e36e2ebf1b7cedc84a9c194b5ca99cccc03294ae9f0f40000336b93b01e517dd4e1ea336699739bb65a85a5021a2fcddce6c6d8e3bed3df97aebc336666a2abb1617d8f11191f164a7849769a666699dbe6ed1a242c8db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000040002c00000000d100ce000007ff804082838485868788898a8b8c8d8e8f90918701061f059797071a1d01929e9fa0a1a2a3a4a3010500a9aaab0007a5afb0b1b2b3a20316a90c0ebaba0ca8a91ab4c1c2c3c4a103aa0601cacbcba9058703c5d2d3d4b106aa03ccda07bf85a7a90717d5e3e4e589d7a9d9dacbdcdd83dfabe1e6f3f4d2ed050aebcbbe1309c082b6521968074e5cbd83084dddd3b72fd50408fe00225be660d5bf84183332827780618001be44408008ec98c07515535988a6b1a54b20015b793409a0c24892e800a8d347b0e3cb9f07692663f84095cd9b097ce9f4a86c4003672c814aad96f381c79c376faa2ab0936900821da68a2d46b0eb365559476270e6755d518163ffe3cafacad6633b0c69216c6dab0f2438b9804df962c0945f5e551df932f4e52ab0e3483113f77d0ae0615ac48a0bff7dcc7991d099460f83cbecd59781cea80d55bdaa0a85680043496bd699ba7659bb685fc796cd5465a7da8fe90228c0f46ede0aaaacf26e6bf203c20b9c803f8247d8a32f15c7b12d579c32aa390d88c34a574453f23aa70eb3a7db9ef9a985791794aab2206f7ca10e1319d23c9a15f970b3ec3165d269e4e087cb0006dcb25532f601911380cbe4e45a5a13d4156066a83c538d70b031330041a97c209e6da93400a1322901901704150e77a16c2679474c4c5c11c5002b07c808183cc4e106005e79b558dd8ba43dd5583139997795ff7c161860905cf18de6d18d0024b0e25a3211295b4ac5c0b354660a1c4099330c8a459303b3599616964a6ac9578cc31808c090bc7d88e3882fe5b4db3a86e585259a6ef206172d1ceeb99d0154aa549f46e0ad675d2afc65955fa0b2dd78642c7efd17a802068c395c990709878f8090ae3829a5a455a4a13598a1da14880088580f8f6da564ea49aeca864e2c017c905caeda3c9028383a4a13195fe8448a8076c0ae938f7ea9c042538fcdae6300934e52f399626326a002965f56bbcc31ca9d176d2904192aee32617afa01a8c1ac9659a6ab98b86e84738206002999da7baf80b0e6184c3bfec2e8c001b9947b2f378042bbaf2849fe9bd9b5abd0f724ff29b44a4ca402a8a8a36e006f8922a7c21ab7c5a9a705c0fb499459961ce031a3720cc0b3daa80a712af99ce8b27eb0cafac9993b07784d62309fc8cdaa3fa7620209b8901cb447c2e258ac227a3ebd1d37435d43279f005c9434003ffcb080048c396db5b5d85e9c48a3e19ead985fea30ec552a787a6252d8782f000207003490a3db1eb5bbcabbbf19222acd80b75554cca828778ca16fa92dc9dd78574e810011f46d00e2892ff340c0d910425de7dc6559b432d750cbccd1a3505ef9eb1b789079caa4a35def01392bd866edebdc9875cbdcec1e8091ada7f2faf1788790012e1f037ef22a4a35cffb471d2b8375431fc3598bf1c877ff4308654fff2aff2b3a4fbf783e32ab733a4337be573cd8de7b3f3663e59f2d2c03f5d75e11d1c33dab757183da1efce2173f0aecad6f7f135f0014d00ab391ce7728021e001aa60f5f38875fdc23a0062920bb4f71ae73146b80033ee836b8290382ca68dc6c2e25400dba106fb1838af80447bbc49d8f7a5f5a5f5f54e1b5f7bdf08762cb9c033bf739629d6d7fcab82125f2053564602a83408cdf02f8963f10a24284245c170a9168bd0932e541b2705d14bbb78108144c81ceba87f45065c200a050664314ce4a6621c631c2ce4568541c9512582d0554a78d3ad4079588438b3ada316c1260621e1513c2cdad4b89ff0b1c630a1746281ef2072068d922e7d50e06acf1ff425ca40b05cde58e6018728ccbfbe426a1b6c72a6ea9430b54216b02684a4b467101a850e52a99f2bc1aba497d9af2488aa6168b0ba46203879c62db76f9b24ec6913791f4510124178c5410c08e653c2333898428235ee87ab3f900258961cd316e008fdb4495021cf0145ff2a67afa6ac538ca09c4446e2d9d6c6cc7019ec9932ca2ce89f304c0357f9849e1e1135521c49d9686590e7aba30950795d83adba94b6952531a0e95622e23ea323bb5c295dab0e038ab91d1ee2913a41c75550847f836c4d4a3a4c7cb264a539a2b1aae514f078169e5cea93a9ada4f9f102a0b42748a4845fad48a9aa3d9202f4a0ea216f4a8e2f368477c41c884e814a250ff45e303ac023d9599a3a4b884655617e9d1f0bc54a0953be958b7d9cdf92c2aa003fd814cd78acfe72d68a4e444ab5cd149d783963544751b4639edd9d7a3462d1ec48485351369d0c21e9462f3c95635052a56c766557000ad64652d4bd7b2e25580cb74db0376e1809972561f27a040294b3132d2a5a85ea33cad62527082b02d0f009ff5c4833a472f56c850b6b33501de54dbb552ec367134f12df980db961608b7721e4805531fb110de2af7ba3d65ae365a80bc056c0614d545ee75c7cb4fced2c07b0290ee277a850bd22577bcac88ad764920c5ef428223ee85ef782b7a3606f0514bb525607a0130dd494c1284fa1def2a51910304fa93340126a0ff77e5f9886d252e27095e6e1e65068115707076fcd5460a9eebc20127961016061c8633cc2c341e032f088800de08705b06949719238ee2ec1a71dc0bb3d8b7a6ede88f46b2acd7cdcf9b5ee1ee1813491baab51870b0fa71904b760d3515197906cc5c031cc910195c72c7e728d194811565168f596255ceca95bd17c339198abe9764f2d4c29bb83267f8ccffba460cd2b2660282cf9b70bee40fc05c083a034e3e3f0e2defb81129220fd08563e39bdf048d37398beec09d43b49417c9e815f5f9871c048004281d36beb90f08f8259da6cdbc485420604510f834103320635213002ea946eeaaefdc6a15c13ad68f8ea26a474d6a54bc6740f94df42a42ffdc5154fcdad182a635a97f80837498a405d655f6a9a6f7e26743fb92aa1500a54bc0026b1b4f06807b8bb637cbbb6e7b1bd8944eef022ef98291981b7e2738db8a13cd6c2a57e6dddfbea477c56dc715684527622441d0f6fde37e6b2ccd008777bc0130ef28c2405208b7e5096ec0e575d939c30e975845441271890b7ae051dcc165321eecb00dd893e2fa788243feaf4e97dce48296f70f5d209a019c72c08879708064ae5f9a2fac26370ff8c9014070029680e73dffb972dd49a45d833c8fce4ebad2734e71a7b300d6f7461ed095fb5ff6587de658f7b5d6717ef20878207e2fd0c1afc37ebcb15f77cb429fcdba8d2e2ea70069ed6c17742229d0bdff7a3f9beeafb33b7c6d0ca3756fbb76ee067ce0051d810c20efe2de467ce5149f608532c7f1b88aea9025bf754a0ffe7598cf3ccbc5ee78aa6be3bdcae67bb5204efac953def27883fabb358f37ce27baec4b04bdec9b45fbdacbdaf40020fcd34bce7b9783be5eb16178c3d168f3da97bebb042040c509587972dfbcf93ff0bde3fdfbfce19319e9d6bfc9f1d37adb547860fbdd13800fbefefdd5d7fdf9f8f7adf97355fdf4db3e6ce7847ec8c101f05777569274e0277ef9177b689475fea77e2d97371cf0775a5100f1230007587f3e674be1b780f9275f99a6760f787dce0776c4267619c87cf697781ef87c8d753691378224f80300407241526b28a8ff7509d8828ef78256138332687b21208287814c3988802bb8793ca86dd945445512847c16813fe0012978184d97785508703bb884da067cfaf66f50a86652580036b82213608147a88152c785eb86452a0686610881dd837eb026026868803a9884bdc786cfe77a1ad37f71687b00f06abf6687f19785bba787cec787f8e78531478781488283f86c8698862ab88111a8808cf8636e782f373221912887c8c301659817958887488889acb7891ee88794e280a1288ac753006ab22209f0769618715bc88a2de8882f028bb14882e9757827888579a88af7c78b4bd889440284c1687be74488d95180bd8788aa878c2ca88c6ce88aa4e18ccfb87e3f5000d608ff00b8978b5aa8881da88d8ce88b5e710dd8f18c79018eb7d668101003c9875ed67878e8a889ea987fcc882c70088f627881902802a27681f93877fbd88fcac88d1e129002298bf1f723226090078990c7b8860ca98c3540033330022019923d300327706b11e9695268391970091e407802969060b7901ba98c46e83d26799251386dc6988a1a39939ba84137899312a9931898911cc88f3e997f40498438098e9754943c799449c98a4b299403a993d568949938953f49404169954e794850a98652c9957c58955639834f0993b7828d4a68966c889669199676349697d89370d98272099629b9964848607899970bb89742499763649789481b812998f847ff984dd99762c9963781252cb1988c097a8e799286194588f96b58422030910ad4889497c9629919919b09449d7925b4040430459aa59960a72990a9f943ab991609d09aaea9576f199bcfc701b3098fb5f942b779132dc24282f09abe897f7768934c89932b809559f96bc78908cab99ca0d79cddf39556199dd2197ef9688f147608d7899deba69dc8c39d27e91f191002d2799bfe813486509ee6a96ce8793cea2990feb10a1e5093398788f1995bbb19577b589f4c189ca1b89f07a020a9e076fe79985918a08b409f06ca62f7f93af9198cfb59990bba0a0e5a9759e81b8c40a1159a60175a39199aa0ce20391fc2a000e0762e499c55880d8d40a2250aff5f273a63cfa9a22e421e1daa0a1c0002318a9107d76423ca9b057aa31996a36193a27128a18dd001b012a4438a8a7a910e8f60a34a3a75081a84500a0952ca0a547a845812588aa0a55bca0a4cfa034e1a842d52559f10a6d02301f057949f1909689aa65bd1a50ff8a6020aa6be32a7f3c6032870a7788aa48ba8a7e37585dbb9a36eca16bc52096a6a032dd2438e005343a8a88bcaa7d6e7a7c14009811a0f9fa0537a93399aca0a8c9a9e8edaa7f6250ca0daaa9040544dda7ea79aaaf8b9aae9579dd570012736a1888a659853ab9c0a78ba2a17ce50a5def3677a6aab188aaba4a702b02a16d0e39e2e146a5bcaac28eaac80c7268f71016cf3a22040ff8ddd23017c53a2d8aaa350c8ada80159a990010fca66b48a9de7daa4da9a74ea5a1b7f5500c528451260aacb39af6c5aaf258725969a1adecaa0112000e29a9ef1ca9800dba6f6aa9be3c1aee4f8ae2615ac97f9b002fb6e86da2085f0571cb0aff1a3ac7929b2b7ea7f1debb186a3012e2a00c8da3dd66a9604daa8e997592a9b081d201f1930b3f143365cc9b3275b7b367bb38a70012012b2a0d6b0ea08b4cd2ab4124bb48940092eda922f14691bc9b4d94a7a430bb58ed001a13a1c588b9f4acb88614baf9247a35cbb32201201745ab520e0af9b58b6010b78689bb6a020b5fcf9b2dd43b27c28b7107b2b466ab7b5f0b50540add50a9bdae6b71b0bff6c582ab8afe0ad1e1aae3fe4b34ba8b837b7a18e3b0b149b017a8b65d1d582961b71989bb9850422fafa43569b7fa1fb6ea34bbac100b9aa90b00b8b3c1b30b63fb6bacfd6baae3b0c9b6bb126f5b68ee74210fba5bb5b0cf96ab2367976d725bcb84abcc52b0d01c0b2abe0b2a086b119c6bcb90ba9cf5b0e9b2bb795c3b7e385bdb0e6bcdb3b0e46bb0a480b6a9f1bbea7e9a9e53b2b0992b7f554aebe25be14a2bdef8b10390b3dde0b430deb42e71424f89bbf0971beb1dbb66eebaf2f3489c639c0048c1178ab0a54fb43340699782382c5fac02f3100846bb8d2991519acc13f61c00d2ab958d9c0e329c262b1b99d1b452311c22a6c26a68bbc40045511d11ac36201bb0daab0c974af38fc18bd7b4be58a9c3fec18c75bb5435cc4d211bd084bbdde430149acc4f6d1bdaf4301cab3b5520c1c24ec0c0540bfaa60a659bcc4f13b755e15c61e8b201a90c61dd0abf91b08003b)
  773. INSERT INTO [dbo].[WidgetDescriptions] ([WidgetID], [ShortDescription], [Description], [Picture]) VALUES (3, N'A small widget', N'<description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSchema">
  774.   <descriptiveText>This widget has been discontinued. It was last sold in 2006.</descriptiveText>
  775.   <manufacturer>Magic Widget Company</manufacturer>
  776.   <countryOfOrigin>United Kingdom</countryOfOrigin>
  777.   <size length="3" width="2" height="1" />
  778. </description>', 0x474946383961d100ce00e64000000000ffffff465863cccccc698495333333999999666666032d51010f1bdfdfdf84a5ba4f4f4f1f1f1f7f7f7fafafaf003366111618586e7c0116287b9aae003333202020e0e0e0000b1434424a8080806699991a2125b0b0b03d4d575050504f636f607988021e36e2ebf1b7cedc84a9c194b5ca99cccc03294ae9f0f40000336b93b01e517dd4e1ea336699739bb65a85a5021a2fcddce6c6d8e3bed3df97aebc336666a2abb1617d8f11191f164a7849769a666699dbe6ed1a242c8db1c7ffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021f90401000040002c00000000d100ce000007ff804082838485868788898a8b8c8d8e8f90918701061f059797071a1d01929e9fa0a1a2a3a4a3010500a9aaab0007a5afb0b1b2b3a20316a90c0ebaba0ca8a91ab4c1c2c3c4a103aa0601cacbcba9058703c5d2d3d4b106aa03ccda07bf85a7a90717d5e3e4e589d7a9d9dacbdcdd83dfabe1e6f3f4d2ed050aebcbbe1309c082b6521968074e5cbd83084dddd3b72fd50408fe00225be660d5bf84183332827780618001be44408008ec98c07515535988a6b1a54b20015b793409a0c24892e800a8d347b0e3cb9f07692663f84095cd9b097ce9f4a86c4003672c814aad96f381c79c376faa2ab0936900821da68a2d46b0eb365559476270e6755d518163ffe3cafacad6633b0c69216c6dab0f2438b9804df962c0945f5e551df932f4e52ab0e3483113f77d0ae0615ac48a0bff7dcc7991d099460f83cbecd59781cea80d55bdaa0a85680043496bd699ba7659bb685fc796cd5465a7da8fe90228c0f46ede0aaaacf26e6bf203c20b9c803f8247d8a32f15c7b12d579c32aa390d88c34a574453f23aa70eb3a7db9ef9a985791794aab2206f7ca10e1319d23c9a15f970b3ec3165d269e4e087cb0006dcb25532f601911380cbe4e45a5a13d4156066a83c538d70b031330041a97c209e6da93400a1322901901704150e77a16c2679474c4c5c11c5002b07c808183cc4e106005e79b558dd8ba43dd5583139997795ff7c161860905cf18de6d18d0024b0e25a3211295b4ac5c0b354660a1c4099330c8a459303b3599616964a6ac9578cc31808c090bc7d88e3882fe5b4db3a86e585259a6ef206172d1ceeb99d0154aa549f46e0ad675d2afc65955fa0b2dd78642c7efd17a802068c395c990709878f8090ae3829a5a455a4a13598a1da14880088580f8f6da564ea49aeca864e2c017c905caeda3c9028383a4a13195fe8448a8076c0ae938f7ea9c042538fcdae6300934e52f399626326a002965f56bbcc31ca9d176d2904192aee32617afa01a8c1ac9659a6ab98b86e84738206002999da7baf80b0e6184c3bfec2e8c001b9947b2f378042bbaf2849fe9bd9b5abd0f724ff29b44a4ca402a8a8a36e006f8922a7c21ab7c5a9a705c0fb499459961ce031a3720cc0b3daa80a712af99ce8b27eb0cafac9993b07784d62309fc8cdaa3fa7620209b8901cb447c2e258ac227a3ebd1d37435d43279f005c9434003ffcb080048c396db5b5d85e9c48a3e19ead985fea30ec552a787a6252d8782f000207003490a3db1eb5bbcabbbf19222acd80b75554cca828778ca16fa92dc9dd78574e810011f46d00e2892ff340c0d910425de7dc6559b432d750cbccd1a3505ef9eb1b789079caa4a35def01392bd866edebdc9875cbdcec1e8091ada7f2faf1788790012e1f037ef22a4a35cffb471d2b8375431fc3598bf1c877ff4308654fff2aff2b3a4fbf783e32ab733a4337be573cd8de7b3f3663e59f2d2c03f5d75e11d1c33dab757183da1efce2173f0aecad6f7f135f0014d00ab391ce7728021e001aa60f5f38875fdc23a0062920bb4f71ae73146b80033ee836b8290382ca68dc6c2e25400dba106fb1838af80447bbc49d8f7a5f5a5f5f54e1b5f7bdf08762cb9c033bf739629d6d7fcab82125f2053564602a83408cdf02f8963f10a24284245c170a9168bd0932e541b2705d14bbb78108144c81ceba87f45065c200a050664314ce4a6621c631c2ce4568541c9512582d0554a78d3ad4079588438b3ada316c1260621e1513c2cdad4b89ff0b1c630a1746281ef2072068d922e7d50e06acf1ff425ca40b05cde58e6018728ccbfbe426a1b6c72a6ea9430b54216b02684a4b467101a850e52a99f2bc1aba497d9af2488aa6168b0ba46203879c62db76f9b24ec6913791f4510124178c5410c08e653c2333898428235ee87ab3f900258961cd316e008fdb4495021cf0145ff2a67afa6ac538ca09c4446e2d9d6c6cc7019ec9932ca2ce89f304c0357f9849e1e1135521c49d9686590e7aba30950795d83adba94b6952531a0e95622e23ea323bb5c295dab0e038ab91d1ee2913a41c75550847f836c4d4a3a4c7cb264a539a2b1aae514f078169e5cea93a9ada4f9f102a0b42748a4845fad48a9aa3d9202f4a0ea216f4a8e2f368477c41c884e814a250ff45e303ac023d9599a3a4b884655617e9d1f0bc54a0953be958b7d9cdf92c2aa003fd814cd78acfe72d68a4e444ab5cd149d783963544751b4639edd9d7a3462d1ec48485351369d0c21e9462f3c95635052a56c766557000ad64652d4bd7b2e25580cb74db0376e1809972561f27a040294b3132d2a5a85ea33cad62527082b02d0f009ff5c4833a472f56c850b6b33501de54dbb552ec367134f12df980db961608b7721e4805531fb110de2af7ba3d65ae365a80bc056c0614d545ee75c7cb4fced2c07b0290ee277a850bd22577bcac88ad764920c5ef428223ee85ef782b7a3606f0514bb525607a0130dd494c1284fa1def2a51910304fa93340126a0ff77e5f9886d252e27095e6e1e65068115707076fcd5460a9eebc20127961016061c8633cc2c341e032f088800de08705b06949719238ee2ec1a71dc0bb3d8b7a6ede88f46b2acd7cdcf9b5ee1ee1813491baab51870b0fa71904b760d3515197906cc5c031cc910195c72c7e728d194811565168f596255ceca95bd17c339198abe9764f2d4c29bb83267f8ccffba460cd2b2660282cf9b70bee40fc05c083a034e3e3f0e2defb81129220fd08563e39bdf048d37398beec09d43b49417c9e815f5f9871c048004281d36beb90f08f8259da6cdbc485420604510f834103320635213002ea946eeaaefdc6a15c13ad68f8ea26a474d6a54bc6740f94df42a42ffdc5154fcdad182a635a97f80837498a405d655f6a9a6f7e26743fb92aa1500a54bc0026b1b4f06807b8bb637cbbb6e7b1bd8944eef022ef98291981b7e2738db8a13cd6c2a57e6dddfbea477c56dc715684527622441d0f6fde37e6b2ccd008777bc0130ef28c2405208b7e5096ec0e575d939c30e975845441271890b7ae051dcc165321eecb00dd893e2fa788243feaf4e97dce48296f70f5d209a019c72c08879708064ae5f9a2fac26370ff8c9014070029680e73dffb972dd49a45d833c8fce4ebad2734e71a7b300d6f7461ed095fb5ff6587de658f7b5d6717ef20878207e2fd0c1afc37ebcb15f77cb429fcdba8d2e2ea70069ed6c17742229d0bdff7a3f9beeafb33b7c6d0ca3756fbb76ee067ce0051d810c20efe2de467ce5149f608532c7f1b88aea9025bf754a0ffe7598cf3ccbc5ee78aa6be3bdcae67bb5204efac953def27883fabb358f37ce27baec4b04bdec9b45fbdacbdaf40020fcd34bce7b9783be5eb16178c3d168f3da97bebb042040c509587972dfbcf93ff0bde3fdfbfce19319e9d6bfc9f1d37adb547860fbdd13800fbefefdd5d7fdf9f8f7adf97355fdf4db3e6ce7847ec8c101f05777569274e0277ef9177b689475fea77e2d97371cf0775a5100f1230007587f3e674be1b780f9275f99a6760f787dce0776c4267619c87cf697781ef87c8d753691378224f80300407241526b28a8ff7509d8828ef78256138332687b21208287814c3988802bb8793ca86dd945445512847c16813fe0012978184d97785508703bb884da067cfaf66f50a86652580036b82213608147a88152c785eb86452a0686610881dd837eb026026868803a9884bdc786cfe77a1ad37f71687b00f06abf6687f19785bba787cec787f8e78531478781488283f86c8698862ab88111a8808cf8636e782f373221912887c8c301659817958887488889acb7891ee88794e280a1288ac753006ab22209f0769618715bc88a2de8882f028bb14882e9757827888579a88af7c78b4bd889440284c1687be74488d95180bd8788aa878c2ca88c6ce88aa4e18ccfb87e3f5000d608ff00b8978b5aa8881da88d8ce88b5e710dd8f18c79018eb7d668101003c9875ed67878e8a889ea987fcc882c70088f627881902802a27681f93877fbd88fcac88d1e129002298bf1f723226090078990c7b8860ca98c3540033330022019923d300327706b11e9695268391970091e407802969060b7901ba98c46e83d26799251386dc6988a1a39939ba84137899312a9931898911cc88f3e997f40498438098e9754943c799449c98a4b299403a993d568949938953f49404169954e794850a98652c9957c58955639834f0993b7828d4a68966c889669199676349697d89370d98272099629b9964848607899970bb89742499763649789481b812998f847ff984dd99762c9963781252cb1988c097a8e799286194588f96b58422030910ad4889497c9629919919b09449d7925b4040430459aa59960a72990a9f943ab991609d09aaea9576f199bcfc701b3098fb5f942b779132dc24282f09abe897f7768934c89932b809559f96bc78908cab99ca0d79cddf39556199dd2197ef9688f147608d7899deba69dc8c39d27e91f191002d2799bfe813486509ee6a96ce8793cea2990feb10a1e5093398788f1995bbb19577b589f4c189ca1b89f07a020a9e076fe79985918a08b409f06ca62f7f93af9198cfb59990bba0a0e5a9759e81b8c40a1159a60175a39199aa0ce20391fc2a000e0762e499c55880d8d40a2250aff5f273a63cfa9a22e421e1daa0a1c0002318a9107d76423ca9b057aa31996a36193a27128a18dd001b012a4438a8a7a910e8f60a34a3a75081a84500a0952ca0a547a845812588aa0a55bca0a4cfa034e1a842d52559f10a6d02301f057949f1909689aa65bd1a50ff8a6020aa6be32a7f3c6032870a7788aa48ba8a7e37585dbb9a36eca16bc52096a6a032dd2438e005343a8a88bcaa7d6e7a7c14009811a0f9fa0537a93399aca0a8c9a9e8edaa7f6250ca0daaa9040544dda7ea79aaaf8b9aae9579dd570012736a1888a659853ab9c0a78ba2a17ce50a5def3677a6aab188aaba4a702b02a16d0e39e2e146a5bcaac28eaac80c7268f71016cf3a22040ff8ddd23017c53a2d8aaa350c8ada80159a990010fca66b48a9de7daa4da9a74ea5a1b7f5500c528451260aacb39af6c5aaf258725969a1adecaa0112000e29a9ef1ca9800dba6f6aa9be3c1aee4f8ae2615ac97f9b002fb6e86da2085f0571cb0aff1a3ac7929b2b7ea7f1debb186a3012e2a00c8da3dd66a9604daa8e997592a9b081d201f1930b3f143365cc9b3275b7b367bb38a70012012b2a0d6b0ea08b4cd2ab4124bb48940092eda922f14691bc9b4d94a7a430bb58ed001a13a1c588b9f4acb88614baf9247a35cbb32201201745ab520e0af9b58b6010b78689bb6a020b5fcf9b2dd43b27c28b7107b2b466ab7b5f0b50540add50a9bdae6b71b0bff6c582ab8afe0ad1e1aae3fe4b34ba8b837b7a18e3b0b149b017a8b65d1d582961b71989bb9850422fafa43569b7fa1fb6ea34bbac100b9aa90b00b8b3c1b30b63fb6bacfd6baae3b0c9b6bb126f5b68ee74210fba5bb5b0cf96ab2367976d725bcb84abcc52b0d01c0b2abe0b2a086b119c6bcb90ba9cf5b0e9b2bb795c3b7e385bdb0e6bcdb3b0e46bb0a480b6a9f1bbea7e9a9e53b2b0992b7f554aebe25be14a2bdef8b10390b3dde0b430deb42e71424f89bbf0971beb1dbb66eebaf2f3489c639c0048c1178ab0a54fb43340699782382c5fac02f3100846bb8d2991519acc13f61c00d2ab958d9c0e329c262b1b99d1b452311c22a6c26a68bbc40045511d11ac36201bb0daab0c974af38fc18bd7b4be58a9c3fec18c75bb5435cc4d211bd084bbdde430149acc4f6d1bdaf4301cab3b5520c1c24ec0c0540bfaa60a659bcc4f13b755e15c61e8b201a90c61dd0abf91b08003b)
  779.  
  780. -- Populate Contacts
  781. SET IDENTITY_INSERT [dbo].[Contacts] ON
  782. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (1, N'Christopher Martin', N'01446 175923', N'07634 717173', N'17 High Street', N'Darlington', N'Cheshire', '20070914 16:09:21.383', N'Matt.Mitchell@example.com')
  783. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (2, N'Joseph Bennett', N'01147 771824', N'07956 758471', N'37 Green Lane', N'Portsmouth', N'County Durham', '20070914 16:09:21.400', N'Matt.Mitchell@example.com')
  784. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (3, N'Joshua Scott', N'01940 919059', N'07331 757163', N'33 George Street', N'Llandudno', N'County Durham', '20070914 16:09:21.400', N'Matt.Mitchell@example.com')
  785. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (4, N'Daniel Powell', N'01659 216066', N'07272 134093', N'93 North Street', N'Newport', N'Cheshire', '20070914 16:09:21.417', N'Matt.Mitchell@example.com')
  786. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (5, N'Jennifer Washington', N'01502 976179', N'07225 483640', N'43 The Grove', N'Hull', N'Berkshire', '20070914 16:09:21.430', N'Matt.Mitchell@example.com')
  787. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (6, N'Anthony Lee', N'01200 660059', N'07696 849723', N'97 Stanley Road', N'Newport', N'Berkshire', '20070914 16:09:21.430', N'Matt.Mitchell@example.com')
  788. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (7, N'Rebecca Foster', N'01340 503829', N'07960 669272', N'79 Springfield Road', N'Salisbury', N'Licolnshire', '20070914 16:09:21.447', N'Matt.Mitchell@example.com')
  789. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (8, N'Ava Walker', N'01978 657197', N'07610 445571', N'29 North Street', N'Southall', N'Oxfordshire', '20070914 16:09:21.463', N'Matt.Mitchell@example.com')
  790. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (9, N'Matthew Ward', N'01324 940147', N'07903 833764', N'71 Kingsway', N'London EC', N'Staffordshire', '20070914 16:09:21.477', N'Matt.Mitchell@example.com')
  791. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (10, N'Matthew Mitchell', N'01661 433253', N'07822 453924', N'70 Cowley Street', N'Worcester', N'Rutland', '20070914 16:09:21.477', N'Matt.Mitchell@example.com')
  792. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (11, N'Megan Stewart', N'01653 610021', N'07363 920914', N'59 Broadway', N'Chelmsford', N'Berkshire', '20070914 16:09:21.493', N'Matt.Mitchell@example.com')
  793. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (12, N'Mia Robinson', N'01594 360107', N'07295 889232', N'22 The Avenue', N'Wigan', N'Norfolk', '20070914 16:09:21.510', N'Matt.Mitchell@example.com')
  794. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (13, N'Cameron Davis', N'01594 360107', N'07295 889232', N'35 Windsor Road', N'Watford', N'Rutland', '20070914 16:09:21.523', N'Matt.Mitchell@example.com')
  795. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (14, N'Emma Howard', N'01788 915553', N'07736 274237', N'43 Park Avenue', N'Wigan', N'Derbyshire', '20070914 16:09:21.540', N'Matt.Mitchell@example.com')
  796. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (15, N'Liam Taylor', N'01286 103534', N'07939 391131', N'47 York Road', N'Harrow', N'Shropshire', '20070914 16:09:21.540', N'Matt.Mitchell@example.com')
  797. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (16, N'Ross Ramirez', N'01945 464335', N'07126 593543', N'33 Kingsway', N'London WC', N'Herefordshire', '20070914 16:09:21.557', N'Matt.Mitchell@example.com')
  798. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (17, N'Sarah Lewis', N'01287 924924', N'07149 593067', N'91 George Street', N'Bristol', N'Cumberland', '20070914 16:09:21.570', N'Matt.Mitchell@example.com')
  799. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (18, N'Emma Taylor', N'01287 924924', N'07149 593067', N'92 Queen Street', N'Dundee', N'Kent', '20070914 16:09:21.587', N'Matt.Mitchell@example.com')
  800. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (19, N'Anthony Rivera', N'01788 915553', N'07736 274237', N'97 Church Road', N'Southampton', N'Huntingdonshire', '20070914 16:09:21.587', N'Matt.Mitchell@example.com')
  801. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (20, N'Ellie King', N'01945 464335', N'07126 593543', N'29 George Street', N'Lincoln', N'Lancashire', '20070914 16:09:21.603', N'Matt.Mitchell@example.com')
  802. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (21, N'Megan Barnes', N'01469 486350', N'07759 520189', N'92 West Street', N'York', N'Surrey', '20070914 16:09:21.620', N'Matt.Mitchell@example.com')
  803. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (22, N'Scott Watson', N'01630 243241', N'07886 967048', N'91 Mill Road', N'Chester', N'Norfolk', '20070914 16:09:21.633', N'Matt.Mitchell@example.com')
  804. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (23, N'Emily Anderson', N'01487 403649', N'07449 889487', N'100 George Street', N'Dorchester', N'Hertfordshire', '20070914 16:09:21.633', N'Matt.Mitchell@example.com')
  805. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (24, N'Nicole Martin', N'01721 599988', N'07525 825680', N'62 Kingsway', N'Colchester', N'Hertfordshire', '20070914 16:09:21.650', N'Matt.Mitchell@example.com')
  806. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (25, N'David Perry', N'01212 359994', N'07270 368607', N'59 Queen Street', N'London North', N'Cheshire', '20070914 16:09:21.667', N'Matt.Mitchell@example.com')
  807. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (26, N'Abbie Rogers', N'01120 243659', N'07237 275885', N'62 Manchester Road', N'Kirkcaldy', N'Cornwall', '20070914 16:09:21.680', N'Matt.Mitchell@example.com')
  808. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (27, N'Liam Kelly', N'01140 882420', N'07354 721715', N'88 St. John''s Road', N'Manchester', N'Northamptonshire', '20070914 16:09:21.680', N'Matt.Mitchell@example.com')
  809. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (28, N'Christopher Walker', N'01889 655242', N'07332 289915', N'73 North Street', N'Paisley', N'Yorkshire', '20070914 16:09:21.697', N'Matt.Mitchell@example.com')
  810. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (29, N'Matthew Collins', N'01305 665775', N'07352 869339', N'60 York Road', N'Outer Hebrides', N'Staffordshire', '20070914 16:09:21.713', N'Matt.Mitchell@example.com')
  811. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (30, N'Elidh Peterson', N'01183 454781', N'07295 215265', N'59 Albert Road', N'Norwich', N'Cheshire', '20070914 16:09:21.727', N'Matt.Mitchell@example.com')
  812. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (31, N'Jamie Price', N'01624 725814', N'07773 220491', N'40 Manor Road', N'Kingston upon Thames', N'Rutland', '20070914 16:09:21.743', N'Matt.Mitchell@example.com')
  813. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (32, N'Katie Sanchez', N'01192 635557', N'07695 694205', N'50 New Street', N'Hemel Hempstead', N'Cornwall', '20070914 16:09:21.743', N'Matt.Mitchell@example.com')
  814. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (33, N'Erin Rodriguez', N'01701 154719', N'07699 485122', N'8 York Road', N'Swindon', N'Derbyshire', '20070914 16:09:21.760', N'Matt.Mitchell@example.com')
  815. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (34, N'Abbie Brooks', N'01287 924924', N'07149 593067', N'73 Springfield Road', N'Ipswich', N'County Durham', '20070914 16:09:21.773', N'Matt.Mitchell@example.com')
  816. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (35, N'Lauren Simmons', N'01442 337633', N'07986 644216', N'98 London Road', N'London E', N'Cheshire', '20070914 16:09:21.790', N'Matt.Mitchell@example.com')
  817. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (36, N'Emily Bennett', N'01907 200803', N'07636 884168', N'90 West Street', N'Salisbury', N'Herefordshire', '20070914 16:09:21.790', N'Matt.Mitchell@example.com')
  818. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (37, N'Christopher Flores', N'01198 529461', N'07207 549127', N'74 Queens Road', N'Crewe', N'Cheshire', '20070914 16:09:21.807', N'Matt.Mitchell@example.com')
  819. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (38, N'Alexander Rivera', N'01120 243659', N'07237 275885', N'25 Grange Road', N'Dudley', N'Huntingdonshire', '20070914 16:09:21.820', N'Matt.Mitchell@example.com')
  820. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (39, N'Rachel Williams', N'01512 965727', N'07889 215998', N'62 Victoria Road', N'Dundee', N'Hampshire', '20070914 16:09:21.837', N'Matt.Mitchell@example.com')
  821. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (40, N'Olvia Howard', N'01547 693549', N'07341 808038', N'17 Kings Road', N'Guildford', N'Warwickshire', '20070914 16:09:21.837', N'Matt.Mitchell@example.com')
  822. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (41, N'Elizabeth Flores', N'01231 471798', N'07493 384582', N'64 The Green', N'Bournemouth', N'Staffordshire', '20070914 16:09:21.853', N'Matt.Mitchell@example.com')
  823. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (42, N'Kyle Griffin', N'01558 179557', N'07522 904690', N'21 Manchester Road', N'Kirkcaldy', N'Hampshire', '20070914 16:09:21.870', N'Matt.Mitchell@example.com')
  824. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (43, N'Laura Evan', N'01495 153619', N'07390 958114', N'68 Cowley Road', N'St Albans', N'Berkshire', '20070914 16:09:21.883', N'Matt.Mitchell@example.com')
  825. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (44, N'Katie Martinez', N'01285 948244', N'07424 397578', N'98 Windsor Road', N'Maidstone', N'Kent', '20070914 16:09:21.883', N'Matt.Mitchell@example.com')
  826. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (45, N'Sophie Griffin', N'01965 513379', N'07605 294144', N'10 The Green', N'Sheffield', N'Surrey', '20070914 16:09:21.900', N'Matt.Mitchell@example.com')
  827. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (46, N'Elidh Wood', N'01198 529461', N'07207 549127', N'88 North Road', N'Northampton', N'Essex', '20070914 16:09:21.917', N'Matt.Mitchell@example.com')
  828. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (47, N'Abigail Hill', N'01555 443077', N'07439 738948', N'86 The Drive', N'Sunderland', N'Hampshire', '20070914 16:09:21.930', N'Matt.Mitchell@example.com')
  829. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (48, N'Scott Bell', N'01469 486350', N'07759 520189', N'25 Park Avenue', N'Harrogate', N'Surrey', '20070914 16:09:21.930', N'Matt.Mitchell@example.com')
  830. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (49, N'Chloe Martin', N'01329 343662', N'07783 161081', N'33 New Street', N'Telford', N'Dorset', '20070914 16:09:21.947', N'Matt.Mitchell@example.com')
  831. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (50, N'Lauren Bryant', N'01752 908316', N'07676 584363', N'70 School Lane', N'Swindon', N'Middlesex', '20070914 16:09:21.963', N'Matt.Mitchell@example.com')
  832. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (51, N'Lucy Rivera', N'01287 924924', N'07149 593067', N'31 The Grove', N'Rochester', N'Cumberland', '20070914 16:09:21.977', N'Matt.Mitchell@example.com')
  833. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (52, N'Chloe Davis', N'01346 526218', N'07291 685237', N'99 The Crescent', N'Coventry', N'Shropshire', '20070914 16:09:21.977', N'Matt.Mitchell@example.com')
  834. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (53, N'Joseph Thompson', N'01237 661433', N'07302 871821', N'75 Grove road', N'Truro', N'Northumberland', '20070914 16:09:21.993', N'Matt.Mitchell@example.com')
  835. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (54, N'William Wright', N'01417 502667', N'07177 363555', N'57 Station Road', N'Romford', N'Middlesex', '20070914 16:09:22.010', N'Matt.Mitchell@example.com')
  836. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (55, N'William Hughes', N'01407 629329', N'07309 884547', N'34 High Street', N'Torquay', N'Dorset', '20070914 16:09:22.023', N'Matt.Mitchell@example.com')
  837. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (56, N'Samantha Miller', N'01333 824728', N'07634 606994', N'60 Park Lane', N'Cardiff', N'Surrey', '20070914 16:09:22.040', N'Matt.Mitchell@example.com')
  838. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (57, N'William Ramirez', N'01626 530682', N'07768 951632', N'95 Grange Road', N'Cardiff', N'Berkshire', '20070914 16:09:22.040', N'Matt.Mitchell@example.com')
  839. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (58, N'Lauren Green', N'01811 269842', N'07316 264705', N'28 Main Street', N'Huddersfield', N'Somerset', '20070914 16:09:22.057', N'Matt.Mitchell@example.com')
  840. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (59, N'Jordan Henderson', N'01624 725814', N'07773 220491', N'67 The Drive', N'Tonbridge', N'Surrey', '20070914 16:09:22.070', N'Matt.Mitchell@example.com')
  841. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (60, N'Michael Richardson', N'01346 526218', N'07291 685237', N'76 Highfield Road', N'Kilmarnock', N'County Durham', '20070914 16:09:22.087', N'Matt.Mitchell@example.com')
  842. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (61, N'Caitlin Washington', N'01291 914147', N'07913 286110', N'55 School Lane', N'Peterborough', N'Licolnshire', '20070914 16:09:22.103', N'Matt.Mitchell@example.com')
  843. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (62, N'Anna Long', N'01131 669331', N'07113 804523', N'41 The Avenue', N'Stevenage', N'Cornwall', '20070914 16:09:22.103', N'Matt.Mitchell@example.com')
  844. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (63, N'Ethan Parker', N'01940 919059', N'07331 757163', N'76 York Road', N'Blackpool', N'Middlesex', '20070914 16:09:22.120', N'Matt.Mitchell@example.com')
  845. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (64, N'Lauren Ramirez', N'01417 502667', N'07177 363555', N'74 Albert Road', N'Crewe', N'Kent', '20070914 16:09:22.133', N'Matt.Mitchell@example.com')
  846. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (65, N'Joshua Price', N'01404 421474', N'07720 314778', N'24 The Green', N'Southend on Sea', N'Yorkshire', '20070914 16:09:22.150', N'Matt.Mitchell@example.com')
  847. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (66, N'Kyle Botton', N'01291 914147', N'07913 286110', N'25 Kingsway', N'Aberdeen', N'Lancashire', '20070914 16:09:22.150', N'Matt.Mitchell@example.com')
  848. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (67, N'Bethany Hughes', N'01210 611735', N'07709 761071', N'6 New Street', N'Stevenage', N'Buckinghamshire', '20070914 16:09:22.167', N'Matt.Mitchell@example.com')
  849. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (68, N'Kyle Smith', N'01555 443077', N'07439 738948', N'90 Main Street', N'Cardiff', N'Buckinghamshire', '20070914 16:09:22.180', N'Matt.Mitchell@example.com')
  850. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (69, N'Caitlin Griffin', N'01469 486350', N'07759 520189', N'100 Mill Road', N'Oxford', N'Sussex', '20070914 16:09:22.197', N'Matt.Mitchell@example.com')
  851. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (70, N'Jamie Perez', N'01572 459202', N'07858 711874', N'86 Queens Road', N'Nottingham', N'Staffordshire', '20070914 16:09:22.213', N'Matt.Mitchell@example.com')
  852. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (71, N'Jennifer Turner', N'01192 635557', N'07695 694205', N'46 London Road', N'Brighton', N'Kent', '20070914 16:09:22.213', N'Matt.Mitchell@example.com')
  853. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (72, N'Alexander Barnes', N'01281 554917', N'07800 642581', N'78 North Street', N'London W', N'Lancashire', '20070914 16:09:22.227', N'Matt.Mitchell@example.com')
  854. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (73, N'Megan Campbell', N'01205 396727', N'07198 312473', N'20 Park Avenue', N'Blackburn', N'Suffolk', '20070914 16:09:22.243', N'Matt.Mitchell@example.com')
  855. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (74, N'Lewis Collins', N'01237 661433', N'07302 871821', N'10 Victoria Road', N'Southall', N'Norfolk', '20070914 16:09:22.260', N'Matt.Mitchell@example.com')
  856. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (75, N'Bethany Peterson', N'01784 976829', N'07885 861269', N'43 The Crescent', N'Worcester', N'Surrey', '20070914 16:09:22.260', N'Matt.Mitchell@example.com')
  857. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (76, N'Erin Martin', N'01428 428418', N'07377 251946', N'39 The Avenue', N'Milton Keynes', N'Suffolk', '20070914 16:09:22.273', N'Matt.Mitchell@example.com')
  858. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (77, N'Joseph Coleman', N'01788 915553', N'07736 274237', N'95 Park Avenue', N'Wolverhampton', N'Leicestershire', '20070914 16:09:22.290', N'Matt.Mitchell@example.com')
  859. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (78, N'Jordan Scott', N'01500 424473', N'07824 778422', N'12 Stanley Road', N'Galashiels', N'Cambridgeshire', '20070914 16:09:22.307', N'Matt.Mitchell@example.com')
  860. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (79, N'Kieran Kelly', N'01633 392324', N'07960 870808', N'91 London Road', N'Twickenham', N'Northumberland', '20070914 16:09:22.320', N'Matt.Mitchell@example.com')
  861. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (80, N'Tony Brown', N'01231 471798', N'07493 384582', N'41 Queensway', N'Falkirk', N'Berkshire', '20070914 16:09:22.337', N'Matt.Mitchell@example.com')
  862. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (82, N'Bethany Rivera', N'01784 976829', N'07885 861269', N'54 Church Street', N'London E', N'Northumberland', '20070914 16:09:22.353', N'Matt.Mitchell@example.com')
  863. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (83, N'Laura Hayes', N'01982 956405', N'07109 544766', N'56 Station Road', N'Brighton', N'Devon', '20070914 16:09:22.370', N'Matt.Mitchell@example.com')
  864. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (84, N'Anna Griffin', N'01345 471798', N'07493 384582', N'40 Windsor Road', N'Guildford', N'Cornwall', '20070914 16:09:22.383', N'Matt.Mitchell@example.com')
  865. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (85, N'Samantha Jackson', N'01231 471798', N'07493 384582', N'14 New Street', N'Llandudno', N'County Durham', '20070914 16:09:22.400', N'Matt.Mitchell@example.com')
  866. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (86, N'Kyle Sanchez', N'01978 657197', N'07610 445571', N'3 Windsor Road', N'Bromley', N'Oxfordshire', '20070914 16:09:22.400', N'Matt.Mitchell@example.com')
  867. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (88, N'Joseph Gray', N'01211 864653', N'07375 760438', N'56 South Street', N'London E', N'Gloucestershire', '20070914 16:09:22.430', N'Matt.Mitchell@example.com')
  868. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (89, N'Courtney Perry', N'01210 611735', N'07709 761071', N'13 St. John''s Road', N'York', N'Berkshire', '20070914 16:09:22.447', N'Matt.Mitchell@example.com')
  869. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (90, N'Matthew Campbell', N'01743 360803', N'07394 612512', N'68 Queen Street', N'Romford', N'Essex', '20070914 16:09:22.463', N'Matt.Mitchell@example.com')
  870. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (91, N'Alexis Cook', N'01624 725814', N'07773 220491', N'36 Queen Street', N'Falkirk', N'Norfolk', '20070914 16:09:22.463', N'Matt.Mitchell@example.com')
  871. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (92, N'Jamie Mitchell', N'01776 202627', N'07185 505540', N'90 High Street', N'Kingston upon Thames', N'Warwickshire', '20070914 16:09:22.477', N'Matt.Mitchell@example.com')
  872. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (93, N'Chloe Morris', N'01725 222331', N'07526 574605', N'97 Main Street', N'Bradford', N'Cambridgeshire', '20070914 16:09:22.493', N'Matt.Mitchell@example.com')
  873. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (94, N'Lauren Morris', N'01914 784723', N'07798 945002', N'44 Church Street', N'Durham', N'Warwickshire', '20070914 16:09:22.510', N'Matt.Mitchell@example.com')
  874. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (95, N'Olvia Barnes', N'01811 269842', N'07316 264705', N'78 Stanley Road', N'Lincoln', N'Herefordshire', '20070914 16:09:22.510', N'Matt.Mitchell@example.com')
  875. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (96, N'Olvia Hall', N'01571 657822', N'07694 711784', N'14 Windsor Road', N'Coventry', N'Middlesex', '20070914 16:09:22.523', N'Matt.Mitchell@example.com')
  876. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (97, N'Scott Turner', N'01555 443077', N'07439 738948', N'87 Station Road', N'Salisbury', N'Surrey', '20070914 16:09:22.540', N'Matt.Mitchell@example.com')
  877. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (98, N'Rebecca Hayes', N'01802 342584', N'07296 315860', N'94 George Street', N'Bournemouth', N'Somerset', '20070914 16:09:22.557', N'Matt.Mitchell@example.com')
  878. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (99, N'Kyle Perry', N'01653 610021', N'07363 920914', N'82 The Grove', N'Derby', N'Gloucestershire', '20070914 16:09:22.570', N'Matt.Mitchell@example.com')
  879. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (100, N'Kieran Patterson', N'01389 465402', N'07266 836025', N'3 St. John''s Road', N'Bolton', N'County Durham', '20070914 16:09:22.570', N'Matt.Mitchell@example.com')
  880. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (101, N'Tony Botton', N'01467 283712', N'07123 873472', N'56 Albert Square', N'Greater London', N'London', '20070919 09:16:00.000', N'Tony.Botton@example.com')
  881. INSERT INTO [dbo].[Contacts] ([ID], [Name], [PhoneWork], [PhoneMobile], [Address1], [Address2], [Address3], [JoiningDate], [Email]) VALUES (102, N'Robert Brown', N'01325 348273', N'07263 764373', N'652 Long Road', N'Northampton', N'Kent', '20070919 09:17:00.000', N'Robert.Brown@example.com')SET IDENTITY_INSERT [dbo].[Contacts] OFF
  882.  
  883. -- Populate WidgetPurchases with lots of data
  884. DECLARE @purchaseCount int
  885. SET @purchaseCount = 0
  886. SET NOCOUNT ON
  887. DECLARE @temp float
  888. SET @temp = RAND(1)
  889. WHILE (@purchaseCount < 108435) BEGIN
  890. 	INSERT INTO [dbo].[WidgetPurchases] ([WidgetPriceID], [Quantity], [InvoiceNumber], [Date]) VALUES (
  891. 		CONVERT (int, RAND() * 3) + 1, -- WidgetPriceID
  892. 		CONVERT (int, RAND() * 100) + 1, -- Quantity 
  893. 		'WIDG' + convert (nvarchar(10), convert (int, RAND() * 10000) + 1), -- InvoiceNumber
  894. 		CONVERT (datetime, -- Date
  895. 			CONVERT (nvarchar (50), 
  896. 				'2007-' + 
  897. 				CONVERT (nvarchar (2), CONVERT (int, RAND() * 11) + 1) + '-' + 
  898. 				CONVERT (nvarchar (2), CONVERT (int, RAND () * 27) + 1)
  899. 			)
  900. 		)
  901. 	)
  902. 	SET @purchaseCount = @purchaseCount + 1
  903. END
  904. SET NOCOUNT OFF
  905.  
  906. COMMIT TRANSACTION
  907. GO

Didn't find what you were looking for?

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal

Cookies on red-gate.com

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy