-
Notifications
You must be signed in to change notification settings - Fork 1
/
Generate Historical Events Database.sql
624 lines (614 loc) · 248 KB
/
Generate Historical Events Database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
/*
All code and data belongs to Wise Owl, and must not be reproduced or distributed
in any way without prior written permission
Note that this code is not written as a training aid, but instead is just
a means to create a SQL Server database on the user's computer
Code assumes HistoricalEvents database does not already exist
*/
USE Master
go
-- drop database if exists
BEGIN TRY
DROP Database HistoricalEvents
END TRY
BEGIN CATCH
-- database can't exist
END CATCH
-- create new database
CREATE DATABASE HistoricalEvents
go
USE HistoricalEvents
GO
/****** Object: Table [dbo].[tblCountry] Script Date: 02/08/2010 09:49:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblCountry](
[CountryId] [bigint] IDENTITY(1,1) NOT NULL,
[CountryName] [varchar](255) NULL,
[ContinentId] [bigint] NULL,
CONSTRAINT [PK_tblCountry] PRIMARY KEY CLUSTERED
(
[CountryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblCountry] ON
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (1, N'Australia', 6)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (2, N'Belgium', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (3, N'Canada', 4)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (4, N'China', 1)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (5, N'European Union', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (6, N'France', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (7, N'Germany', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (8, N'India', 1)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (9, N'Iraq', NULL)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (10, N'Ireland', 8)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (11, N'Italy', 8)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (12, N'Japan', 1)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (13, N'Russia/USSR', 1)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (14, N'South Africa', 2)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (15, N'Spain', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (16, N'Sweden', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (17, N'UK', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (18, N'United States', 4)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (19, N'World', NULL)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (20, N'Latvia', 3)
INSERT [dbo].[tblCountry] ([CountryId], [CountryName], [ContinentId]) VALUES (21, N'Uruguay', 5)
SET IDENTITY_INSERT [dbo].[tblCountry] OFF
/****** Object: Table [dbo].[tblContinent] Script Date: 02/08/2010 09:49:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblContinent](
[ContinentId] [bigint] IDENTITY(1,1) NOT NULL,
[ContinentName] [varchar](50) NOT NULL,
CONSTRAINT [PK_tblContinent] PRIMARY KEY CLUSTERED
(
[ContinentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tblContinent] ON
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (1, N'Asia')
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (2, N'Africa')
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (3, N'Europe')
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (4, N'North America')
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (5, N'South America')
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (6, N'Oceania')
INSERT [dbo].[tblContinent] ([ContinentId], [ContinentName]) VALUES (7, N'Antarctica')
SET IDENTITY_INSERT [dbo].[tblContinent] OFF
/****** Object: Table [dbo].[tblEvent] Script Date: 02/08/2010 09:49:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblEvent](
[EventId] [bigint] IDENTITY(1,1) NOT NULL,
[EventName] [nvarchar](255) NULL,
[EventDate] [datetime] NULL,
[Description] [nvarchar](255) NULL,
[CountryId] [bigint] NULL,
CONSTRAINT [PK_tblEvent] PRIMARY KEY CLUSTERED
(
[EventId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[tblEvent] ON
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (1, N'VE Day', CAST(0x000040B300000000 AS DateTime), N'VE Day', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (2, N'Channel Islands liberated', CAST(0x000040B400000000 AS DateTime), N'Channel Islands liberated', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (3, N'UN Charter signed', CAST(0x000040E400000000 AS DateTime), N'UN Charter signed, in San Francisco', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (4, N'First ever atomic bomb exploded', CAST(0x000040F800000000 AS DateTime), N'First ever atomic bomb exploded in a test in New Mexico (although there were other forms of atomic device before that, such as the Pile at Stagg Field, first critical on 2nd Dec 1942)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (5, N'Labour win UK General Election', CAST(0x0000410200000000 AS DateTime), N'Labour win UK General Election – Churchill out of office', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (6, N'BBC Light Programme starts', CAST(0x0000410500000000 AS DateTime), N'BBC Light Programme starts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (7, N'Atomic bomb dropped on Hiroshima', CAST(0x0000410D00000000 AS DateTime), N'Atomic bomb dropped on Hiroshima', 12)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (8, N'Atomic bomb dropped on Nagasaki', CAST(0x0000411000000000 AS DateTime), N'Atomic bomb dropped on Nagasaki', 12)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (9, N'VJ Day', CAST(0x0000411600000000 AS DateTime), N'VJ Day', 12)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (10, N'Japanese surrender signed aboard', CAST(0x0000412800000000 AS DateTime), N'Japanese surrender was signed aboard USS Missouri', 12)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (11, N'UN founded', CAST(0x0000415C00000000 AS DateTime), N'United Nations Organisation comes into existence (charter ratified by the five permanent members of the Security Council – Republic of China, France, Soviet Union, United Kingdom, and United States – and by a majority of the other 46 signatories)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (12, N'UNESCO founded', CAST(0x0000416700000000 AS DateTime), N'UNESCO founded', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (13, N'Bermuda Triangle legend starts', CAST(0x0000418600000000 AS DateTime), N'Loss of ''Flight 19'' on a training exercise starts the Bermuda Triangle legend', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (14, N'World Bank established', CAST(0x0000419C00000000 AS DateTime), N'World Bank established', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (15, N'First civil flight from Heathrow Airport', CAST(0x000041A100000000 AS DateTime), N'First civil flight from Heathrow Airport', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (16, N'Bank of England nationalised', CAST(0x000041DC00000000 AS DateTime), N'Bank of England nationalised', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (17, N'Iron Curtain used', CAST(0x000041E000000000 AS DateTime), N'Churchill uses the term ''Iron Curtain'' in a speech in Missouri', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (18, N'US starts nuclear tests', CAST(0x0000426E00000000 AS DateTime), N'US starts nuclear tests at Bikini Atoll – hence the name adopted for the garment which ''reveals the most potent forces of nature''!', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (19, N'Start of Dick Barton on radio', CAST(0x000042B800000000 AS DateTime), N'Start of Dick Barton, Special Agent on BBC radio – until March 1951', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (20, N'First session of UN', CAST(0x000042C800000000 AS DateTime), N'First session of new United Nations Organisation held, in Flushing Meadow, New York', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (21, N'Coal Mines nationalised', CAST(0x0000430E00000000 AS DateTime), N'Coal Mines nationalised', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (22, N'International Organization for Standardization (ISO) founded', CAST(0x0000434300000000 AS DateTime), N'International Organization for Standardization (ISO) founded', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (23, N'International Monetary Fund begins', CAST(0x0000434900000000 AS DateTime), N'International Monetary Fund begins financial operations', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (24, N'School leaving age raised to 15', CAST(0x0000436800000000 AS DateTime), N'School leaving age raised to 15 in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (25, N'India gains independence', CAST(0x000043EF00000000 AS DateTime), N'India gains independence: sub-continent partitioned to form India (Secular, Hindu majority) and Pakistan (Islamic)', 8)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (26, N'CSound barrier broken', CAST(0x0000442C00000000 AS DateTime), N'Chuck Yeager first to break the sound barrier', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (27, N'British military occupation ends in Iraq', CAST(0x0000443800000000 AS DateTime), N'British military occupation ends in Iraq', 9)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (28, N'Marriage of Princess Elizabeth', CAST(0x0000445100000000 AS DateTime), N'Marriage of Princess Elizabeth (later Elizabeth II) and Philip Mountbatten in Westminster Abbey', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (29, N'British Railways nationalised', CAST(0x0000447B00000000 AS DateTime), N'British Railways nationalised', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (30, N'Gandhi assassinated in Delhi', CAST(0x0000449800000000 AS DateTime), N'Gandhi assassinated in Delhi', 8)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (31, N'Marshall Plan signed', CAST(0x000044D800000000 AS DateTime), N'Marshall Plan signed by President Truman for rebuilding the allied countries of Europe (aid had started in 1947 and ended in 1951)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (32, N'Berlin airlift starts', CAST(0x0000453100000000 AS DateTime), N'Berlin airlift starts (to 30 Sep 1949)', 7)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (33, N'NHS founded', CAST(0x0000453500000000 AS DateTime), N'National Health Service (NHS) begins in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (34, N'London Olympics begin', CAST(0x0000454D00000000 AS DateTime), N'London Olympics begin', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (35, N'Clothes rationing ends', CAST(0x0000463200000000 AS DateTime), N'Clothes rationing ends in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (36, N'NATO founded', CAST(0x0000464600000000 AS DateTime), N'Twelve nations sign The North Atlantic Treaty creating NATO', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (37, N'Russians lift the Berlin blockade', CAST(0x0000466C00000000 AS DateTime), N'Russians lift the Berlin blockade', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (38, N'Berlin airlift ends', CAST(0x000046F900000000 AS DateTime), N'Berlin airlift ends', 7)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (39, N'Points rationing ends in Britain', CAST(0x000047E000000000 AS DateTime), N'Points rationing ends in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (40, N'Petrol rationing ends in Britain', CAST(0x000047E700000000 AS DateTime), N'Petrol rationing ends in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (41, N'Korean War starts', CAST(0x0000480500000000 AS DateTime), N'Korean War starts (to 27 Jul 1953)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (42, N'Andy Pandy first seen on TV', CAST(0x0000481500000000 AS DateTime), N'Andy Pandy first seen on BBC TV', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (43, N'Soap rationing ends in Britain', CAST(0x0000485100000000 AS DateTime), N'Soap rationing ends in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (44, N'Peak District is the first National Park', CAST(0x000048BF00000000 AS DateTime), N'The Peak District becomes the Britain''s first National Park', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (45, N'Festival of Britain', CAST(0x0000493D00000000 AS DateTime), N'Festival of Britain and Royal Festival Hall open on South Bank, London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (46, N'First Goon Show broadcast', CAST(0x0000495600000000 AS DateTime), N'First Goon Show broadcast', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (47, N'Electricity first produced by nuclear power', CAST(0x00004A2400000000 AS DateTime), N'Electricity first produced by nuclear power, from Experimental Breeder Reactor I in Idaho (see 1962)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (48, N'George VI dies; Elizabeth II queen', CAST(0x00004A5400000000 AS DateTime), N'George VI dies; Elizabeth II queen, returns from Kenya', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (49, N'Identity Cards abolished', CAST(0x00004A6300000000 AS DateTime), N'Identity Cards abolished in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (50, N'Utility furniture and clothing scheme ends', CAST(0x00004A7C00000000 AS DateTime), N'Utility furniture and clothing scheme ends', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (51, N'First commercial jet airliner service launched', CAST(0x00004AAA00000000 AS DateTime), N'First commercial jet airliner service launched, by BOACComet between London and Johannesburg', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (52, N'Last tram runs in London', CAST(0x00004AEA00000000 AS DateTime), N'Last tram runs in London (Woolwich to New Cross)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (53, N'Lynmouth flood disaster', CAST(0x00004B1400000000 AS DateTime), N'Lynmouth flood disaster', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (54, N'DH110 crashes at Farnborough', CAST(0x00004B2900000000 AS DateTime), N'DH110 crashes at Farnborough Air Show, 26 killed', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (55, N'John Cobb killed', CAST(0x00004B4000000000 AS DateTime), N'John Cobb killed in attempt on world water speed record on Loch Ness', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (56, N'End of tea rationing in Britain', CAST(0x00004B4400000000 AS DateTime), N'End of tea rationing in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (57, N'Harrow & Wealdstone rail crash', CAST(0x00004B4900000000 AS DateTime), N'Harrow & Wealdstone rail crash, 112 killed', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (58, N'First H Bomb exploded', CAST(0x00004B6100000000 AS DateTime), N'The first H-bomb ever (''Mike'') was exploded by the USA – the mushroom cloud was 8 miles across and 27 miles high. The canopy was 100 miles wide. Radioactive mud fell out of the sky followed by heavy rain. 80 million tons of earth was vaporised.', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (59, N'Eisenhower is US President', CAST(0x00004B6500000000 AS DateTime), N'Eisenhower sweeps to power as US President', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (60, N'First UK singles chart', CAST(0x00004B6E00000000 AS DateTime), N'First regular UK singles chart published by the New Musical Express', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (61, N'The Mousetrap opens', CAST(0x00004B7900000000 AS DateTime), N'Agatha Christie''s The Mousetrap opens in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (62, N'Great smog hits London', CAST(0x00004B8200000000 AS DateTime), N'Great smog hits London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (63, N'Floods devastate the East Coast', CAST(0x00004BBC00000000 AS DateTime), N'Said to be the biggest civil catastrophe in Britain in the 20th century – severe storm and high tides caused the loss of hundreds of lives –- effects travelled from the west coast of Scotland round to the south-east coast of England', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (64, N'Sweet rationing ends in Britain', CAST(0x00004BC100000000 AS DateTime), N'Sweet rationing ends in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (65, N'Death of Stalin', CAST(0x00004BDD00000000 AS DateTime), N'Death of Stalin', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (66, N'Jonas Salk announces his polio vaccine', CAST(0x00004BF200000000 AS DateTime), N'Jonas Salk announces his polio vaccine', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (67, N'Winston Churchill knighted', CAST(0x00004C0F00000000 AS DateTime), N'Winston Churchill knighted', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (68, N'DNA helix unravelled', CAST(0x00004C1000000000 AS DateTime), N'Francis Crick and James D Watson publish the double helix structure of DNA (see 1962)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (69, N'Everest conquered by Hillary and Tensing', CAST(0x00004C3200000000 AS DateTime), N'Everest conquered by Hillary and Tensing', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (70, N'Coronation of Elizabeth II', CAST(0x00004C3600000000 AS DateTime), N'Coronation of Elizabeth II', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (71, N'End of the Korean War', CAST(0x00004C6D00000000 AS DateTime), N'End of the Korean War', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (72, N'USSR explodes Hydrogen Bomb', CAST(0x00004C7D00000000 AS DateTime), N'USSR explodes Hydrogen Bomb', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (73, N'Sugar rationing ends in Britain (after nearly 14 years)', CAST(0x00004CAA00000000 AS DateTime), N'Sugar rationing ends in Britain (after nearly 14 years)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (74, N'Piltdown Man skull declared a hoax', CAST(0x00004CE200000000 AS DateTime), N'Piltdown Man skull declared a hoax by the Natural History Museum', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (75, N'Hungary wins 6-3 at Wembley Stadium', CAST(0x00004CE600000000 AS DateTime), N'Hungary becomes the first football team outside the British Isles to beat England at home, winning 6-3 at Wembley Stadium', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (76, N'First sub 4 minute mile', CAST(0x00004D8800000000 AS DateTime), N'First sub 4 minute mile (Roger Bannister, 3 mins 59.4 secs)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (77, N'Rock Around the Clock released', CAST(0x00004D8C00000000 AS DateTime), N'Bill Haley and the Comets release Rock Around the Clock', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (78, N'Food rationing officially ends in Britain', CAST(0x00004DC200000000 AS DateTime), N'Food rationing officially ends in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (79, N'BBC broadcasts its first television news bulletin', CAST(0x00004DC400000000 AS DateTime), N'BBC broadcasts its first television news bulletin', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (80, N'First atomic powered sumbmarine', CAST(0x00004E1B00000000 AS DateTime), N'First atomic powered sumbmarine USS Nautilus commissioned', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (81, N'Anthony Eden becomes Prime Minister', CAST(0x00004ED800000000 AS DateTime), N'Anthony Eden becomes Prime Minister', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (82, N'Anti-polio vaccine developed', CAST(0x00004EDD00000000 AS DateTime), N'Anti-polio vaccine developed by Jonas Salk declared safe and effective to use (available to public 1 May 1956)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (83, N'Allied occupation of Austria ends', CAST(0x00004F4700000000 AS DateTime), N'Allied occupation of Austria (after WW2) ends', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (84, N'Commercial TV starts in Britain', CAST(0x00004F8000000000 AS DateTime), N'Commercial TV starts in Britain – first advert was for Gibbs SR toothpaste – BBC Radio kills off Grace Archer in retaliation', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (85, N'Radiotelephony spelling alphabet introduced', CAST(0x0000502100000000 AS DateTime), N'Radiotelephony spelling alphabet introduced (Alpha, Bravo, etc)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (86, N'Premium Bonds first launched', CAST(0x0000505000000000 AS DateTime), N'Premium Bonds first launched – first prizes drawn on 1 Jun 1957', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (87, N'Eurovision Song Contest launched', CAST(0x0000507500000000 AS DateTime), N'The first Eurovision Song Contest is held in Lugano, Switzerland – won by the host nation', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (88, N'3rd class travel abolished on BR', CAST(0x0000507F00000000 AS DateTime), N'3rd class travel abolished on British Railways (renamed ''Third Class'' as ''Second Class'', which had been abolished in 1875 leaving just First and Third Class)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (89, N'Submarine telephone cable across the Atlantic opened', CAST(0x000050F100000000 AS DateTime), N'Submarine telephone cable across the Atlantic opened', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (90, N'Hungarians protest against Soviet occupation', CAST(0x0000510D00000000 AS DateTime), N'Hungarians protest against Soviet occupation (protest crushed on 4 Nov)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (91, N'Britain and France invade Suez', CAST(0x0000511500000000 AS DateTime), N'Britain and France invade Suez', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (92, N'Suez canal blocked for a few months', CAST(0x0000512500000000 AS DateTime), N'Suez canal blocked for a few months (see also 1957 & 1967)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (93, N'Harold Macmillan becomes Prime Minister', CAST(0x0000515D00000000 AS DateTime), N'Harold Macmillan becomes Prime Minister', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (94, N'BBC TV broadcasts Six-Five Special', CAST(0x0000518100000000 AS DateTime), N'BBC TV started to broadcast Six-Five Special, breaking the ''Toddlers'' Truce'' of no broadcasting 6-7pm', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (95, N'Suez canal reopened by the Egyptians', CAST(0x0000519500000000 AS DateTime), N'Suez canal reopened by the Egyptians (see 1956)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (96, N'EEC founded', CAST(0x000051A600000000 AS DateTime), N'Treaty of Rome to create European Economic Community (EEC) of six countries: France, West Germany, Italy, Belgium, Holland and Luxembourg – became operational Jan 1958', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (97, N'Post-Suez petrol rationing ends', CAST(0x000051D800000000 AS DateTime), N'Post-Suez petrol rationing ends', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (98, N'Britain explodes her first H bomb', CAST(0x000051D900000000 AS DateTime), N'Britain explodes her first hydrogen bomb, at Christmas Island', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (99, N'Premium Bonds first prizes drawn', CAST(0x000051EA00000000 AS DateTime), N'Premium Bonds first prizes drawn', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (100, N'West Side Story opens in New York', CAST(0x0000525F00000000 AS DateTime), N'West Side Story opens in New York', 18)
GO
print 'Processed 100 total records'
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (101, N'Sputnik I launched by Soviet Union', CAST(0x0000526700000000 AS DateTime), N'Sputnik I launched by Soviet Union – first artificial satellite', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (102, N'Sputnik 2 launched by Soviet Union', CAST(0x0000528500000000 AS DateTime), N'Sputnik 2 launched by Soviet Union – carried a dog (''Laika'')', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (103, N'Lewisham rail disaster', CAST(0x000052A400000000 AS DateTime), N'Lewisham rail disaster – 90 killed as two trains collide in thick fog and a viaduct collapses on top of them', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (104, N'Launch of Explorer 1', CAST(0x000052DE00000000 AS DateTime), N'Launch of Explorer 1 – first American satellite', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (105, N'Munich air disaster', CAST(0x000052E400000000 AS DateTime), N'Munich air disaster – Manchester United team members killed', 7)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (106, N'CND launched', CAST(0x000052F700000000 AS DateTime), N'CND launched', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (107, N'USA launches its first satellite', CAST(0x0000530B00000000 AS DateTime), N'USA launches its first satellite (Vanguard 1) – space race with the USSR begins', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (108, N'Velcro trade mark registered', CAST(0x0000534400000000 AS DateTime), N'Velcro trade mark registered', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (109, N'Charles created Prince of Wales', CAST(0x0000538E00000000 AS DateTime), N'Charles created Prince of Wales', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (110, N'USS Nautilus travels under the polar ice cap', CAST(0x0000539600000000 AS DateTime), N'USS Nautilus travels under the polar ice cap', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (111, N'Charles de Gaulle establishes Fifth Republic', CAST(0x000053D500000000 AS DateTime), N'Charles de Gaulle establishes Fifth Republic in France – and is elected President on 21 Dec', 6)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (112, N'First commercial flight of Boeing 707', CAST(0x000053EA00000000 AS DateTime), N'First commercial flight of Boeing 707 (NY to Paris)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (113, N'Inauguration of Subscriber Trunk Dialling (STD) in Britain', CAST(0x0000541200000000 AS DateTime), N'Inauguration of Subscriber Trunk Dialling (STD) in Britain (completed in 1979)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (114, N'Preston by-pass opens', CAST(0x0000541200000000 AS DateTime), N'Preston by-pass opens – UK''s first stretch of motorway', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (115, N'Pane crash kills Buddy Holly, Ritchie Valens, and The Big Bopper', CAST(0x0000544E00000000 AS DateTime), N'''The Day The Music Died'' – plane crash kills Buddy Holly, Ritchie Valens, and The Big Bopper', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (116, N'Vanguard 2 satellite launched', CAST(0x0000545C00000000 AS DateTime), N'Vanguard 2 satellite launched – first to measure cloud-cover distribution', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (117, N'St Lawrence Seaway opens', CAST(0x0000549F00000000 AS DateTime), N'St Lawrence Seaway opens', 3)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (118, N'Empire Day becomes Commonwealth Day', CAST(0x000054BC00000000 AS DateTime), N'Empire Day becomes Commonwealth Day', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (119, N'Hawaii becomes 50th State of the USA', CAST(0x0000551500000000 AS DateTime), N'Hawaii becomes 50th State of the USA', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (120, N'USSR crash-lands unmanned Lunik on the moon', CAST(0x0000552D00000000 AS DateTime), N'USSR crash-lands unmanned Lunik on the moon', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (121, N'Postcodes introduced in Britain', CAST(0x0000554000000000 AS DateTime), N'Postcodes introduced in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (122, N'First section of M1 motorway opened', CAST(0x0000555D00000000 AS DateTime), N'First section of M1 motorway opened', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (123, N'Macmillan ''wind of change'' speech in South Africa', CAST(0x000055BB00000000 AS DateTime), N'Macmillan ''wind of change'' speech in South Africa', 14)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (124, N'New £1 notes issued', CAST(0x000055E600000000 AS DateTime), N'New £1 notes issued by Bank of England', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (125, N'Last steam locomotive of BR named', CAST(0x000055E700000000 AS DateTime), N'Last steam locomotive of British Railways named', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (126, N'Francis Chichester arrives in New York', CAST(0x0000566400000000 AS DateTime), N'Francis Chichester arrives in New York aboard Gypsy Moth II (took 40 days), winning the first single-handed transatlantic yacht race which he co-founded (see 1967)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (127, N'Echo I launched', CAST(0x0000567A00000000 AS DateTime), N'Echo I, the first (passive) communications satellite, launched', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (128, N'MoT tests on motor vehicles introduced', CAST(0x0000569900000000 AS DateTime), N'MoT tests on motor vehicles introduced', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (129, N'Nikita Khrushchev disrupts the UN', CAST(0x000056AA00000000 AS DateTime), N'Nikita Khrushchev disrupts the United Nations General Assembly with a number of angry outbursts', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (130, N'HMS Dreadnought nuclear submarine launched', CAST(0x000056AC00000000 AS DateTime), N'HMS Dreadnought nuclear submarine launched', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (131, N'Lady Chatterley''s Lover case', CAST(0x000056CC00000000 AS DateTime), N'Penguin Books found not guilty of obscenity in the Lady Chatterley''s Lover case', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (132, N'Farthing ceases to be legal tender in UK', CAST(0x0000570800000000 AS DateTime), N'Farthing ceases to be legal tender in UK', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (133, N'John F Kennedy becomes US President', CAST(0x0000571B00000000 AS DateTime), N'John F Kennedy becomes US President', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (134, N'First US Polaris submarines', CAST(0x0000574A00000000 AS DateTime), N'First US Polaris submarines arrive at Holy Loch', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (135, N'Black & White £5 notes cease to be legal tender', CAST(0x0000574F00000000 AS DateTime), N'Black & White £5 notes cease to be legal tender', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (136, N'New English Bible (New Testament) published', CAST(0x0000575000000000 AS DateTime), N'New English Bible (New Testament) published', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (137, N'Yuri Gagarin first man in space', CAST(0x0000576D00000000 AS DateTime), N'Yuri Gagarin first man in space – followed shortly afterwards by Alan Shepard on 5th May', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (138, N'Census: Pop. E&W 46M, Scot 5.1M, NI 1.4M', CAST(0x0000577800000000 AS DateTime), N'Census: Pop. E&W 46M, Scot 5.1M, NI 1.4M', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (139, N'Betting shops legal in Britain', CAST(0x0000578000000000 AS DateTime), N'Betting shops legal in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (140, N'John F Kennedy announces space goal', CAST(0x0000579800000000 AS DateTime), N'John F Kennedy announces his goal to put a "man on the moon" before the end of the decade', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (141, N'Volcanic eruption on Tristan da Cunha', CAST(0x0000582200000000 AS DateTime), N'Volcanic eruption on Tristan da Cunha – whole population evacuated to Britain', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (142, N'Consecration of new Coventry Cathedral', CAST(0x0000590500000000 AS DateTime), N'Consecration of new Coventry Cathedral (old destroyed in WW2 blitz) – Britten War Requiem', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (143, N'First nuclear generated electricity', CAST(0x0000591A00000000 AS DateTime), N'First nuclear generated electricity to supplied National Grid (from Berkeley, Glos)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (144, N'Telstar launched', CAST(0x0000593300000000 AS DateTime), N'First TV transmission between US and Europe (Telstar) – first live broadcast on 23 Jul', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (145, N'Marilyn Monroe found dead', CAST(0x0000594D00000000 AS DateTime), N'Marilyn Monroe found dead', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (146, N'Cuba missile crisis', CAST(0x0000599D00000000 AS DateTime), N'Cuba missile crisis – brink of nuclear war', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (147, N'No frost-free nights in Britain till 5 Mar 1963', CAST(0x000059D800000000 AS DateTime), N'No frost-free nights in Britain till 5 Mar 1963', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (148, N'Beeching Report on British Railways', CAST(0x00005A3700000000 AS DateTime), N'Beeching Report on British Railways (the ''Beeching Axe'')', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (149, N'John Profumo resigns', CAST(0x00005A7D00000000 AS DateTime), N'Secretary of State for War John Profumo resigns in a sex scandal', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (150, N'The "red telephone" link established', CAST(0x00005A8C00000000 AS DateTime), N'The "red telephone" link established between Soviet Union and United States following the Cuban Missile Crisis', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (151, N'Minimum prison age raised to 17', CAST(0x00005AB600000000 AS DateTime), N'Minimum prison age raised to 17', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (152, N'Great Train Robbery', CAST(0x00005ABD00000000 AS DateTime), N'''Great Train Robbery'' on Glasgow to London mail train', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (153, N'Martin Luther King speech', CAST(0x00005AD100000000 AS DateTime), N'Martin Luther King gives his I have a dream speech', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (154, N'Fylingdales operational', CAST(0x00005AE500000000 AS DateTime), N'Fylingdales (Yorks) early warning system operational', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (155, N'Denning Report on Profumo affair', CAST(0x00005AED00000000 AS DateTime), N'Denning Report on Profumo affair', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (156, N'Dartford Tunnel opens', CAST(0x00005B2300000000 AS DateTime), N'Dartford Tunnel opens', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (157, N'President Kennedy assassinated', CAST(0x00005B2700000000 AS DateTime), N'President Kennedy assassinated in Dallas, Texas; Aldous Huxley died the same day', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (158, N'First episode of Dr Who', CAST(0x00005B2800000000 AS DateTime), N'First episode of Dr Who on BBC TV', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (159, N'First ''Top of the Pops''', CAST(0x00005B4F00000000 AS DateTime), N'First ''Top of the Pops'' on BBC TV', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (160, N'The Beatles arrive in the US', CAST(0x00005B7400000000 AS DateTime), N'The Beatles arrive on their first visit to the United States', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (161, N'Cassius Clay beats Sonny Liston', CAST(0x00005B8600000000 AS DateTime), N'Cassius Clay (Muhammad Ali) beats Sonny Liston', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (162, N'First Greater London Council (GLC) election', CAST(0x00005BB200000000 AS DateTime), N'First Greater London Council (GLC) election', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (163, N'BBC2 TV starts', CAST(0x00005BBE00000000 AS DateTime), N'BBC2 TV starts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (164, N'Match of the Day starts on BBC2', CAST(0x00005C3900000000 AS DateTime), N'Match of the Day starts on BBC2', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (165, N'Forth road bridge opens', CAST(0x00005C4600000000 AS DateTime), N'Forth road bridge opens', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (166, N'The Sun newspaper founded in Britain', CAST(0x00005C5100000000 AS DateTime), N'The Sun newspaper founded in Britain, replacing the Daily Herald', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (167, N'First US raids against North Vietnam', CAST(0x00005CE200000000 AS DateTime), N'First US raids against North Vietnam', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (168, N'First walk in space', CAST(0x00005D0900000000 AS DateTime), N'Cosmonaut Aleksei Leonov becomes the first man to ''walk'' in space', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (169, N'Launch of Early Bird satellite', CAST(0x00005D1C00000000 AS DateTime), N'Launch of Early Bird commercial communications satellite', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (170, N'Winston Churchill dies', CAST(0x00005D1D00000000 AS DateTime), N'Winston Churchill dies', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (171, N'Mont Blanc road tunnel opens', CAST(0x00005D8100000000 AS DateTime), N'Mont Blanc road tunnel opens (begun in 1957)', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (172, N'TV ban on cigarette advertising in Britain', CAST(0x00005D9100000000 AS DateTime), N'TV ban on cigarette advertising in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (173, N'The Beatles play at Shea Stadium', CAST(0x00005D9F00000000 AS DateTime), N'The Beatles play at Shea Stadium in New York City', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (174, N'Oil strike by BP in North Sea', CAST(0x00005DC400000000 AS DateTime), N'Oil strike by BP in North Sea (or natural gas?)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (175, N'Post Office Tower operational in London', CAST(0x00005DD500000000 AS DateTime), N'Post Office Tower operational in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (176, N'Death penalty for murder suspended', CAST(0x00005DE900000000 AS DateTime), N'Death penalty for murder suspended in Britain for five-year trial period, then abolished 18 Dec 1969', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (177, N'Declaration of UDI in Rhodesia', CAST(0x00005DF700000000 AS DateTime), N'Declaration of UDI in Rhodesia', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (178, N'70mph speed limit on British roads', CAST(0x00005E2000000000 AS DateTime), N'70mph speed limit on British roads', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (179, N'Soft landing on moon by unmanned Luna 9', CAST(0x00005E4B00000000 AS DateTime), N'Soft landing on moon by unmanned Luna 9 – followed by Surveyor 1', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (180, N'Australia converts from £ to $', CAST(0x00005E5600000000 AS DateTime), N'Australia converts from £ to $', 1)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (181, N'Archbishop of Canterbury meets Pope in Rome', CAST(0x00005E7B00000000 AS DateTime), N'Archbishop of Canterbury meets Pope in Rome', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (182, N'The Times prints news on front page', CAST(0x00005EA400000000 AS DateTime), N'The Times begins to print news on its front page in place of classified advertisements', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (183, N'Seamen''s strike begins', CAST(0x00005EB100000000 AS DateTime), N'Seamen''s strike begins (ended 1 Jul)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (184, N'World Cup won by England at Wembley', CAST(0x00005EFC00000000 AS DateTime), N'World Cup won by England at Wembley (4-2 in extra time v West Germany)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (185, N'First Severn road bridge opens', CAST(0x00005F2400000000 AS DateTime), N'First Severn road bridge opens', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (186, N'Aberfan disaster', CAST(0x00005F4F00000000 AS DateTime), N'Aberfan disaster – slag heap slip kills 144, incl. 116 children', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (187, N'First Christmas stamps issued in Britain', CAST(0x00005F7800000000 AS DateTime), N'First Christmas stamps issued in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (188, N'Donald Campbell dies', CAST(0x00005F9A00000000 AS DateTime), N'Donald Campbell dies attempting to break his world water speed record on Conniston Water – his body and Bluebird recovered in 2002', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (189, N'Apollo launch pad test fire', CAST(0x00005FB100000000 AS DateTime), N'Three US astronauts killed in fire during Apollo launch pad test', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (190, N'Torrey Canyon oil tanker disaster', CAST(0x00005FE300000000 AS DateTime), N'Torrey Canyon oil tanker runs aground off Lands End – first major oil spill', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (191, N'Celtic win the European Cup', CAST(0x0000602700000000 AS DateTime), N'Celtic become the first British team to win the European Cup', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (192, N'Francis Chichester arrives in Plymouth', CAST(0x0000602A00000000 AS DateTime), N'Francis Chichester arrives in Plymouth after solo circumnavigation in Gipsy Moth IV (he was knighted 7th July at Greenwich by the queen using the sword with which Elizabeth I had knighted Sir Francis Drake four centuries earlier – see 1581)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (193, N'First withdrawal from a cash dispenser (ATM)', CAST(0x0000604800000000 AS DateTime), N'First withdrawal from a cash dispenser (ATM) in Britain – at Enfield branch of Barclays', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (194, N'First colour TV in Britain', CAST(0x0000604C00000000 AS DateTime), N'First colour TV in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (195, N'Public Record Act', CAST(0x0000605800000000 AS DateTime), N'Public Record Act – records now closed for only 30 years (but the census is still closed for 100 years)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (196, N'Withdrawal from East of Suez announced', CAST(0x0000605D00000000 AS DateTime), N'Withdrawal from East of Suez by mid-70s announced', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (197, N'Offshore pirate radio stations declared illegal', CAST(0x0000607800000000 AS DateTime), N'Offshore pirate radio stations declared illegal by the UK', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (198, N'Sweden changes rule of road to drive on right', CAST(0x0000608C00000000 AS DateTime), N'Sweden changes rule of road to drive on right', 16)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (199, N'QE2 launched on Clydebank', CAST(0x0000609D00000000 AS DateTime), N'QE2 launched on Clydebank', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (200, N'Queen Mary last transatlantic voyage', CAST(0x000060A400000000 AS DateTime), N'Queen Mary arrives Southampton at end of her last transatlantic voyage', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (201, N'BBC Radios 1, 2, 3 & 4 open', CAST(0x000060A700000000 AS DateTime), N'BBC Radios 1, 2, 3 & 4 open – first record played on Radio 1 was the controversial Flowers in the Rain by ''The Move''', 17)
GO
print 'Processed 200 total records'
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (202, N'Introduction of majority verdicts', CAST(0x000060AC00000000 AS DateTime), N'Introduction of majority verdicts in English courts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (203, N'Che Guevara killed in Bolivia', CAST(0x000060B000000000 AS DateTime), N'Che Guevara killed in Bolivia – becomes a cult hero', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (204, N'Russian spacecraft Venus IV', CAST(0x000060B900000000 AS DateTime), N'Russian spacecraft Venus IV became first successful probe to perform in-place analysis of the environment of another planet', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (205, N'First human heart transplant', CAST(0x000060E700000000 AS DateTime), N'First human heart transplant (in South Africa by Christiaan Barnard)', 14)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (206, N'British Standard Time introduced', CAST(0x0000613400000000 AS DateTime), N'British Standard Time introduced – Summer Time became permanent - the UK reverted to GMT in October 1971', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (207, N'London Bridge sold', CAST(0x0000617000000000 AS DateTime), N'London Bridge sold (and eventually moved to Arizona) – modern London Bridge, built around it as it was demolished, was opened in Mar 1973', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (208, N'Enoch Powell ''Rivers of Blood'' speech', CAST(0x0000617200000000 AS DateTime), N'Enoch Powell ''Rivers of Blood'' speech on immigration', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (209, N'Issue of 5p and 10p decimal coins in Britain', CAST(0x0000617500000000 AS DateTime), N'Issue of 5p and 10p decimal coins in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (210, N'Student riots in Paris', CAST(0x0000618600000000 AS DateTime), N'Student riots in Paris', 6)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (211, N'Manchester United win the European Cup', CAST(0x0000619900000000 AS DateTime), N'Manchester United first English club to win the European Cup', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (212, N'Robert F Kennedy shot', CAST(0x000061A000000000 AS DateTime), N'Robert F Kennedy shot – dies next day', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (213, N'Pope condemns birth control', CAST(0x000061D600000000 AS DateTime), N'Pope encyclical condemns all artificial forms of birth control', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (214, N'Last steam passenger train service', CAST(0x000061E300000000 AS DateTime), N'Last steam passenger train service ran in Britain (Carlisle–Liverpool)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (215, N'Severe flooding in England', CAST(0x0000620600000000 AS DateTime), N'Severe flooding in England', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (216, N'Two-tier postal rate starts in Britain', CAST(0x0000620700000000 AS DateTime), N'Two-tier postal rate starts in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (217, N'Hair opens in London', CAST(0x0000621200000000 AS DateTime), N'Hair opens in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (218, N'Beginning of disturbances in N Ireland', CAST(0x0000621A00000000 AS DateTime), N'Beginning of disturbances in N Ireland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (219, N'The Beatles'' last public performance', CAST(0x0000628F00000000 AS DateTime), N'The Beatles'' last public performance, on the roof of Apple Records in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (220, N'Maiden flight of Concorde', CAST(0x000062AE00000000 AS DateTime), N'Maiden flight of Concorde, at Toulouse', 6)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (221, N'Victoria Line tube opens in London', CAST(0x000062B300000000 AS DateTime), N'Victoria Line tube opens in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (222, N'Voting age lowered from 21 to 18', CAST(0x000062DC00000000 AS DateTime), N'Voting age lowered from 21 to 18', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (223, N'Maiden voyage of liner Queen Elizabeth 2 (QE2)', CAST(0x000062EB00000000 AS DateTime), N'Maiden voyage of liner Queen Elizabeth 2 (QE2)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (224, N'Investiture of Prince Charles', CAST(0x0000632700000000 AS DateTime), N'Investiture of Prince Charles as Prince of Wales at Caernarfon Castle', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (225, N'First men land on the moon', CAST(0x0000633A00000000 AS DateTime), N'Apollo 11 – First men land on the moon (Neil Armstrong & Buzz Aldrin)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (226, N'Halfpenny ceases to be legal tender in Britain', CAST(0x0000634500000000 AS DateTime), N'Halfpenny ceases to be legal tender in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (227, N'Civil disturbances in Ulster', CAST(0x0000635300000000 AS DateTime), N'Civil disturbances in Ulster – Britain sends troops to support civil authorities', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (228, N'Woodstock Music Festival', CAST(0x0000635400000000 AS DateTime), N'Woodstock Music Festival in NY State attracts 300,000 fans', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (229, N'First episode of Monty Python'' recorded', CAST(0x0000636B00000000 AS DateTime), N'First episode of Monty Python''s Flying Circus recorded', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (230, N'50p coin introduced in Britain', CAST(0x0000639000000000 AS DateTime), N'50p coin introduced in Britain (reduced in size 1998)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (231, N'Apollo 12 – second manned landing on the moon', CAST(0x000063B400000000 AS DateTime), N'Apollo 12 – second manned landing on the moon (Charles Conrad & Alan Bean)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (232, N'Death penalty for murder abolished in Britain', CAST(0x000063D100000000 AS DateTime), N'Death penalty for murder abolished in Britain (had already been suspended since Oct 1965)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (233, N'Publication of complete New English Bible', CAST(0x0000642900000000 AS DateTime), N'Publication of complete New English Bible', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (234, N'Apollo 13 launched', CAST(0x0000644300000000 AS DateTime), N'Apollo 13 launched – oxygen tank explosion aborted the moon landing mission two days later – successfully returned to Earth on 17 Apr', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (235, N'Decimal postage stamps first issued for sale in Britain', CAST(0x0000648600000000 AS DateTime), N'Decimal postage stamps first issued for sale in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (236, N'Edward Heath becomes Prime Minister', CAST(0x0000648800000000 AS DateTime), N'Edward Heath becomes Prime Minister', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (237, N'Damages awarded to Thalidomide victims', CAST(0x000064B100000000 AS DateTime), N'Damages awarded to Thalidomide victims', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (238, N'First Glastonbury Festival held', CAST(0x000064E400000000 AS DateTime), N'First Glastonbury Festival held', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (239, N'Ten shilling note goes out of circulation', CAST(0x0000652200000000 AS DateTime), N'Ten shilling note (50p after decimalisation) goes out of circulation in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (240, N'Divorce Reform Act (1969) comes into force', CAST(0x0000654C00000000 AS DateTime), N'Divorce Reform Act (1969) comes into force', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (241, N'Open University starts', CAST(0x0000654E00000000 AS DateTime), N'Open University starts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (242, N'Decimalisation of coinage', CAST(0x0000657900000000 AS DateTime), N'Decimalisation of coinage in UK and Republic of Ireland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (243, N'Internment without trial introduced in N Ireland', CAST(0x0000662800000000 AS DateTime), N'Internment without trial introduced in N Ireland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (244, N'UK launches its first (and only) satellite, Prospero', CAST(0x0000667800000000 AS DateTime), N'UK launches its first (and only) satellite, Prospero', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (245, N'Parliament votes to join Common Market', CAST(0x0000667800000000 AS DateTime), N'Parliament votes to join Common Market (joined 1973)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (246, N'Mariner 9, becomes the first spacecraft to orbit another planet (Mars)', CAST(0x0000668800000000 AS DateTime), N'Mariner 9, becomes the first spacecraft to orbit another planet (Mars)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (247, N'''Bloody Sunday'' in Derry, Northern Ireland', CAST(0x000066D600000000 AS DateTime), N'''Bloody Sunday'' in Derry, Northern Ireland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (248, N'Power workers crisis', CAST(0x000066E000000000 AS DateTime), N'Power workers crisis', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (249, N'Ceylon changes its name to Sri Lanka', CAST(0x0000674700000000 AS DateTime), N'Ceylon changes its name to Sri Lanka', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (250, N'Duke of Windsor (ex-King Edward VIII) dies', CAST(0x0000674D00000000 AS DateTime), N'Duke of Windsor (ex-King Edward VIII) dies in Paris', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (251, N'United Reformed Church founded', CAST(0x000067CF00000000 AS DateTime), N'United Reformed Church founded out of Congregational and Presbyterian Churches in E&W', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (252, N'John Betjeman becomes Poet Laureate', CAST(0x000067D400000000 AS DateTime), N'John Betjeman becomes Poet Laureate', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (253, N'Last manned moon mission, Apollo 17, launched', CAST(0x0000680E00000000 AS DateTime), N'Last manned moon mission, Apollo 17, launched – crew take the ''Blue marble'' photograph of earth', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (254, N'Britain enters EEC Common Market', CAST(0x0000682700000000 AS DateTime), N'Britain enters EEC Common Market (with Ireland and Denmark)', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (255, N'Vietnam ceasefire agreement signed', CAST(0x0000684100000000 AS DateTime), N'Vietnam ceasefire agreement signed', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (256, N'Modern London Bridge opened by the Queen', CAST(0x0000687200000000 AS DateTime), N'Modern London Bridge opened by the Queen', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (257, N'VAT introduced in Britain', CAST(0x0000688100000000 AS DateTime), N'VAT introduced in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (258, N'First call made (in New York) on mobile', CAST(0x0000688300000000 AS DateTime), N'First call made (in New York) on a portable cellular phone', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (259, N'Skylab launched', CAST(0x000068AC00000000 AS DateTime), N'Skylab launched', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (260, N'Concorde crosses Atlantic', CAST(0x0000693300000000 AS DateTime), N'Concorde makes its first non-stop crossing of the Atlantic in record-breaking time', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (261, N'Yom Kippur War', CAST(0x0000693D00000000 AS DateTime), N'Yom Kippur War precipitates world oil crisis', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (262, N'Marriage of Princess Anne', CAST(0x0000694500000000 AS DateTime), N'Marriage of Princess Anne and Captain Mark Phillips in Westminster Abbey', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (263, N'Sydney Opera House opens', CAST(0x0000694D00000000 AS DateTime), N'Sydney Opera House opens', 1)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (264, N'Miners strike and three-day week', CAST(0x0000699300000000 AS DateTime), N'Miners strike and oil crisis precipitate ''three-day week'' (till 9 Mar 1974) to conserve power', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (265, N'President Nixon resigns over Watergate', CAST(0x00006A6F00000000 AS DateTime), N'President Nixon resigns over Watergate scandal', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (266, N'Lord Lucan disappears', CAST(0x00006ACA00000000 AS DateTime), N'Lord Lucan disappears', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (267, N'Birmingham pub bombings by the IRA', CAST(0x00006AD800000000 AS DateTime), N'Birmingham pub bombings by the IRA', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (268, N'Margaret Thatcher becomes leader of Conservative party', CAST(0x00006B2A00000000 AS DateTime), N'Margaret Thatcher becomes leader of Conservative party (in opposition)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (269, N'Moorgate tube crash in London', CAST(0x00006B3B00000000 AS DateTime), N'Moorgate tube crash in London – over 43 deaths, greatest loss of life on the Underground in peacetime. The cause of the incident was never conclusively determined', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (270, N'Charlie Chaplin knighted', CAST(0x00006B3F00000000 AS DateTime), N'Charlie Chaplin knighted', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (271, N'End of Vietnam war', CAST(0x00006B7800000000 AS DateTime), N'End of Vietnam war', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (272, N'UK votes to stay in EEC', CAST(0x00006B9C00000000 AS DateTime), N'UK votes in a referendum to stay in the European Community', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (273, N'Suez canal reopens', CAST(0x00006B9C00000000 AS DateTime), N'Suez canal reopens (after 8 years closure)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (274, N'Arthur Ashe wins Wimbledon', CAST(0x00006BBA00000000 AS DateTime), N'Arthur Ashe wins Wimbledon singles title', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (275, N'American Apollo and Soviet Soyuz spacecraft dock in orbit', CAST(0x00006BC600000000 AS DateTime), N'American Apollo and Soviet Soyuz spacecraft dock in orbit', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (276, N'''Yorkshire Ripper'' commits his first murder', CAST(0x00006C2E00000000 AS DateTime), N'''Yorkshire Ripper'' commits his first murder', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (277, N'First North Sea oil comes ashore', CAST(0x00006C3300000000 AS DateTime), N'First North Sea oil comes ashore', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (278, N'General Franco dies in Spain', CAST(0x00006C4400000000 AS DateTime), N'General Franco dies in Spain; Juan Carlos declared King', 15)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (279, N'Microsoft launched', CAST(0x00006C4D00000000 AS DateTime), N'The name ''Micro-soft'' coined by Bill Gates (Microsoft'' became a Trademark the following year)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (280, N'Equal Pay Act and Sex Discrimination Act', CAST(0x00006C6900000000 AS DateTime), N'Equal Pay Act and Sex Discrimination Act come into force', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (281, N'Concorde enters supersonic passenger service', CAST(0x00006C8200000000 AS DateTime), N'Concorde enters supersonic passenger service [see 2000]', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (282, N'Apple Computer formed', CAST(0x00006CC900000000 AS DateTime), N'Apple Computer formed by Steve Jobs and Steve Wozniak', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (283, N'Drought Act 1976 comes into force', CAST(0x00006D4800000000 AS DateTime), N'Drought Act 1976 comes into force — the long, hot summer', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (284, N'Lib-Lab pact', CAST(0x00006E2D00000000 AS DateTime), N'Lib-Lab pact', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (285, N'Red Rum wins a third Grand National', CAST(0x00006E3700000000 AS DateTime), N'Red Rum wins a third Grand National', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (286, N'George Lucas'' film Star Wars released', CAST(0x00006E6C00000000 AS DateTime), N'George Lucas'' film Star Wars released', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (287, N'New road speed limits', CAST(0x00006E7300000000 AS DateTime), N'Road speed limits: 70mph dual roads; 60mph single', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (288, N'Apple II goes on sale', CAST(0x00006E7700000000 AS DateTime), N'Apple II, the first practical personal computer, goes on sale', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (289, N'Queen''s Silver Jubilee celebrations', CAST(0x00006E7900000000 AS DateTime), N'Queen''s Silver Jubilee celebrations in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (290, N'Virginia Wade wins Wimbledon', CAST(0x00006E9000000000 AS DateTime), N'Virginia Wade wins the Ladies Singles title at Wimbledon', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (291, N'Elvis Presley dies', CAST(0x00006EBF00000000 AS DateTime), N'Elvis Presley dies', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (292, N'Eradication of smallpox declared', CAST(0x00006F0600000000 AS DateTime), N'Eradication of smallpox world-wide declared by WHO (certified in 1979)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (293, N'Regular supersonic Concorde service inaugurated', CAST(0x00006F2100000000 AS DateTime), N'Regular supersonic Concorde service betweeen London and NY inaugurated', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (294, N'Broadcast of proceedings in Parliament starts', CAST(0x00006FAA00000000 AS DateTime), N'Regular broadcast of proceedings in Parliament starts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (295, N'First May Day holiday in Britain', CAST(0x00006FC100000000 AS DateTime), N'First May Day holiday in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (296, N'World''s first ''test tube'' baby', CAST(0x0000701600000000 AS DateTime), N'World''s first ''test tube'' baby, Louise Browne born in Oldham', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (297, N'Pope John Paul II elected', CAST(0x0000706800000000 AS DateTime), N'Pope John Paul II elected – a Pole, and first non-Italian for 450 years – died 2 Apr 2005', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (298, N'Publication of The Times suspended', CAST(0x0000709600000000 AS DateTime), N'Publication of The Times suspended – industrial relations problems (until 13 Nov 1979)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (299, N'Ayatollah Khomeini returns to Iran', CAST(0x000070D500000000 AS DateTime), N'Ayatollah Khomeini returns to Iran', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (300, N'Devolution votes', CAST(0x000070F100000000 AS DateTime), N'32.5% of Scots vote in favour of devolution (40% needed) – Welsh vote overwhelmingly against', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (301, N'Airey Neave killed', CAST(0x0000710E00000000 AS DateTime), N'Airey Neave killed by a car bomb at Westminster', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (302, N'Withdrawal of Royal Navy from Malta', CAST(0x0000710F00000000 AS DateTime), N'Withdrawal of Royal Navy from Malta', 19)
GO
print 'Processed 300 total records'
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (303, N'Margaret Thatcher becomes Prime Minister', CAST(0x0000713100000000 AS DateTime), N'Margaret Thatcher becomes first woman UK Prime Minister', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (304, N'Sony introduces the Walkman', CAST(0x0000716B00000000 AS DateTime), N'Sony introduces the Walkman', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (305, N'Lord Mountbatten killed', CAST(0x000071A400000000 AS DateTime), N'Lord Mountbatten and 3 others killed in bomb blast off coast of Sligo, Ireland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (306, N'ILEA votes to abolish corporal punishment', CAST(0x000071BA00000000 AS DateTime), N'ILEA votes to abolish corporal punishment in its schools', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (307, N'The Times returns to circulation', CAST(0x000071F200000000 AS DateTime), N'The Times returns to circulation', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (308, N'Lancaster House agreement', CAST(0x0000721800000000 AS DateTime), N'Lancaster House agreement to give Southern Rhodesia independence (became Zimbabwe on 18 Apr 1980)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (309, N'Death of President Tito of Yugoslavia', CAST(0x0000729F00000000 AS DateTime), N'Death of President Tito of Yugoslavia', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (310, N'SAS storm Iranian Embassy', CAST(0x000072A000000000 AS DateTime), N'SAS storm Iranian Embassy in London to free hostages', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (311, N'John Lennon assassinated', CAST(0x0000737900000000 AS DateTime), N'John Lennon assassinated in New York', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (312, N'Launch of SDP by ''Gang of Four'' in Britain', CAST(0x000073A900000000 AS DateTime), N'Launch of SDP by ''Gang of Four'' in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (313, N'First London marathon run', CAST(0x000073E800000000 AS DateTime), N'First London marathon run', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (314, N'Census day in Britain', CAST(0x000073EF00000000 AS DateTime), N'Census day in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (315, N'Brixton riots in South London', CAST(0x000073F500000000 AS DateTime), N'Brixton riots in South London – 30 other British cities also experience riots', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (316, N'First US Space Shuttle (Columbia) launched', CAST(0x000073F600000000 AS DateTime), N'First US Space Shuttle (Columbia) launched', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (317, N'Worst April blizzards this century in Britain', CAST(0x0000740300000000 AS DateTime), N'Worst April blizzards this century in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (318, N'First use of computer mouse', CAST(0x0000740500000000 AS DateTime), N'First use of computer mouse (by Xerox PARC system)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (319, N'Wedding of Prince Charles', CAST(0x0000746200000000 AS DateTime), N'Wedding of Prince Charles and Lady Diana Spencer (divorced 28 Aug 1996)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (320, N'IBM launches its PC', CAST(0x0000747000000000 AS DateTime), N'IBM launches its PC — starts the general use of personal computers', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (321, N'Unemployment reached 3 million', CAST(0x0000751700000000 AS DateTime), N'Unemployment reached 3 million in Britain (1 in 8 of working population)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (322, N'Laker Airways collapses', CAST(0x0000752100000000 AS DateTime), N'Laker Airways collapses', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (323, N'DeLorean collapses', CAST(0x0000752F00000000 AS DateTime), N'DeLorean Car factory in Belfast goes into receivership', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (324, N'Argentinians raised flag in South Georgia', CAST(0x0000754A00000000 AS DateTime), N'Argentinians raised flag in South Georgia', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (325, N'Argentina invades Falkland (Malvinas) Islands', CAST(0x0000755900000000 AS DateTime), N'Argentina invades Falkland (Malvinas) Islands', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (326, N'Royal Navy fleet sails from Portsmouth', CAST(0x0000755C00000000 AS DateTime), N'Royal Navy fleet sails from Portsmouth for Falklands', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (327, N'General Belgrano sunk', CAST(0x0000757700000000 AS DateTime), N'British nuclear submarine HMS Conqueror sinks Argentine cruiser General Belgrano', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (328, N'Goose Green battle', CAST(0x0000759100000000 AS DateTime), N'First land battle in Falklands (Goose Green)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (329, N'Ceasefire in Falklands', CAST(0x000075A200000000 AS DateTime), N'Ceasefire in Falklands', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (330, N'Birth of Prince Willia', CAST(0x000075A900000000 AS DateTime), N'Birth of Prince William of Wales', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (331, N'IRA bombings in London', CAST(0x000075C600000000 AS DateTime), N'IRA bombings in London (Hyde Park and Regents Park)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (332, N'Smiley emoticon first used', CAST(0x0000760300000000 AS DateTime), N'Smiley emoticon :-) said to have been used for the first time', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (333, N'Mary Rose raised in the Solent', CAST(0x0000761900000000 AS DateTime), N'Mary Rose raised in the Solent (sank in 1545)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (334, N'Thames Barrier raised for first time', CAST(0x0000762D00000000 AS DateTime), N'Thames Barrier raised for first time (some say first public demonstration Nov 7)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (335, N'Channel 4 TV station launched', CAST(0x0000762F00000000 AS DateTime), N'Channel 4 TV station launched – first programme ''Countdown''', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (336, N'Lorries up to 38 tonnes allowed', CAST(0x0000763100000000 AS DateTime), N'Lorries up to 38 tonnes allowed on Britain''s roads', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (337, N'Greenham Common protests', CAST(0x0000765700000000 AS DateTime), N'Women''s peace protest at Greenham Common (Cruise missiles arrived 14 Nov 1983)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (338, N'Start of breakfast TV in Britain', CAST(0x0000767B00000000 AS DateTime), N'Start of breakfast TV in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (339, N'Spreadsheet Lotus 1-2-3 released', CAST(0x0000768300000000 AS DateTime), N'Spreadsheet Lotus 1-2-3 released', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (340, N'Seat belt law comes into force', CAST(0x0000768900000000 AS DateTime), N'Seat belt law comes into force', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (341, N'£1 coin into circulation in Britain', CAST(0x000076D900000000 AS DateTime), N'£1 coin into circulation in Britain', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (342, N'Plans to abolish GLC announced', CAST(0x0000778200000000 AS DateTime), N'Plans to abolish GLC announced', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (343, N'Brinks Mat robbert', CAST(0x000077B400000000 AS DateTime), N'Brinks Mat robbery: 6,800 gold bars worth nearly £26 million are stolen from a vault at Heathrow Airport', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (344, N'FTSE index exceeded 800', CAST(0x000077E000000000 AS DateTime), N'FTSE index exceeded 800', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (345, N'Miners strike begins', CAST(0x0000781900000000 AS DateTime), N'Miners strike begins', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (346, N'Police Constable Yvonne Fletcher killed', CAST(0x0000784300000000 AS DateTime), N'Police Constable Yvonne Fletcher killed by gunfire from the Libyan Embassy in London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (347, N'Inaugural flight of Virgin Atlantic', CAST(0x0000788500000000 AS DateTime), N'Inaugural flight of Virgin Atlantic', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (348, N'York Minster struck by lightning', CAST(0x0000789600000000 AS DateTime), N'York Minster struck by lightning – the resulting fire damaged much of the building but the "Rose Window" not affected', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (349, N'IRA bomb explodes at Brighton', CAST(0x000078F500000000 AS DateTime), N'IRA bomb explodes at Tory conference hotel in Brighton – 4 killed', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (350, N'Miners'' strike', CAST(0x0000790100000000 AS DateTime), N'Miners'' strike — High Court orders sequestration of NUM assets', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (351, N'Indira Gandhi assassinated', CAST(0x0000790800000000 AS DateTime), N'Indira Gandhi assassinated', 8)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (352, N'British Telecom privatised', CAST(0x0000792900000000 AS DateTime), N'British Telecom privatised – shares make massive gains on first day''s trading', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (353, N'Bhopal disaster in India', CAST(0x0000792900000000 AS DateTime), N'Bhopal disaster in India', 8)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (354, N'Summit Tunnel Fire near Todmorton', CAST(0x0000793A00000000 AS DateTime), N'Summit Tunnel Fire near Todmorton', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (355, N'Miners agree to call off strike', CAST(0x0000798300000000 AS DateTime), N'Miners agree to call off strike', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (356, N'Al Fayed buys Harrods', CAST(0x0000798B00000000 AS DateTime), N'Al Fayed buys Harrods', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (357, N'First episode of Neighbours', CAST(0x0000799200000000 AS DateTime), N'First episode of Neighbours in Australia', 1)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (358, N'Heysel Stadium disaster', CAST(0x000079DA00000000 AS DateTime), N'Heysel Stadium disaster in Brussels', 2)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (359, N'Schengen Agreement', CAST(0x000079EA00000000 AS DateTime), N'Schengen Agreement on abolition of border controls agreed between Belgium, France, West Germany, Luxembourg, and The Netherlands – not implemented until 26 Mar 1995 when it also included Spain & Portugal – by 2007 there are 30 states included', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (360, N'Live Aid pop concert', CAST(0x00007A0700000000 AS DateTime), N'Live Aid pop concert raises over £50M for famine relief', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (361, N'Wreck of Titanic found', CAST(0x00007A3900000000 AS DateTime), N'Wreck of Titanic found (sank 1912)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (362, N'GLC abolished', CAST(0x00007B0C00000000 AS DateTime), N'GLC and 6 metropolitan councils abolished', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (363, N'Chernobyl nuclear accident', CAST(0x00007B2600000000 AS DateTime), N'Chernobyl nuclear accident – radiation reached Britain on 2 May', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (364, N'Mannie Shinwel dies', CAST(0x00007B3100000000 AS DateTime), N'Mannie Shinwell, veteran politician, dies aged 101', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (365, N'The European Community adopts the European flag', CAST(0x00007B4400000000 AS DateTime), N'The European Community adopts the European flag', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (366, N'Prince Andrew marries', CAST(0x00007B7E00000000 AS DateTime), N'Prince Andrew, Duke of York marries Sarah Ferguson at Westminster Abbey', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (367, N'''Big Bang'' (deregulation) of the London Stock Market', CAST(0x00007BDE00000000 AS DateTime), N'''Big Bang'' (deregulation) of the London Stock Market', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (368, N'M25 ring round London completed', CAST(0x00007BE000000000 AS DateTime), N'M25 ring round London completed', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (369, N'Terry Waite kidnapped', CAST(0x00007C4000000000 AS DateTime), N'Terry Waite kidnapped in Beirut (released 17 Nov 1991)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (370, N'Herald of Free Enterprise capsizes', CAST(0x00007C6000000000 AS DateTime), N'Car ferry Herald of Free Enterprise capsizes off Zeebrugge – 188 die', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (371, N'Channel Tunnel excavation starts', CAST(0x00007CD500000000 AS DateTime), N'Excavation begins on the Channel Tunnel (see 1990 & 1994)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (372, N'Hungerford Massacre', CAST(0x00007D0600000000 AS DateTime), N'Hungerford Massacre – Michael Ryan kills sixteen people with a rifle', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (373, N'The ''Hurricane'' sweeps southern England', CAST(0x00007D4000000000 AS DateTime), N'The ''Hurricane'' sweeps southern England', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (374, N'Black Monday'' in the City of London', CAST(0x00007D4300000000 AS DateTime), N'''Black Monday'' in the City of London – Stock Market crash', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (375, N'Enniskillen bombing', CAST(0x00007D5700000000 AS DateTime), N'Enniskillen bombing at a Remembrance Day ceremony', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (376, N'King''s Cross fire', CAST(0x00007D6100000000 AS DateTime), N'King''s Cross fire in London – 31 people die', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (377, N'First ''Red Nose Day'' in UK', CAST(0x00007DB000000000 AS DateTime), N'First ''Red Nose Day'' in UK, raising money for charity', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (378, N'Copyright, Designs and Patents Act', CAST(0x00007ECC00000000 AS DateTime), N'Copyright, Designs and Patents Act – reformulated the statutory basis of copyright law (including performing rights) in the UK', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (379, N'Clapham Junction rail crash', CAST(0x00007EE700000000 AS DateTime), N'Clapham Junction rail crash kills 35 and injures hundreds after two collisions of three commuter trains', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (380, N'Lockerbie disaster', CAST(0x00007EF000000000 AS DateTime), N'Lockerbie disaster – Pan Am flight 103 explodes over Scotland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (381, N'Global Positioning System launched', CAST(0x00007F2700000000 AS DateTime), N'The first of 24 satellites of the Global Positioning System is placed into orbit', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (382, N'Fatwa issued against Salman Rushdie', CAST(0x00007F2700000000 AS DateTime), N'Fatwa issued against Salman Rushdie for The Satanic Verses', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (383, N'EU decision to ban CFCs', CAST(0x00007F3700000000 AS DateTime), N'EU decision to ban production of all chlorofluorocarbons (CFCs) by the end of the century', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (384, N'Tiananmen Square massacre', CAST(0x00007F9600000000 AS DateTime), N'Tanks stopped in Tiananmen Square, Peking by unknown protester', 4)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (385, N'Berlin Wall torn down', CAST(0x0000803300000000 AS DateTime), N'Berlin Wall torn down', 7)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (386, N'Proceedings of House of Commons first televised live', CAST(0x0000803F00000000 AS DateTime), N'Proceedings of House of Commons first televised live', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (387, N'Nelson Mandela released in South Africa', CAST(0x0000809100000000 AS DateTime), N'Nelson Mandela released in South Africa', 14)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (388, N'Riots in London against Poll Tax', CAST(0x000080C100000000 AS DateTime), N'Riots in London against Poll Tax which had been implemented in England & Wales', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (389, N'Hubble space telescope launched', CAST(0x000080DA00000000 AS DateTime), N'Hubble space telescope launched', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (390, N'Iraq invades Kuwait', CAST(0x0000813D00000000 AS DateTime), N'Iraq invades Kuwait', 9)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (391, N'German reunification', CAST(0x0000817B00000000 AS DateTime), N'German reunification', 7)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (392, N'Margaret Thatcher resigns', CAST(0x000081AD00000000 AS DateTime), N'Margaret Thatcher resigns as Conservative party leader (and Prime Minister) — John Major elected', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (393, N'Channel Tunnel excavation teams meet', CAST(0x000081B600000000 AS DateTime), N'Channel Tunnel excavation teams meet in the middle', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (394, N'Helen Sharman is first British Astronaut in Space', CAST(0x0000825E00000000 AS DateTime), N'Helen Sharman is first British Astronaut in Space', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (395, N'Leningrad renamed St Petersburg', CAST(0x000082CD00000000 AS DateTime), N'Leningrad renamed St Petersburg', 13)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (396, N'Robert Maxwell drowns at sea', CAST(0x0000830900000000 AS DateTime), N'Robert Maxwell drowns at sea', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (397, N'European Union formed by The Maastricht Treaty', CAST(0x0000836700000000 AS DateTime), N'European Union formed by The Maastricht Treaty [see 1993]', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (398, N'Betty Boothroyd elected as first female Speaker', CAST(0x000083B200000000 AS DateTime), N'Betty Boothroyd elected as first female Speaker of the House of Commons', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (399, N'Football Premier League kicks off in England', CAST(0x0000842500000000 AS DateTime), N'Football Premier League kicks off in England', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (400, N'''Black Wednesday'' as Pound leaves the ERM', CAST(0x0000844500000000 AS DateTime), N'''Black Wednesday'' as Pound leaves the ERM', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (401, N'Fire breaks out in Windsor Castle', CAST(0x0000848600000000 AS DateTime), N'Fire breaks out in Windsor Castle causing over £50 million worth of damage', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (402, N'Church of England ordains its first female priests', CAST(0x0000866300000000 AS DateTime), N'Church of England ordains its first female priests', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (403, N'Channel Tunnel open to traffic', CAST(0x0000869A00000000 AS DateTime), N'Channel Tunnel open to traffic', 17)
GO
print 'Processed 400 total records'
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (404, N'National Lottery starts', CAST(0x0000875F00000000 AS DateTime), N'National Lottery starts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (405, N'Nick Leeson brings down Barings', CAST(0x000087C200000000 AS DateTime), N'Nick Leeson brings down Barings', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (406, N'First item sold on Amazon.com', CAST(0x0000884D00000000 AS DateTime), N'First item sold on Amazon.com', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (407, N'The Queen Mother has a hip replacement', CAST(0x000088C900000000 AS DateTime), N'The Queen Mother has a hip replacement operation at 95 years old', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (408, N'Toy Story released', CAST(0x000088CF00000000 AS DateTime), N'Toy Story released – first feature-length film created completely using computer-generated imagery', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (409, N'Galileo spacecraft arrives at Jupiter', CAST(0x000088DE00000000 AS DateTime), N'Galileo spacecraft arrives at Jupiter (launched from shuttle 18 Oct 1989)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (410, N'IRA bomb explodes in London Docklands', CAST(0x0000891E00000000 AS DateTime), N'IRA bomb explodes in London Docklands – ends 17 month ceasefire', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (411, N'Dunblane massacre', CAST(0x0000893F00000000 AS DateTime), N'Dunblane massacre', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (412, N'IRA bomb explodes in Manchester', CAST(0x0000899D00000000 AS DateTime), N'IRA bomb explodes in Manchester', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (413, N'Scientists in Scotland clone a sheep (Dolly)', CAST(0x000089B100000000 AS DateTime), N'Scientists in Scotland clone a sheep (Dolly)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (414, N'Princess of Wales divorced', CAST(0x000089E700000000 AS DateTime), N'Charles, Prince of Wales and Diana, Princess of Wales are divorced', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (415, N'Channel 5 TV begins in UK', CAST(0x00008ABD00000000 AS DateTime), N'Channel 5 TV begins in UK (launched by the Spice Girls)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (416, N'Hale-Bopp comet at its brightest', CAST(0x00008ABF00000000 AS DateTime), N'Hale-Bopp comet at its brightest', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (417, N'New'' Labour landslide victory in Britain', CAST(0x00008ADD00000000 AS DateTime), N'''New'' Labour landslide victory in Britain (Tony Blair replaces John Major as Prime Minister)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (418, N'Announcement that Bank of England to be made independent', CAST(0x00008AE200000000 AS DateTime), N'Announcement that Bank of England to be made independent of Government control', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (419, N'A computer beats a master at chess', CAST(0x00008AE700000000 AS DateTime), N'First time a computer beats a master at chess (IBM''s Deep Blue v Garry Kasparov)', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (420, N'Publication of first Harry Potter novel', CAST(0x00008B1900000000 AS DateTime), N'Publication of first Harry Potter novel Harry Potter and the Philosopher''s Stone', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (421, N'Hong Kong returned to China', CAST(0x00008B1A00000000 AS DateTime), N'Hong Kong returned to China', 4)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (422, N'Landing by American ''Pathfinder Rover'' on Mars', CAST(0x00008B1D00000000 AS DateTime), N'Landing by American ''Pathfinder Rover'' on Mars', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (423, N'IRA declares a ceasefire', CAST(0x00008B2C00000000 AS DateTime), N'IRA declares a ceasefire', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (424, N'Diana, Princess of Wales killed', CAST(0x00008B5700000000 AS DateTime), N'Diana, Princess of Wales killed in car crash in Paris', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (425, N'Land speed record breaks sound barrier for first time', CAST(0x00008B7000000000 AS DateTime), N'Land speed record breaks sound barrier for first time – Wing Commander Andy Green in Thrust SSC at Black Rock Desert, USA', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (426, N'Good Friday peace agreement in Northern Ireland', CAST(0x00008C3500000000 AS DateTime), N'Good Friday peace agreement in Northern Ireland – effectively implemented in May 2007', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (427, N'Car bomb explodes in Omagh', CAST(0x00008CB300000000 AS DateTime), N'Car bomb explodes in Omagh killing 29 people', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (428, N'Google search engine founded', CAST(0x00008CDF00000000 AS DateTime), N'Google search engine founded', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (429, N'First module of the International Space Station launched', CAST(0x00008D1500000000 AS DateTime), N'First module of the International Space Station launched', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (430, N'US President Bill Clinton is impeached', CAST(0x00008D3200000000 AS DateTime), N'US President Bill Clinton is impeached over Monica Lewinsky scandal', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (431, N'European Monetary Union begins', CAST(0x00008D3F00000000 AS DateTime), N'European Monetary Union begins – UK opts out – by the end of the year the Euro has approximately the same value as the US Dollar', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (432, N'The Scottish Parliament is opened', CAST(0x00008DF400000000 AS DateTime), N'The Scottish Parliament is officially opened by Queen Elizabeth – powers are officially transferred from the Scottish Office in London to the new devolved Scottish Executive in Edinburgh', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (433, N'Total eclipse of the sun', CAST(0x00008E1D00000000 AS DateTime), N'Total eclipse of the sun visible in Devon and Cornwall', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (434, N'Hereditary Peers no longer have right to sit in House of Lords', CAST(0x00008E7900000000 AS DateTime), N'Hereditary Peers no longer have right to sit in House of Lords', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (435, N'A new millennium starts', CAST(0x00008EAC00000000 AS DateTime), N'A new millennium starts', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (436, N'The Big Number Change', CAST(0x00008F1C00000000 AS DateTime), N'The Big Number Change takes place in the UK – affected telephone dialling codes assigned to Cardiff, Coventry, London, Northern Ireland, Portsmouth and Southampton', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (437, N'Ken Livingstone elected first Mayor of London', CAST(0x00008F2800000000 AS DateTime), N'Ken Livingstone elected first Mayor of London (not to be confused with Lord Mayor of London!)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (438, N'Millennium footbridge opens for first time', CAST(0x00008F4D00000000 AS DateTime), N'Millennium footbridge over the Thames opens, but wobbles and is quickly declared dangerous and closed – finally reopened Feb 2002', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (439, N'A chartered Air France Concorde crashes', CAST(0x00008F7A00000000 AS DateTime), N'A chartered Air France Concorde crashes on take-off at Paris with loss of all lives – debris on the runway blamed for causing fuel to escape and catch fire, and all Concordes grounded until 7 November 2001', 6)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (440, N'Derailment at Hatfield', CAST(0x00008FCE00000000 AS DateTime), N'Derailment at speed on the main London-North eastern line at Hatfield caused by a broken rail – Railtrack put restrictions on the rest of the network while all other suspect locations were checked', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (441, N'First crew arrive at the International Space Station', CAST(0x00008FDE00000000 AS DateTime), N'First crew arrive at the International Space Station.', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (442, N'New Prayer Book introduced in Anglican Church', CAST(0x00008FEA00000000 AS DateTime), N'New Prayer Book introduced in Anglican Church', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (443, N'Mir space station successfully ditched in the Pacific', CAST(0x0000906B00000000 AS DateTime), N'Mir space station successfully ditched in the Pacific', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (444, N'UK Census Day', CAST(0x0000909000000000 AS DateTime), N'UK Census Day', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (445, N'FA Cup Final played at the Millennium Stadium in Cardiff', CAST(0x0000909D00000000 AS DateTime), N'FA Cup Final played at the Millennium Stadium in Cardiff – first time away from Wembley since 1922', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (446, N'New-style number plates on road vehicles in UK', CAST(0x0000910D00000000 AS DateTime), N'New-style number plates on road vehicles in UK [eg. AB 51 ABC]', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (447, N'Massive terrorist attack on the United States', CAST(0x0000911700000000 AS DateTime), N'Massive terrorist attack on the United States – commercial planes hi-jacked and crashed into the twin towers of the World Trade Centre (destroying it) and one section of the Pentagon', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (448, N'Concorde flights resume', CAST(0x0000915000000000 AS DateTime), N'Concorde flights resume after modifications to tyres and fuel tanks (see 2003)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (449, N'The Leaning Tower of Pisa reopens', CAST(0x0000917600000000 AS DateTime), N'The Leaning Tower of Pisa reopens after 11 years, still leaning', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (450, N'Euro launched', CAST(0x0000918700000000 AS DateTime), N'Twelve major countries in Europe (Austria, Belgium, Holland, Irish Republic, Italy, Luxembourg, Finland, France, Germany, Greece, Spain, Portugal) and their dependents start using the Euro instead of their old national currencies', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (451, N'UK 1901 census details available', CAST(0x0000918800000000 AS DateTime), N'UK 1901 census details available', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (452, N'Millennium Bridge over the Thames in London finally opens', CAST(0x000091BB00000000 AS DateTime), N'Millennium Bridge over the Thames in London finally opens', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (453, N'The Queen Mother dies, aged 101 years', CAST(0x000091DF00000000 AS DateTime), N'The Queen Mother dies, aged 101 years', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (454, N'Two Bank Holidays declared in UK', CAST(0x0000922000000000 AS DateTime), N'Two Bank Holidays declared in UK to celebrate the Queen''s Golden Jubilee', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (455, N'Steve Fossett flies nonstop round world in balloon', CAST(0x0000923D00000000 AS DateTime), N'Steve Fossett becomes the first person to fly solo around the world nonstop in a balloon', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (456, N'Space Shuttle Columbia disintegrates', CAST(0x0000931300000000 AS DateTime), N'Space Shuttle Columbia disintegrates during re-entry, killing all seven astronauts aboard', 18)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (457, N'Start of Congestion Charge for London', CAST(0x0000932300000000 AS DateTime), N'Start of Congestion Charge for traffic entering central London', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (458, N'Temperatures reach record high', CAST(0x000093D100000000 AS DateTime), N'Temperatures reach record high of 101 F (38.3 C) in Kent', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (459, N'Last commercial flight of Concorde', CAST(0x0000941C00000000 AS DateTime), N'Last commercial flight of Concorde', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (460, N'England wins Rugby World Cup', CAST(0x0000943900000000 AS DateTime), N'England wins Rugby World Cup in nail-biting final in Australia – first northern hemisphere team to do this', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (461, N'Saddam Hussein captured', CAST(0x0000944E00000000 AS DateTime), N'Saddam Hussein captured near his home town of Tikrit (executed 30 Dec 2006)', 9)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (462, N'Queen Mary 2 arrives in Southampton', CAST(0x0000945B00000000 AS DateTime), N'Queen Mary 2 arrives in Southampton from the builder''s yard in France', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (463, N'Alistair Cooke dies', CAST(0x000094B900000000 AS DateTime), N'Alistair Cooke dies at the age of 95 – until four weeks previously, and since 1946, he had broadcast his regular ''Letter from America'' on BBC radio', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (464, N'Ireland bans smoking', CAST(0x000094B900000000 AS DateTime), N'Ireland becomes first country in the world to ban smoking in public places', 10)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (465, N'Enlargement of the European Union', CAST(0x000094DA00000000 AS DateTime), N'Enlargement of the European Union to include 25 members by the entry of 10 new states: Estonia, Latvia, Lithuania, Poland, Czech Republic, Slovakia, Hungary, Slovenia, Malta, Cyprus.', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (466, N'Kyoto Protocol starts', CAST(0x000095FD00000000 AS DateTime), N'Kyoto Protocol on climate change came into force', 12)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (467, N'Ban on hunting with dogs', CAST(0x000095FF00000000 AS DateTime), N'Ban on hunting with dogs came into force in England & Wales (had already been a similar law for about two years in Scotland)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (468, N'Death of Pope John Paul II', CAST(0x0000962A00000000 AS DateTime), N'Death of Pope John Paul II, first non-Italian Pope for 450 years when elected in 1978', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (469, N'Pope Benedict XVI elected', CAST(0x0000963B00000000 AS DateTime), N'Pope Benedict XVI elected – first German Pope for about 1,000 years', 11)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (470, N'London chosen as venue for the 2012 Olympic Games', CAST(0x0000968900000000 AS DateTime), N'London chosen as venue for the 2012 Olympic Games', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (471, N'Suicide bombers attack London for the first time', CAST(0x0000968A00000000 AS DateTime), N'Suicide bombers attack London for the first time', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (472, N'IRA declare an end to their ''armed struggle''', CAST(0x0000969F00000000 AS DateTime), N'IRA declare an end to their ''armed struggle''', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (473, N'England regain the ''Ashes''', CAST(0x000096CD00000000 AS DateTime), N'England regain the ''Ashes'' after a gripping Test series (but are whitewashed 5-0 in the return series in Australia 2007)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (474, N'Angela Merkel becomes first female Chancellor of Germany', CAST(0x0000971400000000 AS DateTime), N'Angela Merkel becomes first female Chancellor of Germany', 7)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (475, N'John Sentamu becomes Archbishop of York', CAST(0x0000971C00000000 AS DateTime), N'John Sentamu becomes Archbishop of York; the first black archbishop in the Church of England', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (476, N'Last Routemaster bus runs', CAST(0x0000972500000000 AS DateTime), N'Last Routemaster bus runs on regular service in London (see 1954)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (477, N'Explosions at the Buncefield Oil Depot', CAST(0x0000972700000000 AS DateTime), N'Explosions at the Buncefield Oil Depot in Hemel Hempstead', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (478, N'Same-sex civil partnerships begin', CAST(0x0000973100000000 AS DateTime), N'Same-sex civil partnerships begin – famously, on this day, between Elton John and David Furnish', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (479, N'Welsh Assembly Building opened', CAST(0x0000977700000000 AS DateTime), N'Welsh Assembly Building opened by the Queen', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (480, N'Prohibition of smoking in Scotland', CAST(0x0000979000000000 AS DateTime), N'Prohibition of smoking in enclosed public places in Scotland', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (481, N'80th birthday of Queen Elizabeth II', CAST(0x000097AA00000000 AS DateTime), N'80th birthday of Queen Elizabeth II', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (482, N'UK postage rates start to be measured by size as well as by weight', CAST(0x0000982400000000 AS DateTime), N'UK postage rates start to be measured by size as well as by weight', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (483, N'Saddam Hussein executed', CAST(0x000098A700000000 AS DateTime), N'Saddam Hussein executed', 9)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (484, N'Further enlargement of the European Union', CAST(0x000098A900000000 AS DateTime), N'Further enlargement of the European Union to include Bulgaria and Romania', 5)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (485, N'Extension of Congestion Charge zone for London, westwards', CAST(0x000098DA00000000 AS DateTime), N'Extension of Congestion Charge zone for London, westwards', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (486, N'A Northern Ireland Executive formed', CAST(0x0000992800000000 AS DateTime), N'A Northern Ireland Executive formed under the leadership of Ian Paisley (DUP) and Martin McGuinness (Sinn Fein)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (487, N'Tony Blair resigns as Prime Minister', CAST(0x0000995A00000000 AS DateTime), N'Tony Blair resigns as Prime Minister after 10 years – replaced by Gordon Brown', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (488, N'Prohibition of smoking in England', CAST(0x0000995E00000000 AS DateTime), N'Prohibition of smoking in enclosed public places in England (thus completing cover of the entire UK)', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (489, N'Seventh and final Harry Potter book released', CAST(0x0000997200000000 AS DateTime), N'Seventh and final Harry Potter book released', 17)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (490, N'First commercial flight of Airbus A380', CAST(0x000099D200000000 AS DateTime), N'First commercial flight of Airbus A380 (Singapore to Sydney)', 19)
INSERT [dbo].[tblEvent] ([EventId], [EventName], [EventDate], [Description], [CountryId]) VALUES (491, N'First rail service direct from St Pancras to France', CAST(0x000099E600000000 AS DateTime), N'First rail service direct from St Pancras to France (replacing that from Waterloo)', 17)
SET IDENTITY_INSERT [dbo].[tblEvent] OFF
/****** Object: ForeignKey [FK_tblEvent_tblCountry] Script Date: 02/08/2010 09:49:47 ******/
ALTER TABLE [dbo].[tblEvent] WITH CHECK ADD CONSTRAINT [FK_tblEvent_tblCountry] FOREIGN KEY([CountryId])
REFERENCES [dbo].[tblCountry] ([CountryId])
GO
ALTER TABLE [dbo].[tblEvent] CHECK CONSTRAINT [FK_tblEvent_tblCountry]
GO