TSQL Challenge 17 - All Solutions

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

1	Allan Cacdac	allan_cacdac_tsqlchallenge_17.sql
2	Auke	Auke_tsqlchallenge_17.sql
3	Barun Basak	barun_basak_tsqlchallenge_17.sql
4	Benjamin Valet	benjamin_valet_tsqlchallenge_17.sql
5	Bill Melcher	bill_melcher_tsqlchallenge_17.sql
6	Bill Sheets	bill_sheets_tsqlchallenge_17.sql	5 SQL Stars
7	Bill Yu	bill_yu_tsqlchallenge_17.sql
8	Bob Hovious	Bob_Hovious_TSQLChallenge_17.sql
9	Bret Warnick	bret_warnick_tsqlchallenge_17.sql	10 SQL Stars
10	Chuck Rhoads	chuck_rhoads_tsqlchallenge_17.sql
11	Cris Oltremari	cris_oltremari_tsqlchallenge_17.sql
12	Dan Andrews	Dan_Andrews_tsqlchallenge_17.sql
13	Dan Miller	Dan_Miller_tsqlchallenge_17.sql
14	Dan Miller	Dan_Miller_tsqlchallenge_17_2.sql
15	Dave Ballantyne	dave_ballantyne_tsqlchallenge_17.sql	10 SQL Stars
16	David Betteridge	david_betteridge_tsqlchallenge_17.sql
17	David Betteridge	david_betteridge_tsqlchallenge_17_2.sql
18	David Mccarthy	david_mccarthy_tsqlchallenge_17.sql
19	erik eckhardt	erik_eckhardt_tsqlchallenge_17_v3.sql	8 SQL Stars
20	Erik Eckhardt	erik_eckhardt_tsqlchallenge_17.sql	8 SQL Stars
21	Erik Eckhardt	erik_eckhardt_tsqlchallenge_17_2.sql	8 SQL Stars
22	Ernest Ostrander	Ernest_Ostrander_tsqlchallenge_17.sql
23	Fabien Waldar	fabien_contaminard_tsqlchallenge_17.sql	11 SQL Stars
24	Fabien Waldar	fabien_contaminard_tsqlchallenge_17_2.sql	11 SQL Stars
25	Geri Reshef	Geri_Reshef_tsqlchallenge_17.sql
26	Greaves James	Greaves_James_tsqlchallenge17.sql
27	Gustavo Gonzalez	gustavo_gonzalez_tsqlchallenge_17.sql
28	Gyan Koju	Gyan_koju_tsqlchallenge_17.sql
29	Gyan Koju	Gyan_koju_tsqlchallenge_17_v2.sql
30	Hans Stuer	hans_stuer_tsqlchallenge_17.sql
31	Iain Robertson	iain_robertson_tsqlchallenge_17.sql
32	Jay Bonk	jay_bonk_tsqlchallenge_17.sql
33	Jeff Moden	Jeff_Moden_tsqlchallenge_17.sql
34	Jianjun Pei	jianjun_pei_tsqlchallenge_17.sql
35	Joe Jameson	Joe_Jameson_tsqlchallenge_17.sql
36	Josh Schindler	Josh_Schindler_tsqlchallenge_17.sql
37	Justin Blanding	Justin_Blanding_tsqlchallenge_17.sql
38	Justin Blanding	Justin_Blanding_tsqlchallenge_17FIXED.sql
39	Kailang Deng	kailang_deng_tsqlchallenge_17.sql
40	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_17.sql
41	Kathi Kellenberger	kathi_kellenberger_tsqlchallenge_17.sql
42	Kyle Dabrowski	kyle_dabrowski_tsqlchallenge_17.sql
43	Leonid Koyfman	leonid_koyfman_tsqlchallenge_17.sql	6 SQL Stars
44	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_17_v1.sql
45	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_17_v3.sql
46	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_17_v4.sql
47	Linson Daniel	linson_daniel_tsqlchallenge_17.sql
48	Linson Daniel	linson_daniel_tsqlchallenge_17(2).sql
49	Lutz Mueller	Lutz_Mueller1_tsqlchallenge_17.sql
50	Lutz Mueller	Lutz_Mueller2_tsqlchallenge_17(2).sql
51	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_17.sql
52	Mark Cowne	mark_cowne_tsqlchallenge_17.sql	19 SQL Stars
53	Matthieu Hodin	HODIN_Matthieu_tsqlchallenge_17.sql	5 SQL Stars
54	Melissa Suciadi	Melissa_Suciadi_tsqlchallenge_17.sql
55	Michael Becke	michael_becke_tsqlchallenge_17.sql
56	Michael Lewis	Michael_Lewis_tsqlchallenge_17.sql
57	Michal Stanek	Michal_Stanek_tsqlchallenge_17.sql
58	Mike Pierce	pierce_mike_tsqlchallenge_17.sql
59	Mitesh Oswal	Mitesh_oswal_tsqlchallenge_17.sql
60	Naomi Nosonovsky	Naomi_Nosonovsky_tsqlChallenge_17.sql	10 SQL Stars
61	Naomi Nosonovsky	Naomi_Nosonovsky_tsqlChallenge_17_v2.sql	10 SQL Stars
62	Naomi Nosonovsky	Naomi_Nosonovsky_tsqlChallenge_17_v3.sql	10 SQL Stars
63	Niladri Biswas	niladri_biswas_tsqlchallenge_17.sql
64	Niladri Biswas	niladri_biswas_tsqlchallenge_17(2).sql
65	Parth Patel	parth_patel_tsqlchallenge_17.sql
66	Parth Patel	parth_patel_tsqlchallenge_17(2).sql
67	Parvez Shaikh	parvez_shaikh_tsqlchallenge_17.sql
68	Parvez Shaikh	parvez_shaikh_tsqlchallenge_17(2).sql
69	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_17.sql
70	Rahul Verma	Rahul_Verma_tsqlchallenge_17.sql
71	Rami Reddy	rami_reddy_tsqlchallenge_17.sql
72	Regan Wick	regan_wick_tsqlchallenge_17.sql
73	Reich Jesse	reich_jesse_tsqlchallenge_17.sql
74	Seth Phelabaum	Seth_Phelabaum_tsqlchallenge_17Attempt2.sql
75	Seth Phelabaum	Seth_Phelabaum_tsqlchallenge_17Attempt3.sql
76	Seth Phelabaum	Seth_Phelabaum_tsqlchallenge_17.sql
77	Timothy Hartford	TimothyJ_Hartford_tsqlchallenge_17.sql
78	Timothy Hartford	TimothyJ_Hartford_tsqlchallenge_17(2).sql
79	Tony Bater	tony_bater_tsqlchallenge_17.sql
80	Vamshi Chummalkar	Vamshi_Chummalkar_tsqlchallenge_17.sql
81	Veeresh Nashi	Veeresh_Nashi_tsqlchallenge_17.sql
82	Younes Abesi	younes_abesi_tsqlchallenge_17.sql