Here is the list of solutions that passed the Basic Testing of TSQL Challenge 39 - Calculate Gross Profit by Item using FIFO method.

1		Aash Ram	Aash_Ram_tsqlchallenge_39_V1.sql
2		Aash Ram	Aash_Ram_tsqlchallenge_39_V2.sql
3		Aash Ram	Aash_Ram_tsqlchallenge_39_V3.sql
4		albert ulmer	albert_ulmer_tsqlchallenge_39_V1.sql
5		Amish Shukla	Amish_Shukla_tsqlchallenge_39_V3.sql
6		Andrew Yi	Andrew_Yi_tsqlchallenge_39_V1.sql
7		Antony Clark	Antony_Clark_tsqlchallenge_39_V1.sql
8		Artem Antonov	Artem_Antonov_tsqlchallenge_39_V1.sql
9		bret warnick	bret_warnick_tsqlchallenge_39_V2.sql
10		bret warnick	bret_warnick_tsqlchallenge_39_V3.sql
11		carlos benito	carlos_benito_tsqlchallenge_39_V2.sql
12		Chaitanya Panduga	Chaitanya_Panduga_tsqlchallenge_39_V2.sql
13		Chaitanya Panduga	Chaitanya_Panduga_tsqlchallenge_39_V1.sql
14		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_39_V1.sql
15		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_39_V2.sql
16		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_39_V3.sql
17		Daniel M	Daniel_M_tsqlchallenge_39_V1.sql
18		dave repton	dave_repton_tsqlchallenge_39_V2.sql
19		dave repton	dave_repton_tsqlchallenge_39.sql
20		david betteridge	david_betteridge_tsqlchallenge_39_V1.sql
21		Dawn Hoffmann	Dawn_Hoffmann_tsqlchallenge_39_V1.sql
22		Debdutta Nath	Debdutta_Nath_tsqlchallenge_39_V1.sql
23		Debdutta Nath	Debdutta_Nath_tsqlchallenge_39_V2.sql
24		Hans Stuer	Hans_Stuer_tsqlchallenge_39.sql
25		Hans Stuer	Hans_Stuer_tsqlchallenge_39_V2.sql
26		James Travis	James_Travis_tsqlchallenge_39_V1.sql
27		Jasper Ziller	Jasper_Ziller_tsqlchallenge_39.sql
28		Jonathan Payne	Jonathan_Payne_tsqlchallenge_39_V1.sql
29		jonathan roberts	jonathan_roberts_tsqlchallenge_39_V2.sql
30		jonathan roberts	jonathan_roberts_tsqlchallenge_39_V1.sql
31		Jorge Arturo Cardenas	JorgeArturo_Cardenas_tsqlchallenge_39_V1.sql
32		Kevin Wu	Kevin_Wu_tsqlchallenge_39_V1.sql
33		leo ruzin	leo_ruzin_tsqlchallenge_39_V2.sql
34		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_39_V5.sql
35		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_39_V6.sql
36		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_39_v2.sql
37		Lourens van Schalkwyk	Lourens_vanSchalkwyk_tsqlchallenge_39_V1.sql
38		Lutz Mueller	Lutz_Mueller_tsqlchallenge_39_V1.sql
39		Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_39_V1.sql
40		Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_39_V2.sql
41		Maxim Spektorenko	Maxim_Spektorenko_tsqlchallenge_39_V1.sql
42		mazhar ehsan	mazhar_ehsan_tsqlchallenge_39_V7.sql
43		mazhar ehsan	mazhar_ehsan_tsqlchallenge_39_V6.sql
44		mazhar ehsan	mazhar_ehsan_tsqlchallenge_39_V1.sql
45		mazhar ehsan	mazhar_ehsan_tsqlchallenge_39_V3.sql
46		mazhar ehsan	mazhar_ehsan_tsqlchallenge_39_V5.sql
47		meierruth michael	meierruth_michael_tsqlchallenge_39_V2.sql
48		meierruth michael	meierruth_michael_tsqlchallenge_39_V1.sql
49		Mingjie Liu	Mingjie_Liu_tsqlchallenge_39_V1.sql
50		Mingjie Liu	Mingjie_Liu_tsqlchallenge_39_V2.sql
51		Mingjie Liu	Mingjie_Liu_tsqlchallenge_39_V3.sql
52		Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_39_V1.sql
53		Olga Medvedeva	Olga_Medvedeva_tsqlchallenge_39_V1.sql
54		Otto Csatari	Otto_Csatari_tsqlchallenge_39_V4.sql
55		Otto Csatari	Otto_Csatari_tsqlchallenge_39_V2.sql
56		Otto Csatari	Otto_Csatari_tsqlchallenge_39_V1.sql
57		phil dutton	phil_dutton_tsqlchallenge_39_V1.sql
58		Powichrowski Marek	Powichrowski_Marek_tsqlchallenge_39_v2.sql
59		Powichrowski Marek	Powichrowski_Marek_tsqlchallenge_39_v3.sql
60		Powichrowski Marek	Powichrowski_Marek_tsqlchallenge_39_V1.sql
61		Powichrowski Marek	Powichrowski_Marek_tsqlchallenge_39_V5.sql
62		Powichrowski Marek	Powichrowski_Marek_tsqlchallenge_39_V6.sql
63		pranay sane	pranay_sane_tsqlchallenge_39_V2.sql
64		pranay sane	pranay_sane_tsqlchallenge_39_V1.sql
65		Pulastya Mitra	Pulastya_Mitra_tsqlchallenge_39_v1.sql
66		R Hansen	R_Hansen_tsqlchallenge_39_V1.sql
67		R Hansen	R_Hansen_tsqlchallenge_39_V2.sql
68		richard harper	richard_harper_tsqlchallenge_39_V1.sql
69		richard harper	richard_harper_tsqlchallenge_39_V2.sql
70		richard harper	richard_harper_tsqlchallenge_39_V3.sql
71		richard harper	richard_harper_tsqlchallenge_39_V4.sql
72		richard romley	richard_romley_tsqlchallenge_39_V1.sql
73		richard romley	richard_romley_tsqlchallenge_39_V2.sql
74		Richard Romley	Richard_Romley_tsqlchallenge_39_V4.sql
75		Richard Romley	Richard_Romley_tsqlchallenge_39_V5.sql
76		Rodney Workman	Rodney_Workman_tsqlchallenge_39_V1.sql
77		Rodney Workman	Rodney_Workman_tsqlchallenge_39_V2.sql
78		sapna veluri	sapna_veluri_tsqlchallenge_39_V1.sql
79		Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_39_V1.sql
80		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_39_V1.sql
81		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_39_V2.sql
82		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_39_V3.sql
83		slawomir swietoniowski	slawomir_swietoniowski_tsqlchallenge_39_V2.sql
84		Stanislav Vorobiev	Stanislav_Vorobiev_tsqlchallenge_39_V1.sql
85		Stefan G	Stefan_G_tsqlchallenge_39_V6.sql
86		Stefan G	Stefan_G_tsqlchallenge_39_V1.sql
87		Stefan G	Stefan_G_tsqlchallenge_39_V2.sql
88		Stefan G	Stefan_G_tsqlchallenge_39_V3.sql
89		Stefan G	Stefan_G_tsqlchallenge_39_V5.sql
90		Stefan G	Stefan_G_tsqlchallenge_39_V4.sql
91		tommy hogman	tommy_hogman_tsqlchallenge_39_V1.sql
92		vadim parfilko	vadim_parfilko_tsqlchallenge_39_V1.sql
93		Wattana Saelim	Wattana_Saelim_tsqlchallenge_39_V1.sql
94		yunus simjee	yunus_simjee_tsqlchallenge_39_V1.sql
95		yunus simjee	yunus_simjee_tsqlchallenge_39_V2.sql
96		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_39_V1.sql
97		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_39_V2.sql
98		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_39_V3.sql
99		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_39_V4.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.