beyondrelational.com

Getting Started with ASP.NET MVC - Part 6: ASP.NET MVC and Entity Framework

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

TSQL Challenges


Subscribe By Email

Contact US

Pushing database changes needn't be hard work with SQL Compare

Top Winners

	leszek_g	232
	Stefan_G	176
	dishdy	106
	malpashaa	101
	Mark	86
View all

Winning Solutions

Here is the list of submissions we received for TSQL Challenge 42 – Transform rows to columns with dynamic positioning.

1		sultanahmed_sultanahmed_tsqlchallenge_42_V6138.sql
2	albert ulmer	albert_ulmer_tsqlchallenge_42_V1.sql
3	albert ulmer	albert_ulmer_tsqlchallenge_42_V2.sql
4	Alejandro Beltran	Alejandro_Beltran_tsqlchallenge_42_V1.sql
5	Amartha Dutta	Amartha_Dutta_tsqlchallenge_42_V1.sql
6	Amartha Dutta	Amartha_Dutta_tsqlchallenge_42_V2.sql
7	Anil Soman	Anil_Soman_tsqlchallenge_42_V1.sql
8	Anil Soman	Anil_Soman_tsqlchallenge_42_V2.sql
9	Anil Soman	Anil_Soman_tsqlchallenge_42_V3.sql
10	anu radha	anu_radha_tsqlchallenge_42_V1.sql
11	Arie Stern	Arie_Stern_tsqlchallenge_42_V1.sql
12	Artem Antonov	Artem_Antonov_tsqlchallenge_42_V1.sql
13	Benjamin Taylor	Benjamin_Taylor_tsqlchallenge_42_V1.sql
14	Benjamin Taylor	Benjamin_Taylor_tsqlchallenge_42_V2.sql
15	Benjamin Taylor	Benjamin_Taylor_tsqlchallenge_42_V3.sql
16	bert dehaes	bert_dehaes_tsqlchallenge_42_V2.sql
17	bert dehaes	bert_dehaes_tsqlchallenge_42_V3.sql
18	bert dehaes	bert_dehaes_tsqlchallenge_42_V1.sql
19	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V1.sql
20	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V2.sql
21	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V3.sql
22	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V4.sql
23	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V5.sql
24	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V6.sql
25	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V7.sql
26	Carlos Klapp	Carlos_Klapp_tsqlchallenge_42_V8.sql
27	Ch Rao	Ch_Rao_tsqlchallenge_42_V1.sql
28	chandu penmetsa	chandu_penmetsa_tsqlchallenge_42_V1.sql
29	Chirag Parikh	Chirag_Parikh_tsqlchallenge_42_V1.sql
30	Craig Patterson	Craig_Patterson_tsqlchallenge_42_V1.sql
31	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V1.sql
32	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V2.sql
33	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V3.sql
34	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V4.sql
35	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V5.sql
36	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V6.sql
37	Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_42_V7.sql
38	dave repton	dave_repton_tsqlchallenge_42_V1.sql
39	dave repton	dave_repton_tsqlchallenge_42_V2.sql
40	dave repton	dave_repton_tsqlchallenge_42_V3.sql
41	David George	David_George_tsqlchallenge_42_V1.sql
42	George Aletras	George_Aletras_tsqlchallenge_42_V1.sql
43	Guenter Tschech	Guenter_Tschech_tsqlchallenge_42_V1.sql
44	Guenter Tschech	Guenter_Tschech_tsqlchallenge_42_V2.sql
45	Guenter Tschech	Guenter_Tschech_tsqlchallenge_42_V3.sql
46	Gyan Garg	Gyan_Garg_tsqlchallenge_42_V1.sql
47	Hagit Badash	Hagit_Badash_tsqlchallenge_42_V1.sql
48	Ira Sinha	Ira_Sinha_tsqlchallenge_42_V1.sql
49	Ira Sinha	Ira_Sinha_tsqlchallenge_42_V2.sql
50	Jason Covey	Jason_Covey_tsqlchallenge_42_V2.sql
51	Jason Covey	Jason_Covey_tsqlchallenge_42_V1.sql
52	Jason Covey	Jason_Covey_tsqlchallenge_42_V3.sql
53	Jason Covey	Jason_Covey_tsqlchallenge_42_V4.sql
54	Jim Lin	Jim_Lin_tsqlchallenge_42_V1.sql
55	Jorg Jansen	Jorg_Jansen_tsqlchallenge_42_V1.sql
56	jose chama	jose_chama_tsqlchallenge_42_V1.sql
57	Joshua Duewer	Joshua_Duewer_tsqlchallenge_42_V1.sql
58	Laura Cassidy	Laura_Cassidy_tsqlchallenge_42_V1.sql
59	leigh waldie	leigh_waldie_tsqlchallenge_42_V3.sql
60	leigh waldie	leigh_waldie_tsqlchallenge_42_V1.sql
61	leigh waldie	leigh_waldie_tsqlchallenge_42_V2.sql
62	leo ruzin	leo_ruzin_tsqlchallenge_42_V3.sql
63	leo ruzin	leo_ruzin_tsqlchallenge_42_V1.sql
64	leo ruzin	leo_ruzin_tsqlchallenge_42_V2.sql
65	leonid koyfman	leonid_koyfman_tsqlchallenge_42_V1.sql
66	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_42_V1.sql
67	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_42_V2.sql
68	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_42_V3.sql
69	Lucas Beristayn	Lucas_Beristayn_tsqlchallenge_42_V1.sql
70	Lukasz Berezowski	Lukasz_Berezowski_tsqlchallenge_42_V1.sql
71	Luke Marshall	Luke_Marshall_tsqlchallenge_42_V1.sql
72	Lutz Mueller	Lutz_Mueller_tsqlchallenge_42_V1.sql
73	Marcos Kirchner	Marcos_Kirchner_tsqlchallenge_42_V1.sql
74	Mariza Löb	Mariza_Löb_tsqlchallenge_42_V1.sql
75	mark cowne	mark_cowne_tsqlchallenge_42_V2.sql
76	mark cowne	mark_cowne_tsqlchallenge_42_V1.sql
77	meierruth michael	meierruth_michael_tsqlchallenge_42_V1.sql
78	Michael Flanigan	Michael_Flanigan_tsqlchallenge_42_V1.sql
79	Michael Lignos	Michael_Lignos_tsqlchallenge_42_V1.sql
80	Michael Lignos	Michael_Lignos_tsqlchallenge_42_V2.sql
81	Michael Lignos	Michael_Lignos_tsqlchallenge_42_V3.sql
82	Mike Scalise	Mike_Scalise_tsqlchallenge_42_V1.sql
83	Mike Scalise	Mike_Scalise_tsqlchallenge_42_V2.sql
84	Mike Scalise	Mike_Scalise_tsqlchallenge_42_V3.sql
85	Mike Scalise	Mike_Scalise_tsqlchallenge_42_V4.sql
86	Mike Scalise	Mike_Scalise_tsqlchallenge_42_V5.sql
87	Mike Swoveland	Mike_Swoveland_tsqlchallenge_42_V1.sql
88	Nikola Ilijev	Nikola_Ilijev_tsqlchallenge_42_V1.sql
89	Nikola Ilijev	Nikola_Ilijev_tsqlchallenge_42_V2.sql
90	nimesh shah	nimesh_shah_tsqlchallenge_42_V1.sql
91	Olga Medvedeva	Olga_Medvedeva_tsqlchallenge_42_V1.sql
92	Otto Csatari	Otto_Csatari_tsqlchallenge_42_V1.sql
93	paul atkinson	paul_atkinson_tsqlchallenge_42_V1.sql
94	paul atkinson	paul_atkinson_tsqlchallenge_42_V2.sql
95	paul atkinson	paul_atkinson_tsqlchallenge_42_V3.sql
96	phil dutton	phil_dutton_tsqlchallenge_42_V1.sql
97	pranay sane	pranay_sane_tsqlchallenge_42_V2.sql
98	pranay sane	pranay_sane_tsqlchallenge_42_V1.sql
99	Pulastya Mitra	Pulastya_Mitra_tsqlchallenge_42_V1.sql
100	Pulastya Mitra	Pulastya_Mitra_tsqlchallenge_42_V2.sql
101	Rahul Verma	Rahul_Verma_tsqlchallenge_42_V1.sql
102	Rahul Verma	Rahul_Verma_tsqlchallenge_42_V2.sql
103	Rajesh R	Rajesh_R_tsqlchallenge_42_V1.sql
104	Ramesh Saive	Ramesh_Saive_tsqlchallenge_42_V1.sql
105	Razvan Socol	Razvan_Socol_tsqlchallenge_42_V1.sql
106	Remek Hetman	Remek_Hetman_tsqlchallenge_42_V1.sql
107	Samir Matkar	Samir_Matkar_tsqlchallenge_42_V1.sql
108	sanjay Patel	sanjay_Patel_tsqlchallenge_42_V1.sql
109	Scot Hauder	Scot_Hauder_tsqlchallenge_42_V1.sql
110	Scott Sutch	Scott_Sutch_tsqlchallenge_42_V1.sql
111	Sean Bowden	Sean_Bowden_tsqlchallenge_42_V1.sql
112	Simon Wadsworth	Simon_Wadsworth_tsqlchallenge_42_V1.sql
113	Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_42_V1.sql
114	Stefan G	Stefan_G_tsqlchallenge_42_V1.sql
115	Szymon Wojcik	Szymon_Wojcik_tsqlchallenge_42_V1.sql
116	Szymon Wojcik	Szymon_Wojcik_tsqlchallenge_42_V2.sql
117	Szymon Wojcik	Szymon_Wojcik_tsqlchallenge_42_V3.sql
118	Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V4.sql
119	Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V2.sql
120	Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V3.sql
121	Thiago Dantas	Thiago_Dantas_tsqlchallenge_42_V1.sql
122	Tihomir Purgar	Tihomir_Purgar_tsqlchallenge_42_V1.sql
123	tomaz kastrun	tomaz_kastrun_tsqlchallenge_42_V1.sql
124	Varsha Ramnani	Varsha_Ramnani_tsqlchallenge_42_V1.sql
125	Waqar Amin	Waqar_Amin_tsqlchallenge_42_V1.sql
126	William Glover	William_Glover_tsqlchallenge_42_V1.sql
127	William Glover	William_Glover_tsqlchallenge_42_V2.sql
128	Yi Liu	Yi_Liu_tsqlchallenge_42_V2.sql
129	Yi Liu	Yi_Liu_tsqlchallenge_42_V1.sql
130	Zbigniew Borowski	Zbigniew _Borowski_tsqlchallenge_42_V1.sql
131	Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_42_V2.sql

If you have submitted a solution through email or using the media library and don't see it here, contact us