TSQL Challenge 21 - All Solutions

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

1	Adán Bucio	Adán_Bucio_tsqlchallenge_21_v4.sql
2	Adán Bucio	Adán_Bucio_tsqlchallenge_21.sql
3	Adán Bucio	Adán_Bucio_tsqlchallenge_21_v2.sql
4	alun davies	alun_davies_tsqlchallenge_21.sql
5	alun davies	alun_davies_tsqlchallenge_21v1.sql
6	alun davies	alun_davies_tsqlchallenge_21v2.sql
7	alun davies	alun_davies_tsqlchallenge_21v3.sql
8	Anders Nielsen	Anders_Bendix_Nielsen_tsqlchallenge_21.sql
9	Anders Nielsen	Anders_Nielsen_tsqlchallenge_21_v3.sql
10	andrey myasnikov	andrey_myasnikov_tsqlchallenge_21_v1.sql
11	anthony gebhardt	anthony_gebhardt_tsqlchallenge_21.sql
12	antonio facturan	antonio_facturan_tsqlchallenge_21_v2.sql
13	antonio facturan	antonio_facturan_tsqlchallenge_21.sql
14	Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_21.sql
15	bret warnick	bret_warnick_tsqlchallenge_21.sql
16	carlos benito	carlos_benito_tsqlchallenge_21.sql
17	carlos benito	carlos_benito_tsqlchallenge_21_v2.sql
18	chenghui wang	chenghui_wang_tsqlchallenge_21.sql
19	cmako	TSQL21.sql
20	Dave Ballantyne	Dave_Ballantyne_tsqlchallenge_21_2.sql
21	Dave Ballantyne	Dave_Ballantyne_tsqlchallenge_21_1.sql
22	dave repton	dave_repton_tsqlchallenge_21.sql
23	david betteridge	david_betteridge_tsqlchallenge_21.sql
24	david betteridge	david_betteridge_tsqlchallenge_21_v3.sql
25	dennis hafstrom	dennis_hafstrom_tsqlchallenge_21.sql
26	dennis hafstrom	dennis_hafstrom_tsqlchallenge_21_v2.sql
27	diego pighin	diego_pighin_tsqlchallenge_21_v1.sql
28	Divya Agrawal	Divya_Agrawal_tsqlchallenge_21.sql
29	eric cockrell	eric_cockrell_tsqlchallenge_21_v1.sql
30	eric nordlander	eric_nordlander_challenge_21.sql
31	erick bailey	erick_bailey_tsqlchallenge_21_v1.sql
32	erick bailey	erick_bailey_tsqlchallenge_21_v2.sql
33	eugene paradizov	eugene_paradizov_tsqlchallenge_21.sql
34	guenter	guenter_tsqlchallenge21_1.sql
35	gustavo gonzalez	gustavo_gonzalez_tsqlchallenge_21.sql
36	hakan stenstrom	hakan_stenstrom_tsqlchallenge_21.sql
37	ilke can	ilke_can_tsqlchallenge_21.sql
38	jacek szarapa	jacek_szarapa_tsqlchallenge_21.sql
39	jacek szarapa	jacek_szarapa_tsqlchallenge_21_v2.sql
40	jagat patel	jagat_patel_tsqlchallenge_21.sql
41	jagat patel	jagat_patel_tsqlchallenge_21_V2.sql
42	Jason Whitney	Jason_Whitney_tsqlchallenge_21_v5.sql
43	jeff hadden	jeff_hadden_tsqlchallenge_21.sql
44	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_21.sql
45	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_21_v2.sql
46	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_21_v3.sql
47	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_21_v4.sql
48	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_21_v5.sql
49	jeremy giaco	jeremy_giaco_tsqlchallenge_21.sql
50	jeremy giaco	jeremy_giaco_tsqlchallenge_21_v2.sql
51	Jesse Roberge	Jesse_Roberge_tsqlchallenge_21_V3.sql
52	Jesse Roberge	Jesse_Roberge_tsqlchallenge_21_V4.sql
53	Jesse Roberge	Jesse_Roberge_tsqlchallenge_21.sql
54	Jesse Roberge	Jesse_Roberge_tsqlchallenge_21_V2.sql
55	Joel Ewald	Joel_Ewald_Challenge21.sql
56	john arnott	john_arnott_tsqlchallenge_21.sql
57	jonas lincoln	jonas_lincoln_tsqlchallenge_21.sql
58	jose chama	jose_chama_tsqlchallenge_21.sql
59	josejavier rodriguez	josejavier_rodriguez_tsqlchallenge_21.sql
60	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_21_1.sql
61	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_21_V5.sql
62	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_21.sql
63	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_21_V2.sql
64	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_21_V3.sql
65	keith hyer	keith_hyer_tsqlchallenge_21.sql
66	Kevin Kershaw	Kevin_Kershaw_tsqlchallenge_21.sql
67	leigh waldie	leigh_waldie_tsqlchallenge_21.sql
68	leonid koyfman	leonid_koyfman_tsqlchallenge_21.sql
69	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_21.sql
70	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_21_v6.sql
71	leszek gniadkowski	tsqlchallenge_21_s2_v1.sql
72	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_21_v2.sql
73	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_21_v3.sql
74	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_21_v4.sql
75	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_21_v5.sql
76	louis hillebrand	louis_hillebrand_tsqlchallenge_21.sql
77	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_21.sql
78	mark cowne	mark_cowne_tsqlchallenge_21_V1.sql
79	mark cowne	mark_cowne_tsqlchallenge_21_V2.sql
80	Mark Marlow	Mark_Marlow_tsqlchallenge_21.sql
81	meierruth michael	meierruth_michael_tsqlchalleng_21.sql
82	meierruth michael	meierruth_michael_tsqlchalleng_21_v2.sql
83	meierruth michael	meierruth_michael_tsqlchallenge_21_v3.sql
84	meierruth michael	meierruth_michael_tsqlchallenge_21_v4.sql
85	Michael Lewis	Michael_Lewis_tsqlchallenge_21.sql
86	michal mutka	michal_mutka_tsqlchallenge_21.sql
87	Mueller Lutz	Mueller_Lutz_tsqlchallenge_21_v1.sql
88	Mueller Lutz	Mueller_Lutz_tsqlchallenge_21_v2.sql
89	Mueller Lutz	Mueller_Lutz_tsqlchallenge_21_v3.sql
90	Mueller Lutz	Mueller_Lutz_tsqlchallenge_21_v4.sql
91	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_21_V5.sql
92	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_21_V6.sql
93	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_21_V7.sql
94	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_V1.sql
95	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_V2.sql
96	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_V3.sql
97	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_V4.sql
98	mutka michal	mutka_michal_tsqlchallenge_21.sql
99	Nilay Chaudhari	Nilay_Chaudhari_tsqlchallenge_21.sql
100	parth patel	parth_patel_tsqlchallenge_21_v1.sql
101	parth patel	parth_patel_tsqlchallenge_21_v2.sql
102	parth patel	parth_patel_tsqlchallenge_21_v3.sql
103	parth patel	parth_patel_tsqlchallenge_21_v4.sql
104	paul chang	paul_chang_tsqlchallenge_21.sql
105	Paulo Santos	Paulo_Santos_tsqlchallenge_21.sql
106	Pavel Krticka	Pavel_Krticka_tsqlchallenge_21_v1.sql
107	Pavel Krticka	Pavel_Krticka_tsqlchallenge_21_v2.sql
108	Pavel Krticka	Pavel_Krticka_tsqlchallenge_21_v3.sql
109	Pavel Krticka	Pavel_Krticka_tsqlchallenge_21_v4.sql
110	pawan falor	pawan_falor_tsqlchallenge_21.sql
111	perez manny	perez_manny_tsqlchallenge_21.sql
112	perez manny	perez_manny_tsqlchallenge_21_v2.sql
113	Pero VanDerMerwe	Pero_VanDerMerwe_tsqlchallenge_21.sql
114	Philippe Pimenta	Philippe_Pimenta_tsqlchallenge_21.sql
115	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_21.sql
116	ramesh saive	ramesh_saive_challenge_21.sql
117	Rami Reddy	RamiReddy_tsqlchallenge_21.sql
118	Rami Reddy	RamiReddy_tsqlchallenge_21_V2.sql
119	regan wick	regan_wick_tsqlchallenge_21_v3.sql
120	regan wick	regan_wick_tsqlchallenge_21_v4.sql
121	regan wick	regan_wick_tsqlchallenge_21_v1.sql
122	regan wick	regan_wick_tsqlchallenge_21_v2.sql
123	richard fryar	richard_fryar_tsqlchallenge_21.sql
124	rick townsend	rick_townsend_tsqlchallenge_21_v1.sql
125	rick townsend	rick_townsend_tsqlchallenge_21_v2.sql
126	rob farley	rob_farley_tsqlchallenge_21_v1.sql
127	rob farley	rob_farley_tsqlchallenge_21_v2.sql
128	Robert vanDijk	Robert_vanDijk_tsqlchallenge_21.sql
129	Ruchay Sohawan	Ruchay_Sohawan_tsqlchallenge_21.sql
130	serg 54	serg_54_tsqlchallenge_21.sql
131	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_21_clear.sql
132	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_21_v2.sql
133	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_21_v4.sql
134	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_21_v5.sql
135	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_21_v6.sql
136	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_21_v1.sql
137	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_21_v2.sql
138	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_21_v3.sql
139	Simon Mendoza	Simon_Mendoza_TSQLChallenge_21.sql
140	STEPHEN MUNSON	STEPHEN_MUNSON_TSQLCHALLENGE_21.SQL
141	tomas boixet	tomas_boixet_tsqlchallenge_21.sql
142	tomas boixet	tomas_boixet_tsqlchallenge_21_v2.sql
143	tomas boixet	tomas_boixet_tsqlchallenge_21_v3.sql
144	tony bater	tony_bater_tsqlchallenge_21.sql
145	vangel paronov	vangel_paronov_tsqlchallenge_21.sql