Browse by Tags
All Tags »
TSQL (
RSS)
In my previous post I mentioned that we have setup a new home page for TSQL Challenges. The URL is http://beyondrelational.com/tc.aspx . We have been working on displaying the names of people with most SQL Stars on the page and I am very happy to announce...
We are getting ready for the logic testing of TSQL Challenge 18 . The tricky data for the logic testing is published at http://databasechallenges.com/SQLServer/TSQL/Challenge18/logic_testing . We will test the solutions with SQL Server language settings...
We just published the basic testing results of TSQL Challenge 18 . You can find them on http://databasechallenges.com/SQLServer/TSQL/Challenge18/basic_testing_results . Almost half of the solutions failed to produce the EXACT output specified in the challenge...
We have reviewed all the solutions received so far and the list of accepted solutions is posted at http://databasechallenges.com/SQLServer/TSQL/challenge19/accepted . If you don’t see your submission in the list please let us know. We integrated an email...
We have started the evaluation of TSQL Challenge 19 and here is the list of submission we received till 26 Feb 2010. You can find the list of all the solutions at http://databasechallenges.com/sqlserver/tsql/challenge19/submissions . Solutions submitted...
We have reviewed all the solutions we received for TSQL Challenge 18 . A list of solutions accepted and queued for further processing is published at http://databasechallenges.com/SQLServer/TSQL/Challenge18/accepted . This includes all the solutions we...
Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here...
This challenge has absolutely no relevance to a real-life problem, but it is very interesting because it tests your programming skills and abstract thinking. The Fibonacci series is defined as 1, 1, 2, 3, 5, 8, 13, 21, 34, 55 etc, where each number in...
Working with hierarchies is almost always lot of fun for most of us. Traversing heirarchies and processing data from child or parent nodes is really interesting and such assignments are ideal opportunities to test your logic and query writing skills....
This is the first time we are coming up with a true calendar puzzle. Brad Schulz from TSQL Challenges Team has come up with a very interesting challenge which is all about generating calendars for given number of months. While the real-world application...
Challenge Context This challenge is derived from a real scenario discussed in a forum. It mainly deals about finding intersections in date ranges. The original source of data will be a table of persons with their member ship: Description StartDate EndDate...
This challenge is derived from a realistic reporting scenario that requires the transformation of rows into columns. This is commonly known as a matrix, pivot, or crosstab query. This challenge involves two primary tables @Row and @Cols. The objective...
Brad Schulz Brad has been working with databases for 30 years. He was a Microsoft Visual FoxPro (VFP) MVP from 1994-2000, and has written articles for various VFP publications. He now devotes most of his time to SQL Server and is a moderator at the MSDN...
Peter Larsson Professional database developer since 2001. Started to use Microsoft SQL Server in 1993, and have been true since then. He mostly working with performance troubleshooting and database architecturing. How did Peter work on the challenge?...
Thanks to All First and foremost TSQL Challenges would like to say thank you to all the participants. TSQL Challenges relies on your participation to bring the SQL Server community together. Our mission at TSQL Challenges is to get the SQL Server community...
More Posts
Next page »