TSQL Challenge 20 - All Solutions

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

1	Adán Bucio	Adán_Bucio_tsqlchallenge_20.sql
2	Adán Bucio	Adán_Bucio_tsqlchallenge_20_v2.sql
3	Adán Bucio	Adán_Bucio_tsqlchallenge_20_v3.sql
4	Adán Bucio	Adán_Bucio_tsqlchallenge_20_v4.sql
5	alun davies	alun_davies_tsqlchallenge_20.sql
6	Anders Uhl	Anders_Uhl_tsqlchallenge_20_v1.sql
7	andrey myasnikov	andrey_myasnikov_tsqlchallenge_20_v1.sql
8	angella jagdeo	angella_jagdeo_tsqlchallenge_20.sql
9	anthony gebhardt	anthony_gebhardt_tsqlchallenge_20.sql
10	antonio facturan	antonio_facturan_tsqlchallenge_20.sql
11	Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_20_2_v1.sql
12	Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_20_2_v2.sql
13	Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_20_v1.sql
14	Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_20_v2.sql
15	aurelien verla	aurelien_verla_tsqlchallenge_20.sql
16	barbara gunion	barbara_gunion_tsqlchallenge_20_v1.sql
17	Benjamin Valet Valet	benjamin_valet_tsqlchallenge_20.sql
18	brad mullins	brad_mullins_tsqlchallenge_20.sql
19	bret warnick	bret_warnick_tsqlchallenge_20.sql
20	bret warnick	bret_warnick_tsqlchallenge_20_v2.sql
21	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_20.sql
22	Dalius Macernius	Dalius_Macernius_tsqlchallenge_20.sql
23	dave repton	dave_repton_tsqlchallenge_20.sql
24	david betteridge	david_betteridge_tsqlchallenge_20.sql
25	david betteridge	david_betteridge_tsqlchallenge_20_b.sql
26	david daxzeal	david_daxzeal_tsqlchallenge_20.sql
27	david linetsky	david_linetsky_tsqlchallenge_20.sql
28	David Ritter	David_Ritter_tsqlchallenge_20.sql
29	David Ritter	David_Ritter_tsqlchallenge_20_v2.sql
30	dbsqlmon	dbsqlmon_tsqlchallenge_20_v2.sql
31	Dean Stillson	Dean_Stillson_tsqlchallenge_20.sql
32	Denis Oksanich	Denis_Oksanich_tsqlchallenge_20.sql
33	dimitar dimitrov	dimitar_dimitrov_tsqlchallenge_20_v1.sql
34	Divya Agrawal	Divya_Agrawal_tsqlchallenge_20.sql
35	dragoslav djordjevic	dragoslav_djordjevic_tsqlchallenge_20.sql
36	eric cockrell	eric_cockrell_tsqlchallenge_20_v1.sql
37	Eric Freeman	Eric_Freeman_tsqlchallenge_20.sql
38	Eric Freeman	Eric_Freeman_tsqlchallenge_20_v1.sql
39	Eric Freeman	Eric_Freeman_tsqlchallenge_20_v2.sql
40	eric nordlander	eric_nordlander_tsqlchallenge_20.sql
41	erick bailey	erick_bailey_tsqlchallenge_20.sql
42	erick bailey	erick_bailey_tsqlchallenge_20_v2.sql
43	fabien contaminard	fabien_contaminard_tsqlchallenge_20.sql
44	Gangadhar Naidu	Gangadhar_Naidu_tsqlchallenge_20.sql
45	Geri Reshef	Geri_Reshef_tsqlchallenge_20.sql
46	guenter	guenter_tsqlchallenge_20.sql
47	guenter schech	guenter_tsqlchallenge_20_1.sql
48	guenter schech	guenter_tsqlchallenge_20_2.sql
49	gustavo gonzalez	gustavo_gonzalez_tsqlchallenge_20.sql
50	ivan tsatsarov	ivan_tsatsarov_tsqlchallenge_20.sql
51	jacek szarapa	jacek_szarapa_tsqlchallenge_20.sql
52	jagat patel	jagat_patel_tsqlchallenge_20.sql
53	Janson James	Janson_James_tsqlchallenge_20.sql
54	Jason Whitney	Jason_Whitney_tsqlchallenge_20.sql
55	jeff hadden	jeff_hadden_tsqlchallenge_20.sql
56	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_20.sql
57	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_20_v2.sql
58	Jesse Roberge	Jesse_Roberge_tsqlchallenge_20_V2.sql
59	Jesse Roberge	Jesse_Roberge_tsqlchallenge_20.sql
60	Jim Gawn Gawn	Jim_Gawn_TSQLChallenge_20.sql
61	joe celko	joe_celko_tsqlchallenge-20.sql
62	john hill	john_hill_tsqlchallenge_20.sql
63	john stradling	john_stradling_tsqlchallenge_20.sql
64	Jon Cooney	Jon_Cooney_tsqlchallenge_20.sql
65	Jose Chama	Jose_Chama_tsqlchallenge_20.sql
66	Jose Cruz	Jose_Cruz_tsqlchallenge_20_c.sql
67	Jose Cruz	Jose_Cruz_tsqlchallenge_20_a.sql
68	Jose Cruz	Jose_Cruz_tsqlchallenge_20_b.sql
69	Jose Cruz	Jose_Cruz_tsqlchallenge_20.sql
70	Josh Schindler	Josh_Schindler_tsqlchallenge_20.sql
71	Josh Shilling	Josh_Shilling_tsqlchallenge_20.sql
72	kamaludeen mohamedbatcha	kamaludeen_mohamedbatcha_tsqlchallenge_20.sql
73	kamaludeen mohamedbatcha	kamaludeen_mohamedbatcha_tsqlchallenge_20_Alternat..
74	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_20.sql
75	Kevin Kershaw	Kevin_Kershaw_tsqlchallenge_20.sql
76	leigh waldie	leigh_waldie_tsqlchallenge_20.sql
77	leigh waldie	leigh_waldie_tsqlchallenge_20_version_2.sql
78	leonid koyfman	leonid_koyfman_tsqlchallenge_20_v1.sql
79	leonid koyfman	leonid_koyfman_tsqlchallenge_20_v2.sql
80	leszek g	leszek_g_tsqlchallenge_20_v20.sql
81	leszek g	leszek_g_tsqlchallenge_20_v22.sql
82	leszek g	leszek_g_tsqlchallenge_20_v99.sql
83	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_20.sql
84	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v5.sql
85	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v6.sql
86	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v7.sql
87	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v8.sql
88	leszek gniadkowski	tsqlchallenge_20_s9.sql
89	letser herrera	letser_herrera_tsqlchallenge_20_v2.sql
90	letser herrera	letser_herrera_tsqlchallenge_20_v3.sql
91	letser herrera	letser_herrera_tsqlchallenge_20.sql
92	letser herrera	letser_herrera_tsqlchallenge_20_v1.sql
93	lisa k	lisa_k_tsqlchallenge_20.sql
94	louis hillebrand	louis_hillebrand_tsqlchallenge_20.sql
95	louis hillebrand	louis_hillebrand_tsqlchallenge_20_v1.sql
96	Luis Patricio	Luis_Patricio_tsqlchallenge_20.sql
97	maciej pilecki	maciej_pilecki_tsqlchallenge_20.sql
98	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_20_WithCTE.sql
99	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_20_WithTableVariab..
100	Marek Powichrowski	Marek_Powichrowski_tsqlchallenge_20.sql
101	Mario Puskaric	Mario_Puskaric_tsqlchallenge_20.sql
102	Mario Puskaric	Mario_Puskaric_tsqlchallenge_20_v2.sql
103	mark cowne	mark_cowne_tsqlchallenge_20_V1.sql
104	mark cowne	mark_cowne_tsqlchallenge_20_V2.sql
105	Michael Lewis	Michael_Lewis_tsqlchallenge_20.sql
106	michal dvorak	michal_dvorak_tsqlchallenge_20.sql
107	michal dvorak	michal_dvorak_tsqlchallenge_20_v2.sql
108	michal mutka	michal_mutka_tsqlchallenge_20.sql
109	michal poreba	michal_poreba_tsqlchallenge_20.sql
110	Michal Stanek	Michal_Stanek_tsqlchallenge_20.sql
111	mikael weghammar	mikael_weghammar_tsqlchallenge_20.sql
112	Mitesh oswal	Mitesh_oswal_Tsql_20.sql
113	Mueller Lutz	Mueller_Lutz_tsqlchallenge_20.sql
114	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_20_V3.sql
115	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_20.sql
116	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_20_2.sql
117	Nagabhushanam Ponnapalli	Nagabhushanam_Ponnapalli_tsqlchallenge_20.sql
118	Narasimhan Jayachandran	Narasimhan_Jayachandran_tsqlchallenge_20.sql
119	Nick DeChellis	Nick_DeChellis_TSQLChallenge_20.sql
120	niladri biswas	niladri_biswas_tsqlchallenge_20_v1.sql
121	niladri biswas	niladri_biswas_tsqlchallenge_20_v2.sql
122	niladri biswas	niladri_biswas_tsqlchallenge_20_v3.sql
123	niladri biswas	niladri_biswas_tsqlchallenge_20_v4.sql
124	Nilay Chaudhari	Challange20.sql
125	odenbreit frank	odenbreit_frank_tsqlchallenge_20.sql
126	Par Eriksson	Par_Eriksson_tsqlchallenge_20.sql
127	parth patel	parth_patel_tsqlchallenge_20.sql
128	Patrick Fowler TSQLChallenge	Patrick_Fowler_TSQLChallenge_20.sql
129	paul atkinson	paul_atkinson_tsqlchallenge_20.sql
130	paul chang	paul_chang_tsqlchallenge_20.sql
131	pawel potasinski	pawel_potasinski_tsqlchallenge_20.sql
132	pedro cunha	pedro_cunha_tsqlchallenge_20.sql
133	Peso Peso	Peso_Peso_tsqlchallenge_20.sql
134	piotr mis	piotr_mis_tsqlchallenge_20_v1.sql
135	piotr mis	piotr_mis_tsqlchallenge_20_v2.sql
136	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_20.sql
137	ram reddy	ram_reddy_tsqlchallenge_20.sql
138	ram reddy	ram_reddy_tsqlchallenge_20_V4.sql
139	ramesh saive	ramesh_saive_tsqlchallenge_20.sql
140	rami reddy	rami_reddy_tsqlchallenge_20_v3.sql
141	rami reddy	rami_reddy_tsqlchallenge_20_v2.sql
142	rashid saleem	rashid_saleem_tsqlchallenge_20.sql
143	Razvan Socol	Razvan_Socol_tsqlchallenge_20.sql
144	regan wick	regan_wick_tsqlchallenge_20_v1.sql
145	regan wick	regan_wick_tsqlchallenge_20_v2.sql
146	regan wick	regan_wick_tsqlchallenge_20_v3.sql
147	regan wick	regan_wick_tsqlchallenge_20_v4.sql
148	regan wick	regan_wick_tsqlchallenge_20_v5.sql
149	reich jesse	reich_jesse_tsqlchallenge_20.sql
150	rob farley	rob_farley_tsqlchallenge_20.sql
151	rob farley	rob_farley5_tsqlchallenge_20.sql
152	rob farley2	rob_farley2_tsqlchallenge_20.sql
153	rob farley3	rob_farley3_tsqlchallenge_20.sql
154	rob farley4	rob_farley4_tsqlchallenge_20.sql
155	Ruchay Sohawan	Ruchay_Sohawan_tsqlchallenge_20.sql
156	ryan duclos	ryan_duclos_tsqlchallenge_20_v1.sql
157	Ryan Randall	Ryan_Randall_tsqlchallenge_20_v1.sql
158	Ryan Randall	Ryan_Randall_tsqlchallenge_20_v2.sql
159	Saif Hasan	Saif_Hasan_tsqlchallenge_20.sql
160	Sean Walker	Sean_Walker_tsqlchallenge_20.sql
161	Sebastian Maldonado	Sebastian_Maldonado_tsqlchallenge_20.sql
162	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20.sql
163	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20v2.sql
164	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20v3.sql
165	Seth Phelabaum	Seth_Phelabaum_tsqlchallenge_20.sql
166	sgmunson sgmunson	sgmunson_sgmunson_tsqlchallenge_20.sql
167	spark s	spark_s_tsqlchallenge_20.sql
168	spark s	spark_s_tsqlchallenge_20_v2.sql
169	sreenivas gelle	sreenivas_gelle_tsqlchallenge_20.sql
170	Srinivasan A	Srinivasan_A_tsqlchallenge_20.sql
171	stephen horne	stephen_horne_tsqlchallenge_20_v1.sql
172	steve t	steve_t_tsqlchallenge_20.sql
173	Steyer Vincent	Steyer_Vincent_tsqlchallenge_20.sql
174	syed alam	syed_mehroz_alam_tsqlchallenge_20_v1.sql
175	syed alam	syed_mehroz_alam_tsqlchallenge_20_v2.sql
176	Szymon Musial	Szymon_Musial_tsqlchallenge_20.sql
177	tim bruce	tim_bruce_tsqlchallenge_20.sql
178	tim lehner	tim_lehner_tsqlchallenge_20.sql
179	tomas boixet	tomas_boixet_tsqlchallenge_20.sql
180	Vamsi Bogullu	Vamsi_Bogullu_tsqlchallenge_20_v1.sql
181	Vamsi Bogullu	Vamsi_Bogullu_tsqlchallenge_20_v2.sql
182	voonchong yap	voonchong_yap_tsqlchallenge_20.sql.sql
183	w Bob	w_Bob_tsqlchallenge_20.sql
184	will spurgeon	will_spurgeon_tsqlchallenge_20.sql
185	yonghang wang	yonghang_wang_tsqlchallenge_20.sql
186	yonghang wang	yonghang_wang_tsqlchallenge_20_v2.sql