Here is the list of solutions that passed the Basic Testing of TSQL Challenge 42 – Transform rows to columns with dynamic positioning.

1		albert ulmer	albert_ulmer_tsqlchallenge_42_V1.sql
2		albert ulmer	albert_ulmer_tsqlchallenge_42_V2.sql
3		Alejandro Beltran	Alejandro_Beltran_tsqlchallenge_42_V1.sql
4		Amartha Dutta	Amartha_Dutta_tsqlchallenge_42_V1.sql
5		Amartha Dutta	Amartha_Dutta_tsqlchallenge_42_V2.sql
6		Anil Soman	Anil_Soman_tsqlchallenge_42_V3.sql
7		Arie Stern	Arie_Stern_tsqlchallenge_42_V1.sql
8		Benjamin Taylor	Benjamin_Taylor_tsqlchallenge_42_V1.sql
9		Benjamin Taylor	Benjamin_Taylor_tsqlchallenge_42_V2.sql
10		Benjamin Taylor	Benjamin_Taylor_tsqlchallenge_42_V3.sql
11		bert dehaes	bert_dehaes_tsqlchallenge_42_V1.sql
12		bert dehaes	bert_dehaes_tsqlchallenge_42_V2.sql
13		bert dehaes	bert_dehaes_tsqlchallenge_42_V3.sql
14		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V1.sql
15		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V2.sql
16		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V3.sql
17		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V4.sql
18		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V5.sql
19		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V6.sql
20		Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V8.sql
21		Ch Rao	Ch_Rao_tsqlchallenge_42_V1.sql
22		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V5.sql
23		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V6.sql
24		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V7.sql
25		dave repton	dave_repton_tsqlchallenge_42_V2.sql
26		dave repton	dave_repton_tsqlchallenge_42_V3.sql
27		David George	David_George_tsqlchallenge_42_V1.sql
28		George Aletras	George_Aletras_tsqlchallenge_42_V1.sql
29		Guenter Tschech	Guenter_Tschech_tsqlchallenge_42_V1.sql
30		Guenter Tschech	Guenter_Tschech_tsqlchallenge_42_V2.sql
31		Guenter Tschech	Guenter_Tschech_tsqlchallenge_42_V3.sql
32		Hagit Badash	Hagit_Badash_tsqlchallenge_42_V1.sql
33		Ira Sinha	Ira_Sinha_tsqlchallenge_42_V2.sql
34		Jason Covey	Jason_Covey_tsqlchallenge_42_V1.sql
35		Jason Covey	Jason_Covey_tsqlchallenge_42_V3.sql
36		Jason Covey	Jason_Covey_tsqlchallenge_42_V4.sql
37		Jason Covey	Jason_Covey_tsqlchallenge_42_V2.sql
38		Jim Lin	Jim_Lin_tsqlchallenge_42_V1.sql
39		Jorg Jansen	Jorg_Jansen_tsqlchallenge_42_V1.sql
40		jose chama	jose_chama_tsqlchallenge_42_V1.sql
41		Joshua Duewer	Joshua_Duewer_tsqlchallenge_42_V1.sql
42		Laura Cassidy	Laura_Cassidy_tsqlchallenge_42_V1.sql
43		leigh waldie	leigh_waldie_tsqlchallenge_42_V3.sql
44		leigh waldie	leigh_waldie_tsqlchallenge_42_V1.sql
45		leigh waldie	leigh_waldie_tsqlchallenge_42_V2.sql
46		leo ruzin	leo_ruzin_tsqlchallenge_42_V3.sql
47		leo ruzin	leo_ruzin_tsqlchallenge_42_V1.sql
48		leo ruzin	leo_ruzin_tsqlchallenge_42_V2.sql
49		leonid koyfman	leonid_koyfman_tsqlchallenge_42_V1.sql
50		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_42_V1.sql
51		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_42_V2.sql
52		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_42_V3.sql
53		Luke Marshall	Luke_Marshall_tsqlchallenge_42_V1.sql
54		Lutz Mueller	Lutz_Mueller_tsqlchallenge_42_V1.sql
55		Marcos Kirchner	Marcos_Kirchner_tsqlchallenge_42_V1.sql
56		Mariza Löb	Mariza_Löb_tsqlchallenge_42_V1.sql
57		mark cowne	mark_cowne_tsqlchallenge_42_V1.sql
58		mark cowne	mark_cowne_tsqlchallenge_42_V2.sql
59		meierruth michael	meierruth_michael_tsqlchallenge_42_V1.sql
60		Michael Flanigan	Michael_Flanigan_tsqlchallenge_42_V1.sql
61		Michael Lignos	Michael_Lignos_tsqlchallenge_42_V3.sql
62		Mike Scalise	Mike_Scalise_tsqlchallenge_42_V1.sql
63		Mike Scalise	Mike_Scalise_tsqlchallenge_42_V2.sql
64		Mike Scalise	Mike_Scalise_tsqlchallenge_42_V3.sql
65		Mike Scalise	Mike_Scalise_tsqlchallenge_42_V4.sql
66		Nikola Ilijev	Nikola_Ilijev_tsqlchallenge_42_V2.sql
67		Nikola Ilijev	Nikola_Ilijev_tsqlchallenge_42_V1.sql
68		nimesh shah	nimesh_shah_tsqlchallenge_42_V1.sql
69		Olga Medvedeva	Olga_Medvedeva_tsqlchallenge_42_V1.sql
70		Otto Csatari	Otto_Csatari_tsqlchallenge_42_V1.sql
71		paul atkinson	paul_atkinson_tsqlchallenge_42_V3.sql
72		paul atkinson	paul_atkinson_tsqlchallenge_42_V1.sql
73		paul atkinson	paul_atkinson_tsqlchallenge_42_V2.sql
74		phil dutton	phil_dutton_tsqlchallenge_42_V1.sql
75		pranay sane	pranay_sane_tsqlchallenge_42_V2.sql
76		pranay sane	pranay_sane_tsqlchallenge_42_V1.sql
77		Pulastya Mitra	Pulastya_Mitra_tsqlchallenge_42_V2.sql
78		Rahul Verma	Rahul_Verma_tsqlchallenge_42_V2.sql
79		Ramesh Saive	Ramesh_Saive_tsqlchallenge_42_V1.sql
80		Razvan Socol	Razvan_Socol_tsqlchallenge_42_V1.sql
81		Samir Matkar	Samir_Matkar_tsqlchallenge_42_V1.sql
82		sanjay Patel	sanjay_Patel_tsqlchallenge_42_V1.sql
83		Scot Hauder	Scot_Hauder_tsqlchallenge_42_V1.sql
84		Scott Sutch	Scott_Sutch_tsqlchallenge_42_V1.sql
85		Sean Bowden	Sean_Bowden_tsqlchallenge_42_V1.sql
86		Simon Wadsworth	Simon_Wadsworth_tsqlchallenge_42_V1.sql
87		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_42_V1.sql
88		Stefan G	Stefan_G_tsqlchallenge_42_V1.sql
89		Szymon Wojcik	Szymon_Wojcik_tsqlchallenge_42_V3.sql
90		Szymon Wojcik	Szymon_Wojcik_tsqlchallenge_42_V2.sql
91		Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V1.sql
92		Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V2.sql
93		Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V3.sql
94		Tihomir Purgar	Tihomir_Purgar_tsqlchallenge_42_V1.sql
95		tomaz kastrun	tomaz_kastrun_tsqlchallenge_42_V1.sql
96		Waqar Amin	Waqar_Amin_tsqlchallenge_42_V1.sql
97		Yi Liu	Yi_Liu_tsqlchallenge_42_V1.sql
98		Yi Liu	Yi_Liu_tsqlchallenge_42_V2.sql
99		Zbigniew Borowski	Zbigniew _Borowski_tsqlchallenge_42_V1.sql
100		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_42_V2.sql

Note that the challenges are 'always ON', which means that you can submit a solution at any time. You can submit a new solution even after the results are published.