Home › SQL Server Challenges › TSQL Challenges › TSQL Challenge 14

TSQL Challenge 14 - Accepted Solutions

Wed, 12/16/2009 - 17:28 — jacob

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.

  1. Adam Machanic (2)
  2. Adam Machanic (1)
  3. Adan Bucio
  4. Alexander Kovacs
  5. Alexandr Makhin
  6. Alexandre Dias
  7. Amir Shaikh
  8. Andrewd Smith
  9. Anulas Vp
  10. Arumugam Thiraviam
  11. Auke Zijlstra
  12. Aurelien Verla (2)
  13. Aurelien Verla (1)
  14. Bailey Rollins
  15. Ben Flanaghan
  16. Benjamin Clark
  17. Beth Seefelt
  18. Bill Sheets
  19. Bret Warnick
  20. Brian Filppu
  21. Carl Federl (2)
  22. Carl Federl (1)
  23. Chenghui Wang
  24. Chuck Rhoads
  25. Dalibor Margotic
  26. Dana White
  27. Dave Ballantyne (1)
  28. Dave Turpin
  29. David Betteridge
  30. Des Norton
  31. Divya
  32. Ed Croker
  33. Fabien Contaminard (2)
  34. Fabien Contaminard (1)
  35. Hodin Matthieu
  36. Ibrahim EM
  37. Jacky Yin (1)
  38. Jacky Yin (2)
  39. Jacky Yin (3)
  40. Jakob Eskar
  41. Jay Jetley
  42. Jay Mccormick
  43. Anonymous (1)
  44. Jesse Mclain
  45. Jareich
  46. Joe Jameson
  47. Kalyanasundaram N
  48. Karin Nooteboom
  49. kevan Riley
  50. Kevin Suchlicki (1)
  51. Kevin Suchlicki (2)
  52. Kyle Dabrowski
  53. Leonid Koyfman
  54. Letser Herrera (1)
  55. Letser Herrera (2)
  56. Lisa Kwok
  57. Mark Cowne (1)
  58. Mark Cowne (2)
  59. Mark Wills
  60. Michael Coles
  61. Mike DeFehr
  62. Michael Wright
  63. Micheal Young
  64. Mitesh Oswal (1)
  65. Mitesh Oswal (2)
  66. Narasimharao kompella
  67. Niladri Biswas
  68. Parth Patel
  69. Paul Atkinson
  70. Paul Heiser
  71. Peter Chambers
  72. Phill Dutton
  73. R barry Young (2)
  74. Regan Wick (2)
  75. Regan Wick (3)
  76. Regan Wick (1)
  77. Rhodri Evans
  78. Serge Jacquemin
  79. Stefan Oude Vrielink (1)
  80. Stefan Oude Vrielink (2)
  81. Stephen Carter
  82. Steve Howard
  83. Stevet
  84. Steve Woodward
  85. Syed Mehroz (1)
  86. Syed Mehroz (2)
  87. Toby White
  88. Tom Cooper
  89. Tony Bater
  90. Vamsi Bogullu (2)
  91. Wim Buyens
  92. Younes Abesi (1)
  93. Younes Abesi (2)

Never submitted a solution? Or got a new/different version? Submit it