We received a large number of solutions for this challenge. While almost all the solutions produced the expected results, some solutions were disqualified because they did not follow the guidelines provided with the challenge. A number of solutions were disqualified due to one or more of the following reasons
- Using Temp Tables
- Using Table Variables
- Using Local Variables
- Using WHILE Loops
- Using Cursors
- Using UDFs
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. If your solution is disqualified due to one of the reasons given above, you can re-submit a new version of the challenge at any time.
Here is the list of solutions that are accepted for further processing.
- Adam Machanic (2)
- Adam Machanic (1)
- Adan Bucio
- Alexander Kovacs
- Alexandr Makhin
- Alexandre Dias
- Amir Shaikh
- Andrewd Smith
- Anulas Vp
- Arumugam Thiraviam
- Auke Zijlstra
- Aurelien Verla (2)
- Aurelien Verla (1)
- Bailey Rollins
- Ben Flanaghan
- Benjamin Clark
- Beth Seefelt
- Bill Sheets
- Bret Warnick
- Brian Filppu
- Carl Federl (2)
- Carl Federl (1)
- Chenghui Wang
- Chuck Rhoads
- Dalibor Margotic
- Dana White
- Dave Ballantyne (1)
- Dave Turpin
- David Betteridge
- Des Norton
- Divya
- Ed Croker
- Fabien Contaminard (2)
- Fabien Contaminard (1)
- Hodin Matthieu
- Ibrahim EM
- Jacky Yin (1)
- Jacky Yin (2)
- Jacky Yin (3)
- Jakob Eskar
- Jay Jetley
- Jay Mccormick
- Anonymous (1)
- Jesse Mclain
- Jareich
- Joe Jameson
- Kalyanasundaram N
- Karin Nooteboom
- kevan Riley
- Kevin Suchlicki (1)
- Kevin Suchlicki (2)
- Kyle Dabrowski
- Leonid Koyfman
- Letser Herrera (1)
- Letser Herrera (2)
- Lisa Kwok
- Mark Cowne (1)
- Mark Cowne (2)
- Mark Wills
- Michael Coles
- Mike DeFehr
- Michael Wright
- Micheal Young
- Mitesh Oswal (1)
- Mitesh Oswal (2)
- Narasimharao kompella
- Niladri Biswas
- Parth Patel
- Paul Atkinson
- Paul Heiser
- Peter Chambers
- Phill Dutton
- R barry Young (2)
- Regan Wick (2)
- Regan Wick (3)
- Regan Wick (1)
- Rhodri Evans
- Serge Jacquemin
- Stefan Oude Vrielink (1)
- Stefan Oude Vrielink (2)
- Stephen Carter
- Steve Howard
- Stevet
- Steve Woodward
- Syed Mehroz (1)
- Syed Mehroz (2)
- Toby White
- Tom Cooper
- Tony Bater
- Vamsi Bogullu (2)
- Wim Buyens
- Younes Abesi (1)
- Younes Abesi (2)
Never submitted a solution? Or got a new/different version? Submit it