TSQL Challenge 20 - Accepted Solutions

Here is the list of TSQL Challenge 20 solutions that passed the preliminary evaluation and accepted for further processing.

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_v2.sql
20	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_20.sql
21	Dalius Macernius	Dalius_Macernius_tsqlchallenge_20.sql
22	dave repton	dave_repton_tsqlchallenge_20.sql
23	david betteridge	david_betteridge_tsqlchallenge_20_b.sql
24	david daxzeal	david_daxzeal_tsqlchallenge_20.sql
25	david linetsky	david_linetsky_tsqlchallenge_20.sql
26	David Ritter	David_Ritter_tsqlchallenge_20.sql
27	David Ritter	David_Ritter_tsqlchallenge_20_v2.sql
28	dbsqlmon	dbsqlmon_tsqlchallenge_20_v2.sql
29	Dean Stillson	Dean_Stillson_tsqlchallenge_20.sql
30	Denis Oksanich	Denis_Oksanich_tsqlchallenge_20.sql
31	dimitar dimitrov	dimitar_dimitrov_tsqlchallenge_20_v1.sql
32	Divya Agrawal	Divya_Agrawal_tsqlchallenge_20.sql
33	dragoslav djordjevic	dragoslav_djordjevic_tsqlchallenge_20.sql
34	eric cockrell	eric_cockrell_tsqlchallenge_20_v1.sql
35	Eric Freeman	Eric_Freeman_tsqlchallenge_20.sql
36	Eric Freeman	Eric_Freeman_tsqlchallenge_20_v1.sql
37	Eric Freeman	Eric_Freeman_tsqlchallenge_20_v2.sql
38	eric nordlander	eric_nordlander_tsqlchallenge_20.sql
39	erick bailey	erick_bailey_tsqlchallenge_20.sql
40	erick bailey	erick_bailey_tsqlchallenge_20_v2.sql
41	fabien contaminard	fabien_contaminard_tsqlchallenge_20.sql
42	Gangadhar Naidu	Gangadhar_Naidu_tsqlchallenge_20.sql
43	Geri Reshef	Geri_Reshef_tsqlchallenge_20.sql
44	guenter	guenter_tsqlchallenge_20.sql
45	guenter schech	guenter_tsqlchallenge_20_1.sql
46	guenter schech	guenter_tsqlchallenge_20_2.sql
47	gustavo gonzalez	gustavo_gonzalez_tsqlchallenge_20.sql
48	ivan tsatsarov	ivan_tsatsarov_tsqlchallenge_20.sql
49	jacek szarapa	jacek_szarapa_tsqlchallenge_20.sql
50	jagat patel	jagat_patel_tsqlchallenge_20.sql
51	Janson James	Janson_James_tsqlchallenge_20.sql
52	Jason Whitney	Jason_Whitney_tsqlchallenge_20.sql
53	jeff hadden	jeff_hadden_tsqlchallenge_20.sql
54	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_20.sql
55	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_20_v2.sql
56	Jesse Roberge	Jesse_Roberge_tsqlchallenge_20.sql
57	Jim Gawn Gawn	Jim_Gawn_TSQLChallenge_20.sql
58	john stradling	john_stradling_tsqlchallenge_20.sql
59	Jon Cooney	Jon_Cooney_tsqlchallenge_20.sql
60	Jose Chama	Jose_Chama_tsqlchallenge_20.sql
61	Jose Cruz	Jose_Cruz_tsqlchallenge_20_c.sql
62	Jose Cruz	Jose_Cruz_tsqlchallenge_20_a.sql
63	Jose Cruz	Jose_Cruz_tsqlchallenge_20_b.sql
64	Josh Schindler	Josh_Schindler_tsqlchallenge_20.sql
65	Josh Shilling	Josh_Shilling_tsqlchallenge_20.sql
66	kamaludeen mohamedbatcha	kamaludeen_mohamedbatcha_tsqlchallenge_20.sql
67	kamaludeen mohamedbatcha	kamaludeen_mohamedbatcha_tsqlchallenge_20_Alternat..
68	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_20.sql
69	Kevin Kershaw	Kevin_Kershaw_tsqlchallenge_20.sql
70	leigh waldie	leigh_waldie_tsqlchallenge_20.sql
71	leigh waldie	leigh_waldie_tsqlchallenge_20_version_2.sql
72	leonid koyfman	leonid_koyfman_tsqlchallenge_20_v1.sql
73	leonid koyfman	leonid_koyfman_tsqlchallenge_20_v2.sql
74	leszek g	leszek_g_tsqlchallenge_20_v20.sql
75	leszek g	leszek_g_tsqlchallenge_20_v22.sql
76	leszek g	leszek_g_tsqlchallenge_20_v99.sql
77	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_20.sql
78	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v5.sql
79	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v6.sql
80	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v7.sql
81	leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v8.sql
82	leszek gniadkowski	tsqlchallenge_20_s9.sql
83	letser herrera	letser_herrera_tsqlchallenge_20_v2.sql
84	letser herrera	letser_herrera_tsqlchallenge_20_v3.sql
85	letser herrera	letser_herrera_tsqlchallenge_20.sql
86	lisa k	lisa_k_tsqlchallenge_20.sql
87	louis hillebrand	louis_hillebrand_tsqlchallenge_20.sql
88	louis hillebrand	louis_hillebrand_tsqlchallenge_20_v1.sql
89	Luis Patricio	Luis_Patricio_tsqlchallenge_20.sql
90	maciej pilecki	maciej_pilecki_tsqlchallenge_20.sql
91	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_20_WithCTE.sql
92	Marek Powichrowski	Marek_Powichrowski_tsqlchallenge_20.sql
93	Mario Puskaric	Mario_Puskaric_tsqlchallenge_20.sql
94	Mario Puskaric	Mario_Puskaric_tsqlchallenge_20_v2.sql
95	mark cowne	mark_cowne_tsqlchallenge_20_V2.sql
96	Michael Lewis	Michael_Lewis_tsqlchallenge_20.sql
97	michal dvorak	michal_dvorak_tsqlchallenge_20.sql
98	michal dvorak	michal_dvorak_tsqlchallenge_20_v2.sql
99	michal mutka	michal_mutka_tsqlchallenge_20.sql
100	michal poreba	michal_poreba_tsqlchallenge_20.sql
101	Michal Stanek	Michal_Stanek_tsqlchallenge_20.sql
102	mikael weghammar	mikael_weghammar_tsqlchallenge_20.sql
103	Mitesh oswal	Mitesh_oswal_Tsql_20.sql
104	Mueller Lutz	Mueller_Lutz_tsqlchallenge_20.sql
105	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_20_2.sql
106	Nagabhushanam Ponnapalli	Nagabhushanam_Ponnapalli_tsqlchallenge_20.sql
107	Narasimhan Jayachandran	Narasimhan_Jayachandran_tsqlchallenge_20.sql
108	niladri biswas	niladri_biswas_tsqlchallenge_20_v1.sql
109	niladri biswas	niladri_biswas_tsqlchallenge_20_v2.sql
110	niladri biswas	niladri_biswas_tsqlchallenge_20_v3.sql
111	niladri biswas	niladri_biswas_tsqlchallenge_20_v4.sql
112	Nilay Chaudhari	Challange20.sql
113	odenbreit frank	odenbreit_frank_tsqlchallenge_20.sql
114	Par Eriksson	Par_Eriksson_tsqlchallenge_20.sql
115	parth patel	parth_patel_tsqlchallenge_20.sql
116	Patrick Fowler TSQLChallenge	Patrick_Fowler_TSQLChallenge_20.sql
117	paul atkinson	paul_atkinson_tsqlchallenge_20.sql
118	paul chang	paul_chang_tsqlchallenge_20.sql
119	pawel potasinski	pawel_potasinski_tsqlchallenge_20.sql
120	pedro cunha	pedro_cunha_tsqlchallenge_20.sql
121	piotr mis	piotr_mis_tsqlchallenge_20_v1.sql
122	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_20.sql
123	ramesh saive	ramesh_saive_tsqlchallenge_20.sql
124	rashid saleem	rashid_saleem_tsqlchallenge_20.sql
125	Razvan Socol	Razvan_Socol_tsqlchallenge_20.sql
126	regan wick	regan_wick_tsqlchallenge_20_v1.sql
127	regan wick	regan_wick_tsqlchallenge_20_v2.sql
128	regan wick	regan_wick_tsqlchallenge_20_v3.sql
129	regan wick	regan_wick_tsqlchallenge_20_v4.sql
130	regan wick	regan_wick_tsqlchallenge_20_v5.sql
131	reich jesse	reich_jesse_tsqlchallenge_20.sql
132	rob farley	rob_farley_tsqlchallenge_20.sql
133	rob farley	rob_farley5_tsqlchallenge_20.sql
134	Ruchay Sohawan	Ruchay_Sohawan_tsqlchallenge_20.sql
135	ryan duclos	ryan_duclos_tsqlchallenge_20_v1.sql
136	Ryan Randall	Ryan_Randall_tsqlchallenge_20_v1.sql
137	Ryan Randall	Ryan_Randall_tsqlchallenge_20_v2.sql
138	Saif Hasan	Saif_Hasan_tsqlchallenge_20.sql
139	Sean Walker	Sean_Walker_tsqlchallenge_20.sql
140	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20.sql
141	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20v2.sql
142	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20v3.sql
143	Seth Phelabaum	Seth_Phelabaum_tsqlchallenge_20.sql
144	sgmunson sgmunson	sgmunson_sgmunson_tsqlchallenge_20.sql
145	spark s	spark_s_tsqlchallenge_20.sql
146	spark s	spark_s_tsqlchallenge_20_v2.sql
147	Srinivasan A	Srinivasan_A_tsqlchallenge_20.sql
148	stephen horne	stephen_horne_tsqlchallenge_20_v1.sql
149	steve t	steve_t_tsqlchallenge_20.sql
150	Steyer Vincent	Steyer_Vincent_tsqlchallenge_20.sql
151	syed alam	syed_mehroz_alam_tsqlchallenge_20_v1.sql
152	syed alam	syed_mehroz_alam_tsqlchallenge_20_v2.sql
153	Szymon Musial	Szymon_Musial_tsqlchallenge_20.sql
154	tim bruce	tim_bruce_tsqlchallenge_20.sql
155	tim lehner	tim_lehner_tsqlchallenge_20.sql
156	tomas boixet	tomas_boixet_tsqlchallenge_20.sql
157	Vamsi Bogullu	Vamsi_Bogullu_tsqlchallenge_20_v1.sql
158	Vamsi Bogullu	Vamsi_Bogullu_tsqlchallenge_20_v2.sql
159	w Bob	w_Bob_tsqlchallenge_20.sql
160	will spurgeon	will_spurgeon_tsqlchallenge_20.sql
161	yonghang wang	yonghang_wang_tsqlchallenge_20.sql
162	yonghang wang	yonghang_wang_tsqlchallenge_20_v2.sql