TSQL Challenge 18 - All solutions

Here is the list of submissions we received for TSQL Challenge 18.

1	Aleksey Shtepa	Aleksey_Shtepa_tsqlchallenge_18.sql
2	alexander kovacs	alexander_kovacs_tsqlchallenge_18.sql
3	anthony gebhardt	anthony_gebhardt_tsqlchallenge_18.sql
4	art saisuphaluck	art_saisuphaluck_tsqlchallenge_18_v2.sql
5	art saisuphaluck	art_saisuphaluck_tsqlchallenge_18.sql
6	Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_18.sql
7	ben bolte	ben_bolte_tsqlchallenge_18.sql
8	berezovsky allen	berezovsky_allen_tsqchallenge_18.sql
9	bill sheets	bill_sheets_tsqlchallenge_18.sql
10	bret warnick	bret_warnick_tsqlchallenge_18.sql
11	brian quigley	brian_quigley_tsqlchallenge_18.sql
12	brian quigley	brian_quigley_tsqlchallenge_18_v2.sql
13	charles flock	charles_flock_tsqlchallenge_18.sql
14	charles flock	charles_flock_tsqlchallenge_18_v03.sql
15	Chris Kulisz	Chris_Kulisz_tsqlchallenge_18.sql
16	Chris Morris	Chris_Morris_tsqlchallenge_18.sql
17	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_18.sql
18	Dalius Macernius	Dalius_Macernius_tsqlchallenge_18.sql
19	dave repton	dave_repton_tsqlchallenge_18.sql
20	david betteridge	david_betteridge_tsqlchallenge_18_v3.sql
21	david betteridge	david_betteridge_tsqlchallenge_18.sql
22	david betteridge	david_betteridge_tsqlchallenge_18_b.sql
23	david itzkowitz	david_itzkowitz_tsqlchallenge_18.sql
24	david todd	david_todd_tsqlchallenge_18.sql
25	Denis Oksanich	Denis_Oksanich_tsqlchallenge_18.sql
26	Divya Agrawal	Divya_Agrawal_tsqlchallenge_18.sql
27	Erick Bailey	Erick_Bailey_tsqlchallenge_18.sql
28	erik eckhardt	erik_eckhardt_tsqlchallenge_18_v3.sql
29	erik eckhardt	erik_eckhardt_tsqlchallenge_18_2.sql
30	erik eckhardt	erik_eckhardt_tsqlchallenge_18.sql
31	fabien contaminard	fabien_contaminard_tsqlchallenge_18.sql
32	fabien contaminard	fabien_contaminard_tsqlchallenge_18_v2.sql
33	gashi shukri	gashi_shukri_tsqlchallenge_18.sql
34	Gerhard vanNiekerk	Gerhard_vanNiekerk_tsqlchallenge_18.sql
35	gregory lebed	gregory_lebed_tsqlchallenge_18.sql
36	Gyan Garg	Gyan_Garg_tsqlchallenge_18.sql
37	Gyan Koju	Gyan_Koju_tsqlchallenge_18.sql
38	Gyan Koju	Gyan_Koju_tsqlchallenge_18_V2.sql
39	HODIN Matthieu	HODIN_Matthieu_tsqlchallenge_18.sql
40	James Pua	James_Pua__tsqlchallenge_18.sql
41	James Pua	James_Pua_tsqlchallenge_18.sql
42	Jason Whitney	Jason_Whitney_tsqlchallenge_18.sql
43	jeff moden	jeff_moden_tsqlchallenge_18.sql
44	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_18.sql
45	Jens Weiermann	Jens_Weiermann_tsqlchallenge_18.sql
46	Jesse Roberge	Jesse_Roberge_tsqlchallenge_18.sql
47	Jesse Roberge	Jesse_Roberge_tsqlchallenge_18_V2.sql
48	Joel Ewald	Joel_Ewald_TSQLChallenge_18.sql
49	Joel Ewald	Joel_Ewald_TSQLChallenge_18_v2.sql
50	Joel Ewald	Joel_Ewald_TSQLChallenge_18_v3.sql
51	jon gurgul	jon_gurgul_tsqlchallenge_018.sql
52	jon gurgul	jon_gurgul_tsqlchallenge_018_v1.5.sql
53	jon gurgul	jon_gurgul_tsqlchallenge_018_v2.sql
54	jon gurgul	jon_gurgul_tsqlchallenge_018_v3.sql
55	Jose Cruz	Jose_Cruz_tsqlchallenge_18.sql
56	Jose Cruz	Jose_Cruz_tsqlchallenge_18_2.sql
57	joseph rajan	joseph_rajan_tsqlchallenge_18.sql
58	Justin Blanding	Justin_Blanding_tsqlchallenge_18_v1.sql
59	Justin Blanding	Justin_Blanding_tsqlchallenge_18_v2.sql
60	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_18_4.sql
61	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_18.sql
62	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_18_1.sql
63	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_18_2.sql
64	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_18_3.sql
65	kevin suchlicki	kevin_suchlicki_tsqlchallenge_18.sql
66	Larry Cosrin	Larry_Cosrin_tsqlchallenge_18.sql
67	Laurent Bouyssou	Laurent Bouyssou_TSQLChallenge_18.sql
68	leigh waldie	leigh_waldie_tsqlchallenge_18_revised.sql
69	leigh waldie	leigh_waldie_tsqlchallenge_18.sql
70	leonid koyfman	leonid_koyfman_tsqlchallenge_18.sql
71	leonid koyfman	leonid_koyfman_tsqlchallenge_18_v2.sql
72	leonid koyfman	leonid_koyfman_tsqlchallenge_18_v3.sql
73	leszek g	leszek_g_tsqlchallenge_18_v3.sql
74	leszek g	leszek_g_tsqlchallenge_18_v4.sql
75	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_18_v6.sql
76	leszek gniadkowski	tsqlchallenge_18.sql
77	leszek gniadkowski	tsqlchallenge_18_v2.sql
78	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_18_v5.sql
79	letser herrera	letser_herrera_tsqlchallenge_18.sql
80	maciej pilecki	maciej_pilecki_tsqlchallenge_18.sql
81	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_18.sql
82	Makogon Constantin Constantin	Makogon_Constantin_tsqlchallenge_18.sql
83	mallia jonathan	mallia_jonathan_tsqlchallenge_18.sql
84	Michael Lewis	Michael_Lewis_tsqlchallenge_18.sql
85	michael newell	michael_newell_tsqlchallenge_18.sql
86	michal mutka	michal_mutka_tsqlchallenge_18.sql
87	michal mutka	michal_mutka_tsqlchallenge_18_v2.sql
88	michal mutka	michal_mutka_tsqlchallenge_18_v3.sql
89	Michal Stanek	Michal_Stanek_tsqlchallenge_18.sql
90	Mike DeFehr	Mike_DeFehr_TSQLChallenge_18.sql
91	mike stjean	mike_stjean_tsqlchallenge_18.sql
92	Mitesh oswal	Mitesh_oswal_TsqlChallenge_18.sql
93	morten nilsen	morten_nilsen_tsqlchallenge_18.sql
94	Mueller Lutz	Mueller_Lutz_tsqlchallenge_18.sql
95	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_18_V3.sql
96	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_18_V4.sql
97	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_18_V1.sql
98	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_18_V2.sql
99	Muhammad Pasha	muhammad_alpasha_tsqlchallenge_18.sql
100	Muhammad Pasha	muhammad_alpasha_tsqlchallenge_18_2.sql
101	Muhammad Pasha	muhammad_alpasha_tsqlchallenge_18_3.sql
102	niladri biswas	niladri_biswas_tsqlchallenge_18.sql
103	noel dr	noel_dr_tsqlchallenge_18.sql
104	odenbreit frank	odenbreit_frank_tsqlchallenge_18.sql
105	oleg zernov	oleg_zernov_tsqlchallenge_18.sql
106	par eriksson	par_eriksson_tsqlchallenge_18.sql
107	par eriksson	par_eriksson_tsqlchallenge_18_2.sql
108	par eriksson	par_eriksson_tsqlchallenge_18_V3.sql
109	par eriksson	par_eriksson_tsqlchallenge_18_V4.sql
110	parth patel	parth_patel_tsqlchallenge_18.sql
111	paul chang	paul_chang_tsqlchallenge_18.sql
112	philippe favrie	philippe_favrie_tsqlchallenge_18.sql
113	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_18_v4.sql
114	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_18_v5.sql
115	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_18.sql
116	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_18_v3.sql
117	radu negru	radu_negru_tsqlchallenge_18.sql
118	Rahul Verma	Rahul_Verma_tsqlchallenge_18.sql
119	Rakesh Kikani	Rakesh_Kikani_tsqlchallenge_18.sql
120	ramesh saive	ramesh_saive_tsqlchallenge_18.sql
121	ramireddy dasaradha	TSqlChallenge18.sql
122	Randy Derby	Randy_Derby_tsqlchallenge_18.sql
123	Randy Derby	Randy_Derby_tsqlchallenge_18_v3.sql
124	Ranjeet Sharma	Ranjeet_Sharma_tsqlChallenge_18.sql
125	regan wick	regan_wick_tsqlchallenge_18.sql
126	regan wick	regan_wick_tsqlchallenge_18b.sql
127	rhamille golimlim	rhamille_golimlim_tsqlchallenge_18.sql
128	rhamille golimlim	rhamille_golimlim_tsqlchallenge_18_v2.sql
129	roby hoye	roby_van_hoye_tsqlchallenge_18.sql
130	russell sanders	russell_sanders_tsqlchallenge_18.sql
131	russell sanders	russell_sanders_tsqlchallenge_18_v2.sql
132	sam camargo	sam_camargo_tsqlchallenge_18.sql
133	Scott Jones	Scott_Jones_TSQLChallenge_18.sql
134	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_18.sql
135	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_18_v2.sql
136	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_18.sql
137	shankaranand saguturu	shankaranand_saguturu_tsqlchallenge_18_v2.sql
138	shankaranand saguturu	shankaranand_saguturu_tsqlchallenge_18.sql
139	simon flint	simon_flint_tsqlchallenge_18.sql
140	Simon Mendoza	Simon_Mendoza_TSQLChallenge_18.sql
141	sreekumar prabhakaran	sreekumar_prabhakaran_tsqlchallenge_18.sql
142	TimothyJ Hartford	TimothyJ_Hartford_tsqlchallenge_18.sql
143	tony bater	tony_bater_tsqlchallenge_18.sql