zqQiG5P2

· 9 years ago · Oct 10, 2016, 07:02 AM
1CREATE DATABASE Zyryanov_Anton 
2GO 
3
4USE Zyryanov_Anton 
5GO 
6
7IF EXISTS( 
8SELECT * 
9FROM sys.schemas 
10WHERE name = N'meteorology' 
11) 
12DROP SCHEMA meteorology 
13GO 
14
15CREATE SCHEMA meteorology 
16GO 
17
18IF OBJECT_ID('Zyryanov_Anton.meteorology.stations', 'U') IS NOT NULL 
19DROP TABLE Zyryanov_Anton.meteorology.stations 
20GO 
21
22CREATE TABLE Zyryanov_Anton.meteorology.stations 
23( 
24station_id int NOT NULL, 
25station_name nvarchar(120) NOT NULL, 
26CONSTRAINT PK_station_id PRIMARY KEY (station_id) 
27) 
28GO 
29
30
31IF OBJECT_ID('Zyryanov_Anton.meteorology.measure_types', 'U') IS NOT NULL 
32DROP TABLE Zyryanov_Anton.meteorology.measure_types 
33GO 
34
35CREATE TABLE Zyryanov_Anton.meteorology.measure_types 
36( 
37measure_type_id int NOT NULL, 
38measure_type_name nvarchar(40) NOT NULL, 
39measure_type_units nvarchar(40) NOT NULL, 
40CONSTRAINT PK_measure_type_id PRIMARY KEY (measure_type_id) 
41) 
42GO 
43
44
45IF OBJECT_ID('Zyryanov_Anton.meteorology.measures', 'U') IS NOT NULL 
46DROP TABLE Zyryanov_Anton.meteorology.measures 
47GO 
48CREATE TABLE Zyryanov_Anton.meteorology.measures 
49( 
50station_id int NOT NULL, 
51measure_type_id int NOT NULL, 
52measure_date datetime NOT NULL, 
53measure_value float NOT NULL, 
54comment nvarchar(120) NULL 
55) 
56GO 
57
58ALTER TABLE Zyryanov_Anton.meteorology.measures 
59ALTER COLUMN measure_date datetime  NOT NULL
60GO
61
62ALTER TABLE Zyryanov_Anton.meteorology.measures ADD 
63CONSTRAINT FK_station_id FOREIGN KEY (station_id) 
64REFERENCES Zyryanov_Anton.meteorology.stations(station_id) 
65ON UPDATE CASCADE 
66GO 
67
68ALTER TABLE Zyryanov_Anton.meteorology.measures ADD 
69CONSTRAINT FK_measure_type_id FOREIGN KEY (measure_type_id) 
70REFERENCES Zyryanov_Anton.meteorology.measure_types(measure_type_id) 
71ON UPDATE CASCADE 
72GO 
73
74DELETE from Zyryanov_Anton.meteorology.measure_types
75GO
76
77DELETE from Zyryanov_Anton.meteorology.stations
78GO
79
80DELETE from Zyryanov_Anton.meteorology.measures
81
82INSERT INTO Zyryanov_Anton.meteorology.stations VALUES 
83(1, N'ÐŸÐµÑ€Ð²Ð¾ÑƒÑ€Ð°Ð»ÑŒÑÐº'), (2, N'Ð•ÐºÐ°Ñ‚ÐµÑ€Ð¸Ð½Ð±ÑƒÑ€Ð³'), (3, N'ÐÐ»Ð°Ð¿Ð°ÐµÐ²ÑÐº'), (4, N'ÐÐ¾Ð²Ð¾ÑÐ¸Ð±Ð¸Ñ€ÑÐº'), (5, 'Ð›Ð¾Ð½Ð´Ð¾Ð½'), (6, 'ÐœÐ¾ÑÐºÐ²Ð°') 
84GO 
85
86INSERT INTO Zyryanov_Anton.meteorology.measure_types VALUES 
87(1, N'Ð¢ÐµÐ¼Ð¿ÐµÑ€Ð°Ñ‚ÑƒÑ€Ð°', N'Ð³Ñ€Ð°Ð´ÑƒÑÑ‹ Ð¦ÐµÐ»ÑŒÑÐ¸Ñ'), 
88(2, N'Ð’Ð»Ð°Ð¶Ð½Ð¾ÑÑ‚ÑŒ', N'Ð¿Ñ€Ð¾Ñ†ÐµÐ½Ñ‚Ñ‹'), 
89(3, N'Ð”Ð°Ð²Ð»ÐµÐ½Ð¸Ðµ', N'Ð¼Ð¼ Ñ€Ñ‚.ÑÑ‚.'), 
90(4, N'ÐÐ°Ð¿Ñ€Ð°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð²ÐµÑ‚Ñ€Ð°', N'ÑƒÐ³Ð¾Ð»'), 
91(5, N'Ð¡ÐºÐ¾Ñ€Ð¾ÑÑ‚ÑŒ Ð²ÐµÑ‚Ñ€Ð°', N'Ð¼/Ñ'), 
92(6, N'ÐžÑÐ°Ð´ÐºÐ¸', N'Ð¼Ð¼'), 
93(7, N'Ð Ð°Ð´Ð¸Ð°Ñ†Ð¸Ð¾Ð½Ð½Ñ‹Ð¹ Ñ„Ð¾Ð½', N'Ð¼ÐºÐ /Ñ‡'); 
94GO 
95
96DELETE FROM Zyryanov_Anton.meteorology.measures
97
98INSERT INTO Zyryanov_Anton.meteorology.measures VALUES 
99(1, 1, '09-10-2014', 10, NULL),
100(1, 2, '09-10-2014', 67, NULL),
101(1, 3, '09-10-2014', 767, NULL),
102(1, 4, '09-10-2014', 243, NULL),
103(1, 5, '09-10-2014', 21, NULL),
104(1, 6, '09-10-2014', 33, NULL),
105(1, 7, '09-10-2014', 67, NULL),
106(2, 1, '09-10-2014', 10, NULL),
107(2, 2, '09-10-2014', 67, NULL),
108(2, 3, '09-10-2014', 767, NULL),
109(2, 4, '09-10-2014', 243, NULL),
110(2, 5, '09-10-2014', 21, NULL),
111(2, 6, '09-10-2014', 33, NULL),
112(2, 7, '09-10-2014', 67, NULL),
113(3, 1, '09-10-2014', 10, NULL),
114(3, 2, '09-10-2014', 67, NULL),
115(3, 3, '09-10-2014', 767, NULL),
116(3, 4, '09-10-2014', 243, NULL),
117(3, 5, '09-10-2014', 21, NULL),
118(3, 6, '09-10-2014', 33, NULL),
119(3, 7, '09-10-2014', 67, NULL),
120(4, 1, '09-10-2014', 10, NULL),
121(4, 2, '09-10-2014', 67, NULL),
122(4, 3, '09-10-2014', 767, NULL),
123(4, 4, '09-10-2014', 243, NULL),
124(4, 5, '09-10-2014', 21, NULL),
125(4, 6, '09-10-2014', 33, NULL),
126(4, 7, '09-10-2014', 67, NULL),
127(5, 1, '09-10-2014', 10, NULL),
128(5, 2, '09-10-2014', 67, NULL),
129(5, 3, '09-10-2014', 767, NULL),
130(5, 4, '09-10-2014', 243, NULL),
131(5, 5, '09-10-2014', 21, NULL),
132(5, 6, '09-10-2014', 33, NULL),
133(5, 7, '09-10-2014', 67, NULL),
134(6, 1, '09-10-2014', 10, NULL),
135(6, 2, '09-10-2014', 67, NULL),
136(6, 3, '09-10-2014', 767, NULL),
137(6, 4, '09-10-2014', 243, NULL),
138(6, 5, '09-10-2014', 21, NULL),
139(6, 6, '09-10-2014', 33, NULL),
140(6, 7, '09-10-2014', 67, NULL),
141(1, 1, '09-10-2014', 10, NULL),
142(1, 2, '09-10-2014', 67, NULL),
143(1, 3, '09-10-2014', 767, NULL),
144(1, 4, '09-10-2014', 243, NULL),
145(1, 5, '09-10-2014', 21, NULL),
146(1, 6, '09-10-2014', 33, NULL),
147(1, 7, '09-10-2014', 67, NULL),
148(2, 1, '09-10-2014', 10, NULL),
149(2, 2, '09-10-2014', 67, NULL),
150(2, 3, '09-10-2014', 767, NULL),
151(2, 4, '09-10-2014', 243, NULL),
152(2, 5, '09-10-2014', 21, NULL),
153(2, 6, '09-10-2014', 33, NULL),
154(2, 7, '09-10-2014', 67, NULL),
155(3, 1, '09-10-2014', 10, NULL),
156(3, 2, '09-10-2014', 67, NULL),
157(3, 3, '09-10-2014', 767, NULL),
158(3, 4, '09-10-2014', 243, NULL),
159(3, 5, '09-10-2014', 21, NULL),
160(3, 6, '09-10-2014', 33, NULL),
161(3, 7, '09-10-2014', 67, NULL),
162(4, 1, '09-10-2014', 10, NULL),
163(4, 2, '09-10-2014', 67, NULL),
164(4, 3, '09-10-2014', 767, NULL),
165(4, 4, '09-10-2014', 243, NULL),
166(4, 5, '09-10-2014', 21, NULL),
167(4, 6, '09-10-2014', 33, NULL),
168(4, 7, '09-10-2014', 67, NULL),
169(5, 1, '09-10-2014', 10, NULL),
170(5, 2, '09-10-2014', 67, NULL),
171(5, 3, '09-10-2014', 767, NULL),
172(5, 4, '09-10-2014', 243, NULL),
173(5, 5, '09-10-2014', 21, NULL),
174(5, 6, '09-10-2014', 33, NULL),
175(5, 7, '09-10-2014', 67, NULL),
176(6, 1, '09-10-2014', 10, NULL),
177(6, 2, '09-10-2014', 67, NULL),
178(6, 3, '09-10-2014', 767, NULL),
179(6, 4, '09-10-2014', 243, NULL),
180(6, 5, '09-10-2014', 21, NULL),
181(6, 6, '09-10-2014', 33, NULL),
182(6, 7, '09-10-2014', 67, NULL),
183(1, 1, '09-10-2014', 10, NULL),
184(1, 2, '09-10-2014', 67, NULL),
185(1, 3, '09-10-2014', 767, NULL),
186(1, 4, '09-10-2014', 243, NULL),
187(1, 5, '09-10-2014', 21, NULL),
188(1, 6, '09-10-2014', 33, NULL),
189(1, 7, '09-10-2014', 67, NULL),
190(2, 1, '09-10-2014', 10, NULL),
191(2, 2, '09-10-2014', 67, NULL),
192(2, 3, '09-10-2014', 767, NULL),
193(2, 4, '09-10-2014', 243, NULL),
194(2, 5, '09-10-2014', 21, NULL),
195(2, 6, '09-10-2014', 33, NULL),
196(2, 7, '09-10-2014', 67, NULL),
197(3, 1, '09-10-2014', 10, NULL),
198(3, 2, '09-10-2014', 67, NULL),
199(3, 3, '09-10-2014', 767, NULL),
200(3, 4, '09-10-2014', 243, NULL),
201(3, 5, '09-10-2014', 21, NULL),
202(3, 6, '09-10-2014', 33, NULL),
203(3, 7, '09-10-2014', 67, NULL),
204(4, 1, '09-10-2014', 10, NULL),
205(4, 2, '09-10-2014', 67, NULL),
206(4, 3, '09-10-2014', 767, NULL),
207(4, 4, '09-10-2014', 243, NULL),
208(4, 5, '09-10-2014', 21, NULL),
209(4, 6, '09-10-2014', 33, NULL),
210(4, 7, '09-10-2014', 67, NULL),
211(5, 1, '09-10-2014', 10, NULL),
212(5, 2, '09-10-2014', 67, NULL),
213(5, 3, '09-10-2014', 767, NULL),
214(5, 4, '09-10-2014', 243, NULL),
215(5, 5, '09-10-2014', 21, NULL),
216(5, 6, '09-10-2014', 33, NULL),
217(5, 7, '09-10-2014', 67, NULL),
218(6, 1, '09-10-2014', 10, NULL),
219(6, 2, '09-10-2014', 67, NULL),
220(6, 3, '09-10-2014', 767, NULL),
221(6, 4, '09-10-2014', 243, NULL),
222(6, 5, '09-10-2014', 21, NULL),
223(6, 6, '09-10-2014', 33, NULL),
224(6, 7, '09-10-2014', 67, NULL),
225(1, 1, '09-10-2014', 10, NULL),
226(1, 2, '09-10-2014', 67, NULL),
227(1, 3, '09-10-2014', 767, NULL),
228(1, 4, '09-10-2014', 243, NULL),
229(1, 5, '09-10-2014', 21, NULL),
230(1, 6, '09-10-2014', 33, NULL),
231(1, 7, '09-10-2014', 67, NULL),
232(2, 1, '09-10-2014', 10, NULL),
233(2, 2, '09-10-2014', 67, NULL),
234(2, 3, '09-10-2014', 767, NULL),
235(2, 4, '09-10-2014', 243, NULL),
236(2, 5, '09-10-2014', 21, NULL),
237(2, 6, '09-10-2014', 33, NULL),
238(2, 7, '09-10-2014', 67, NULL),
239(3, 1, '09-10-2014', 10, NULL),
240(3, 2, '09-10-2014', 67, NULL),
241(3, 3, '09-10-2014', 767, NULL),
242(3, 4, '09-10-2014', 243, NULL),
243(3, 5, '09-10-2014', 21, NULL),
244(3, 6, '09-10-2014', 33, NULL),
245(3, 7, '09-10-2014', 67, NULL),
246(4, 1, '09-10-2014', 10, NULL),
247(4, 2, '09-10-2014', 67, NULL),
248(4, 3, '09-10-2014', 767, NULL),
249(4, 4, '09-10-2014', 243, NULL),
250(4, 5, '09-10-2014', 21, NULL),
251(4, 6, '09-10-2014', 33, NULL),
252(4, 7, '09-10-2014', 67, NULL),
253(5, 1, '09-10-2014', 10, NULL),
254(5, 2, '09-10-2014', 67, NULL),
255(5, 3, '09-10-2014', 767, NULL),
256(5, 4, '09-10-2014', 243, NULL),
257(5, 5, '09-10-2014', 21, NULL),
258(5, 6, '09-10-2014', 33, NULL),
259(5, 7, '09-10-2014', 67, NULL),
260(6, 1, '09-10-2014', 10, NULL),
261(6, 2, '09-10-2014', 67, NULL),
262(6, 3, '09-10-2014', 767, NULL),
263(6, 4, '09-10-2014', 243, NULL),
264(6, 5, '09-10-2014', 21, NULL),
265(6, 6, '09-10-2014', 33, NULL),
266(6, 7, '09-10-2014', 67, NULL),
267(1, 1, '09-10-2014', 10, NULL),
268(1, 2, '09-10-2014', 67, NULL),
269(1, 3, '09-10-2014', 767, NULL),
270(1, 4, '09-10-2014', 243, NULL),
271(1, 5, '09-10-2014', 21, NULL),
272(1, 6, '09-10-2014', 33, NULL),
273(1, 7, '09-10-2014', 67, NULL),
274(2, 1, '09-10-2014', 10, NULL),
275(2, 2, '09-10-2014', 67, NULL),
276(2, 3, '09-10-2014', 767, NULL),
277(2, 4, '09-10-2014', 243, NULL),
278(2, 5, '09-10-2014', 21, NULL),
279(2, 6, '09-10-2014', 33, NULL),
280(2, 7, '09-10-2014', 67, NULL),
281(3, 1, '09-10-2014', 10, NULL),
282(3, 2, '09-10-2014', 67, NULL),
283(3, 3, '09-10-2014', 767, NULL),
284(3, 4, '09-10-2014', 243, NULL),
285(3, 5, '09-10-2014', 21, NULL),
286(3, 6, '09-10-2014', 33, NULL),
287(3, 7, '09-10-2014', 67, NULL),
288(4, 1, '09-10-2014', 10, NULL),
289(4, 2, '09-10-2014', 67, NULL),
290(4, 3, '09-10-2014', 767, NULL),
291(4, 4, '09-10-2014', 243, NULL),
292(4, 5, '09-10-2014', 21, NULL),
293(4, 6, '09-10-2014', 33, NULL),
294(4, 7, '09-10-2014', 67, NULL),
295(5, 1, '09-10-2014', 10, NULL),
296(5, 2, '09-10-2014', 67, NULL),
297(5, 3, '09-10-2014', 767, NULL),
298(5, 4, '09-10-2014', 243, NULL),
299(5, 5, '09-10-2014', 21, NULL),
300(5, 6, '09-10-2014', 33, NULL),
301(5, 7, '09-10-2014', 67, NULL),
302(6, 1, '09-10-2014', 10, NULL),
303(6, 2, '09-10-2014', 67, NULL),
304(6, 3, '09-10-2014', 767, NULL),
305(6, 4, '09-10-2014', 243, NULL),
306(6, 5, '09-10-2014', 21, NULL),
307(6, 6, '09-10-2014', 33, NULL),
308(6, 7, '09-10-2014', 67, NULL),
309(1, 1, '09-10-2014', 10, NULL),
310(1, 2, '09-10-2014', 67, NULL),
311(1, 3, '09-10-2014', 767, NULL),
312(1, 4, '09-10-2014', 243, NULL),
313(1, 5, '09-10-2014', 21, NULL),
314(1, 6, '09-10-2014', 33, NULL),
315(1, 7, '09-10-2014', 67, NULL),
316(2, 1, '09-10-2014', 10, NULL),
317(2, 2, '09-10-2014', 67, NULL),
318(2, 3, '09-10-2014', 767, NULL),
319(2, 4, '09-10-2014', 243, NULL),
320(2, 5, '09-10-2014', 21, NULL),
321(2, 6, '09-10-2014', 33, NULL),
322(2, 7, '09-10-2014', 67, NULL),
323(3, 1, '09-10-2014', 10, NULL),
324(3, 2, '09-10-2014', 67, NULL),
325(3, 3, '09-10-2014', 767, NULL),
326(3, 4, '09-10-2014', 243, NULL),
327(3, 5, '09-10-2014', 21, NULL),
328(3, 6, '09-10-2014', 33, NULL),
329(3, 7, '09-10-2014', 67, NULL),
330(4, 1, '09-10-2014', 10, NULL),
331(4, 2, '09-10-2014', 67, NULL),
332(4, 3, '09-10-2014', 767, NULL),
333(4, 4, '09-10-2014', 243, NULL),
334(4, 5, '09-10-2014', 21, NULL),
335(4, 6, '09-10-2014', 33, NULL),
336(4, 7, '09-10-2014', 67, NULL),
337(5, 1, '09-10-2014', 10, NULL),
338(5, 2, '09-10-2014', 67, NULL),
339(5, 3, '09-10-2014', 767, NULL),
340(5, 4, '09-10-2014', 243, NULL),
341(5, 5, '09-10-2014', 21, NULL),
342(5, 6, '09-10-2014', 33, NULL),
343(5, 7, '09-10-2014', 67, NULL),
344(6, 1, '09-10-2014', 10, NULL),
345(6, 2, '09-10-2014', 67, NULL),
346(6, 3, '09-10-2014', 767, NULL),
347(6, 4, '09-10-2014', 243, NULL),
348(6, 5, '09-10-2014', 21, NULL),
349(6, 6, '09-10-2014', 33, NULL),
350(6, 7, '09-10-2014', 67, NULL),
351(1, 1, '09-10-2014', 10, NULL),
352(1, 2, '09-10-2014', 67, NULL),
353(1, 3, '09-10-2014', 767, NULL),
354(1, 4, '09-10-2014', 243, NULL),
355(1, 5, '09-10-2014', 21, NULL),
356(1, 6, '09-10-2014', 33, NULL),
357(1, 7, '09-10-2014', 67, NULL),
358(2, 1, '09-10-2014', 10, NULL),
359(2, 2, '09-10-2014', 67, NULL),
360(2, 3, '09-10-2014', 767, NULL),
361(2, 4, '09-10-2014', 243, NULL),
362(2, 5, '09-10-2014', 21, NULL),
363(2, 6, '09-10-2014', 33, NULL),
364(2, 7, '09-10-2014', 67, NULL),
365(3, 1, '09-10-2014', 10, NULL),
366(3, 2, '09-10-2014', 67, NULL),
367(3, 3, '09-10-2014', 767, NULL),
368(3, 4, '09-10-2014', 243, NULL),
369(3, 5, '09-10-2014', 21, NULL),
370(3, 6, '09-10-2014', 33, NULL),
371(3, 7, '09-10-2014', 67, NULL),
372(4, 1, '09-10-2014', 10, NULL),
373(4, 2, '09-10-2014', 67, NULL),
374(4, 3, '09-10-2014', 767, NULL),
375(4, 4, '09-10-2014', 243, NULL),
376(4, 5, '09-10-2014', 21, NULL),
377(4, 6, '09-10-2014', 33, NULL),
378(4, 7, '09-10-2014', 67, NULL),
379(5, 1, '09-10-2014', 10, NULL),
380(5, 2, '09-10-2014', 67, NULL),
381(5, 3, '09-10-2014', 767, NULL),
382(5, 4, '09-10-2014', 243, NULL),
383(5, 5, '09-10-2014', 21, NULL),
384(5, 6, '09-10-2014', 33, NULL),
385(5, 7, '09-10-2014', 67, NULL),
386(6, 1, '09-10-2014', 10, NULL),
387(6, 2, '09-10-2014', 67, NULL),
388(6, 3, '09-10-2014', 767, NULL),
389(6, 4, '09-10-2014', 243, NULL),
390(6, 5, '09-10-2014', 21, NULL),
391(6, 6, '09-10-2014', 33, NULL),
392(6, 7, '09-10-2014', 67, NULL),
393(1, 1, '09-10-2014', 10, NULL),
394(1, 2, '09-10-2014', 67, NULL),
395(1, 3, '09-10-2014', 767, NULL),
396(1, 4, '09-10-2014', 243, NULL),
397(1, 5, '09-10-2014', 21, NULL),
398(1, 6, '09-10-2014', 33, NULL),
399(1, 7, '09-10-2014', 67, NULL),
400(2, 1, '09-10-2014', 10, NULL),
401(2, 2, '09-10-2014', 67, NULL),
402(2, 3, '09-10-2014', 767, NULL),
403(2, 4, '09-10-2014', 243, NULL),
404(2, 5, '09-10-2014', 21, NULL),
405(2, 6, '09-10-2014', 33, NULL),
406(2, 7, '09-10-2014', 67, NULL),
407(3, 1, '09-10-2014', 10, NULL),
408(3, 2, '09-10-2014', 67, NULL),
409(3, 3, '09-10-2014', 767, NULL),
410(3, 4, '09-10-2014', 243, NULL),
411(3, 5, '09-10-2014', 21, NULL),
412(3, 6, '09-10-2014', 33, NULL),
413(3, 7, '09-10-2014', 67, NULL),
414(4, 1, '09-10-2014', 10, NULL),
415(4, 2, '09-10-2014', 67, NULL),
416(4, 3, '09-10-2014', 767, NULL),
417(4, 4, '09-10-2014', 243, NULL),
418(4, 5, '09-10-2014', 21, NULL),
419(4, 6, '09-10-2014', 33, NULL),
420(4, 7, '09-10-2014', 67, NULL),
421(5, 1, '09-10-2014', 10, NULL),
422(5, 2, '09-10-2014', 67, NULL),
423(5, 3, '09-10-2014', 767, NULL),
424(5, 4, '09-10-2014', 243, NULL),
425(5, 5, '09-10-2014', 21, NULL),
426(5, 6, '09-10-2014', 33, NULL),
427(5, 7, '09-10-2014', 67, NULL),
428(6, 1, '09-10-2014', 10, NULL),
429(6, 2, '09-10-2014', 67, NULL),
430(6, 3, '09-10-2014', 767, NULL),
431(6, 4, '09-10-2014', 243, NULL),
432(6, 5, '09-10-2014', 21, NULL),
433(6, 6, '09-10-2014', 33, NULL),
434(6, 7, '09-10-2014', 67, NULL),
435(1, 1, '09-10-2014', 10, NULL),
436(1, 2, '09-10-2014', 67, NULL),
437(1, 3, '09-10-2014', 767, NULL),
438(1, 4, '09-10-2014', 243, NULL),
439(1, 5, '09-10-2014', 21, NULL),
440(1, 6, '09-10-2014', 33, NULL),
441(1, 7, '09-10-2014', 67, NULL),
442(2, 1, '09-10-2014', 10, NULL),
443(2, 2, '09-10-2014', 67, NULL),
444(2, 3, '09-10-2014', 767, NULL),
445(2, 4, '09-10-2014', 243, NULL),
446(2, 5, '09-10-2014', 21, NULL),
447(2, 6, '09-10-2014', 33, NULL),
448(2, 7, '09-10-2014', 67, NULL),
449(3, 1, '09-10-2014', 10, NULL),
450(3, 2, '09-10-2014', 67, NULL),
451(3, 3, '09-10-2014', 767, NULL),
452(3, 4, '09-10-2014', 243, NULL),
453(3, 5, '09-10-2014', 21, NULL),
454(3, 6, '09-10-2014', 33, NULL),
455(3, 7, '09-10-2014', 67, NULL),
456(4, 1, '09-10-2014', 10, NULL),
457(4, 2, '09-10-2014', 67, NULL),
458(4, 3, '09-10-2014', 767, NULL),
459(4, 4, '09-10-2014', 243, NULL),
460(4, 5, '09-10-2014', 21, NULL),
461(4, 6, '09-10-2014', 33, NULL),
462(4, 7, '09-10-2014', 67, NULL),
463(5, 1, '09-10-2014', 10, NULL),
464(5, 2, '09-10-2014', 67, NULL),
465(5, 3, '09-10-2014', 767, NULL),
466(5, 4, '09-10-2014', 243, NULL),
467(5, 5, '09-10-2014', 21, NULL),
468(5, 6, '09-10-2014', 33, NULL),
469(5, 7, '09-10-2014', 67, NULL),
470(6, 1, '09-10-2014', 10, NULL),
471(6, 2, '09-10-2014', 67, NULL),
472(6, 3, '09-10-2014', 767, NULL),
473(6, 4, '09-10-2014', 243, NULL),
474(6, 5, '09-10-2014', 21, NULL),
475(6, 6, '09-10-2014', 33, NULL),
476(6, 7, '09-10-2014', 67, NULL),
477(1, 1, '09-10-2014', 10, NULL),
478(1, 2, '09-10-2014', 67, NULL),
479(1, 3, '09-10-2014', 767, NULL),
480(1, 4, '09-10-2014', 243, NULL),
481(1, 5, '09-10-2014', 21, NULL),
482(1, 6, '09-10-2014', 33, NULL),
483(1, 7, '09-10-2014', 67, NULL),
484(2, 1, '09-10-2014', 10, NULL),
485(2, 2, '09-10-2014', 67, NULL),
486(2, 3, '09-10-2014', 767, NULL),
487(2, 4, '09-10-2014', 243, NULL),
488(2, 5, '09-10-2014', 21, NULL),
489(2, 6, '09-10-2014', 33, NULL),
490(2, 7, '09-10-2014', 67, NULL),
491(3, 1, '09-10-2014', 10, NULL),
492(3, 2, '09-10-2014', 67, NULL),
493(3, 3, '09-10-2014', 767, NULL),
494(3, 4, '09-10-2014', 243, NULL),
495(3, 5, '09-10-2014', 21, NULL),
496(3, 6, '09-10-2014', 33, NULL),
497(3, 7, '09-10-2014', 67, NULL),
498(4, 1, '09-10-2014', 10, NULL),
499(4, 2, '09-10-2014', 67, NULL),
500(4, 3, '09-10-2014', 767, NULL),
501(4, 4, '09-10-2014', 243, NULL),
502(4, 5, '09-10-2014', 21, NULL),
503(4, 6, '09-10-2014', 33, NULL),
504(4, 7, '09-10-2014', 67, NULL),
505(5, 1, '09-10-2014', 10, NULL),
506(5, 2, '09-10-2014', 67, NULL),
507(5, 3, '09-10-2014', 767, NULL),
508(5, 4, '09-10-2014', 243, NULL),
509(5, 5, '09-10-2014', 21, NULL),
510(5, 6, '09-10-2014', 33, NULL),
511(5, 7, '09-10-2014', 67, NULL),
512(6, 1, '09-10-2014', 10, NULL),
513(6, 2, '09-10-2014', 67, NULL),
514(6, 3, '09-10-2014', 767, NULL),
515(6, 4, '09-10-2014', 243, NULL),
516(6, 5, '09-10-2014', 21, NULL),
517(6, 6, '09-10-2014', 33, NULL),
518(6, 7, '09-10-2014', 67, NULL),
519(1, 1, '09-10-2014', 10, NULL),
520(1, 2, '09-10-2014', 67, NULL),
521(1, 3, '09-10-2014', 767, NULL),
522(1, 4, '09-10-2014', 243, NULL),
523(1, 5, '09-10-2014', 21, NULL),
524(1, 6, '09-10-2014', 33, NULL),
525(1, 7, '09-10-2014', 67, NULL),
526(2, 1, '09-10-2014', 10, NULL),
527(2, 2, '09-10-2014', 67, NULL),
528(2, 3, '09-10-2014', 767, NULL),
529(2, 4, '09-10-2014', 243, NULL),
530(2, 5, '09-10-2014', 21, NULL),
531(2, 6, '09-10-2014', 33, NULL),
532(2, 7, '09-10-2014', 67, NULL),
533(3, 1, '09-10-2014', 10, NULL),
534(3, 2, '09-10-2014', 67, NULL),
535(3, 3, '09-10-2014', 767, NULL),
536(3, 4, '09-10-2014', 243, NULL),
537(3, 5, '09-10-2014', 21, NULL),
538(3, 6, '09-10-2014', 33, NULL),
539(3, 7, '09-10-2014', 67, NULL),
540(4, 1, '09-10-2014', 10, NULL),
541(4, 2, '09-10-2014', 67, NULL),
542(4, 3, '09-10-2014', 767, NULL),
543(4, 4, '09-10-2014', 243, NULL),
544(4, 5, '09-10-2014', 21, NULL),
545(4, 6, '09-10-2014', 33, NULL),
546(4, 7, '09-10-2014', 67, NULL),
547(5, 1, '09-10-2014', 10, NULL),
548(5, 2, '09-10-2014', 67, NULL),
549(5, 3, '09-10-2014', 767, NULL),
550(5, 4, '09-10-2014', 243, NULL),
551(5, 5, '09-10-2014', 21, NULL),
552(5, 6, '09-10-2014', 33, NULL),
553(5, 7, '09-10-2014', 67, NULL),
554(6, 1, '09-10-2014', 10, NULL),
555(6, 2, '09-10-2014', 67, NULL),
556(6, 3, '09-10-2014', 767, NULL),
557(6, 4, '09-10-2014', 243, NULL),
558(6, 5, '09-10-2014', 21, NULL),
559(6, 6, '09-10-2014', 33, NULL),
560(6, 7, '09-10-2014', 67, NULL),
561(1, 1, '09-10-2014', 10, NULL),
562(1, 2, '09-10-2014', 67, NULL),
563(1, 3, '09-10-2014', 767, NULL),
564(1, 4, '09-10-2014', 243, NULL),
565(1, 5, '09-10-2014', 21, NULL),
566(1, 6, '09-10-2014', 33, NULL),
567(1, 7, '09-10-2014', 67, NULL),
568(2, 1, '09-10-2014', 10, NULL),
569(2, 2, '09-10-2014', 67, NULL),
570(2, 3, '09-10-2014', 767, NULL),
571(2, 4, '09-10-2014', 243, NULL),
572(2, 5, '09-10-2014', 21, NULL),
573(2, 6, '09-10-2014', 33, NULL),
574(2, 7, '09-10-2014', 67, NULL),
575(3, 1, '09-10-2014', 10, NULL),
576(3, 2, '09-10-2014', 67, NULL),
577(3, 3, '09-10-2014', 767, NULL),
578(3, 4, '09-10-2014', 243, NULL),
579(3, 5, '09-10-2014', 21, NULL),
580(3, 6, '09-10-2014', 33, NULL),
581(3, 7, '09-10-2014', 67, NULL),
582(4, 1, '09-10-2014', 10, NULL),
583(4, 2, '09-10-2014', 67, NULL),
584(4, 3, '09-10-2014', 767, NULL),
585(4, 4, '09-10-2014', 243, NULL),
586(4, 5, '09-10-2014', 21, NULL),
587(4, 6, '09-10-2014', 33, NULL),
588(4, 7, '09-10-2014', 67, NULL),
589(5, 1, '09-10-2014', 10, NULL),
590(5, 2, '09-10-2014', 67, NULL),
591(5, 3, '09-10-2014', 767, NULL),
592(5, 4, '09-10-2014', 243, NULL),
593(5, 5, '09-10-2014', 21, NULL),
594(5, 6, '09-10-2014', 33, NULL),
595(5, 7, '09-10-2014', 67, NULL),
596(6, 1, '09-10-2014', 10, NULL),
597(6, 2, '09-10-2014', 67, NULL),
598(6, 3, '09-10-2014', 767, NULL),
599(6, 4, '09-10-2014', 243, NULL),
600(6, 5, '09-10-2014', 21, NULL),
601(6, 6, '09-10-2014', 33, NULL),
602(6, 7, '09-10-2014', 67, NULL),
603(1, 1, '09-10-2014', 10, NULL),
604(1, 2, '09-10-2014', 67, NULL),
605(1, 3, '09-10-2014', 767, NULL),
606(1, 4, '09-10-2014', 243, NULL),
607(1, 5, '09-10-2014', 21, NULL),
608(1, 6, '09-10-2014', 33, NULL),
609(1, 7, '09-10-2014', 67, NULL),
610(2, 1, '09-10-2014', 10, NULL),
611(2, 2, '09-10-2014', 67, NULL),
612(2, 3, '09-10-2014', 767, NULL),
613(2, 4, '09-10-2014', 243, NULL),
614(2, 5, '09-10-2014', 21, NULL),
615(2, 6, '09-10-2014', 33, NULL),
616(2, 7, '09-10-2014', 67, NULL),
617(3, 1, '09-10-2014', 10, NULL),
618(3, 2, '09-10-2014', 67, NULL),
619(3, 3, '09-10-2014', 767, NULL),
620(3, 4, '09-10-2014', 243, NULL),
621(3, 5, '09-10-2014', 21, NULL),
622(3, 6, '09-10-2014', 33, NULL),
623(3, 7, '09-10-2014', 67, NULL),
624(4, 1, '09-10-2014', 10, NULL),
625(4, 2, '09-10-2014', 67, NULL),
626(4, 3, '09-10-2014', 767, NULL),
627(4, 4, '09-10-2014', 243, NULL),
628(4, 5, '09-10-2014', 21, NULL),
629(4, 6, '09-10-2014', 33, NULL),
630(4, 7, '09-10-2014', 67, NULL),
631(5, 1, '09-10-2014', 10, NULL),
632(5, 2, '09-10-2014', 67, NULL),
633(5, 3, '09-10-2014', 767, NULL),
634(5, 4, '09-10-2014', 243, NULL),
635(5, 5, '09-10-2014', 21, NULL),
636(5, 6, '09-10-2014', 33, NULL),
637(5, 7, '09-10-2014', 67, NULL),
638(6, 1, '09-10-2014', 10, NULL),
639(6, 2, '09-10-2014', 67, NULL),
640(6, 3, '09-10-2014', 767, NULL),
641(6, 4, '09-10-2014', 243, NULL),
642(6, 5, '09-10-2014', 21, NULL),
643(6, 6, '09-10-2014', 33, NULL),
644(6, 7, '09-10-2014', 67, NULL),
645(1, 1, '09-10-2014', 10, NULL),
646(1, 2, '09-10-2014', 67, NULL),
647(1, 3, '09-10-2014', 767, NULL),
648(1, 4, '09-10-2014', 243, NULL),
649(1, 5, '09-10-2014', 21, NULL),
650(1, 6, '09-10-2014', 33, NULL),
651(1, 7, '09-10-2014', 67, NULL),
652(2, 1, '09-10-2014', 10, NULL),
653(2, 2, '09-10-2014', 67, NULL),
654(2, 3, '09-10-2014', 767, NULL),
655(2, 4, '09-10-2014', 243, NULL),
656(2, 5, '09-10-2014', 21, NULL),
657(2, 6, '09-10-2014', 33, NULL),
658(2, 7, '09-10-2014', 67, NULL),
659(3, 1, '09-10-2014', 10, NULL),
660(3, 2, '09-10-2014', 67, NULL),
661(3, 3, '09-10-2014', 767, NULL),
662(3, 4, '09-10-2014', 243, NULL),
663(3, 5, '09-10-2014', 21, NULL),
664(3, 6, '09-10-2014', 33, NULL),
665(3, 7, '09-10-2014', 67, NULL),
666(4, 1, '09-10-2014', 10, NULL),
667(4, 2, '09-10-2014', 67, NULL),
668(4, 3, '09-10-2014', 767, NULL),
669(4, 4, '09-10-2014', 243, NULL),
670(4, 5, '09-10-2014', 21, NULL),
671(4, 6, '09-10-2014', 33, NULL),
672(4, 7, '09-10-2014', 67, NULL),
673(5, 1, '09-10-2014', 10, NULL),
674(5, 2, '09-10-2014', 67, NULL),
675(5, 3, '09-10-2014', 767, NULL),
676(5, 4, '09-10-2014', 243, NULL),
677(5, 5, '09-10-2014', 21, NULL),
678(5, 6, '09-10-2014', 33, NULL),
679(5, 7, '09-10-2014', 67, NULL),
680(6, 1, '09-10-2014', 10, NULL),
681(6, 2, '09-10-2014', 67, NULL),
682(6, 3, '09-10-2014', 767, NULL),
683(6, 4, '09-10-2014', 243, NULL),
684(6, 5, '09-10-2014', 21, NULL),
685(6, 6, '09-10-2014', 33, NULL),
686(6, 7, '09-10-2014', 67, NULL),
687(1, 1, '09-10-2014', 10, NULL),
688(1, 2, '09-10-2014', 67, NULL),
689(1, 3, '09-10-2014', 767, NULL),
690(1, 4, '09-10-2014', 243, NULL),
691(1, 5, '09-10-2014', 21, NULL),
692(1, 6, '09-10-2014', 33, NULL),
693(1, 7, '09-10-2014', 67, NULL),
694(2, 1, '09-10-2014', 10, NULL),
695(2, 2, '09-10-2014', 67, NULL),
696(2, 3, '09-10-2014', 767, NULL),
697(2, 4, '09-10-2014', 243, NULL),
698(2, 5, '09-10-2014', 21, NULL),
699(2, 6, '09-10-2014', 33, NULL),
700(2, 7, '09-10-2014', 67, NULL),
701(3, 1, '09-10-2014', 10, NULL),
702(3, 2, '09-10-2014', 67, NULL),
703(3, 3, '09-10-2014', 767, NULL),
704(3, 4, '09-10-2014', 243, NULL),
705(3, 5, '09-10-2014', 21, NULL),
706(3, 6, '09-10-2014', 33, NULL),
707(3, 7, '09-10-2014', 67, NULL),
708(4, 1, '09-10-2014', 10, NULL),
709(4, 2, '09-10-2014', 67, NULL),
710(4, 3, '09-10-2014', 767, NULL),
711(4, 4, '09-10-2014', 243, NULL),
712(4, 5, '09-10-2014', 21, NULL),
713(4, 6, '09-10-2014', 33, NULL),
714(4, 7, '09-10-2014', 67, NULL),
715(5, 1, '09-10-2014', 10, NULL),
716(5, 2, '09-10-2014', 67, NULL),
717(5, 3, '09-10-2014', 767, NULL),
718(5, 4, '09-10-2014', 243, NULL),
719(5, 5, '09-10-2014', 21, NULL),
720(5, 6, '09-10-2014', 33, NULL),
721(5, 7, '09-10-2014', 67, NULL),
722(6, 1, '09-10-2014', 10, NULL),
723(6, 2, '09-10-2014', 67, NULL),
724(6, 3, '09-10-2014', 767, NULL),
725(6, 4, '09-10-2014', 243, NULL),
726(6, 5, '09-10-2014', 21, NULL),
727(6, 6, '09-10-2014', 33, NULL),
728(6, 7, '09-10-2014', 67, NULL);
729GO