SiSense BI Evolved
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
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 Challenge 24 – Basic Testing Results

We are just done with the Basic Testing results of TSQL Challenge 24 . The results are published at http://databasechallenges.com/SQLServer/TSQL/Challenge24/basic_testing_results . The sandbox for the basic testing is available here . If your solution...
Posted: 04-03-2010 7:29 PM by Jacob Sebastian | with no comments
Filed under: , , , , , ,

Michael DeFehr explains his winning solution to TSQL Challenge 14

Michael DeFehr has written an excellent explanation of his winning solution to TSQL Challenge 14 .  Michael’s solution won the third place and you can view his winning solution here . Michael has written a blog post on his blog site explaining his...
Posted: 04-03-2010 11:53 AM by Jacob Sebastian | with no comments
Filed under: , , , , ,

TSQL Challenge 18 – The Calendar Puzzle - Winners Announced!

It is time to see the result of another challenge! We have just completed the evaluation of TSQL Challenge 18 and the results are published on the evaluation website . Unlike many of the previous challenges, this one went through a sequence of different...
Posted: 04-02-2010 9:10 PM by Jacob Sebastian | with no comments
Filed under: , , , , , ,

Mark Cowne explains his solution to TSQL Challenge 14

Mark Cowne explains the approach used in his winning solution for TSQL Challenge 14....
Posted: 03-28-2010 7:53 PM by Jacob Sebastian | with no comments
Filed under: , , , , , , ,

TSQL Challenge 22 – Basic Testing Results

Here is the Basic Testing Results of TSQL Challenge 22....
Posted: 03-26-2010 3:23 PM by Jacob Sebastian | with no comments
Filed under: , , , , , , ,

TSQL Challenge 18 – Logic Testing Results

Just announced the logic testing results of TSQL Challenge 18....
Posted: 03-25-2010 5:25 PM by Jacob Sebastian | with no comments
Filed under: , , , , , ,

TSQL Challenge 17 – Winners

I am very glad to announce the winners of TSQL Challenge 17 . There were many solutions that passed the basic testing . However, a major part of them failed the logic testing for a number of different reasons. The data we used for the logic testing is...
Posted: 03-16-2010 8:49 PM by Jacob Sebastian | with 2 comment(s)
Filed under: , , , , , , , , , , , ,

TSQL Challenge #12 – Congratulations to the winners!

We are very glad to announce the winners of TSQL Challenge 12 today. We would like to thank all the participants of TSQL Challenge 12 and would like to congratulate the winners: Greg Holecek Syed Mehroz Alam Matthieu Hodin We will be posting the winning...
Posted: 11-10-2009 8:08 PM by Jacob Sebastian | with 1 comment(s)
Filed under: ,

TSQL Challenge 6 - Solution by Arnaud Lhopiteau

  Arnaud Lhopiteau is a MCSD .NET & Senior developer at Alltitude.com, his father introduced him to database systems with R:Base in late 80’s . He loves to take care of his family, read Joe Celko’s book, smoke pipe and drink tea. Currently he...
Posted: 06-02-2009 4:28 PM by Antoine Gémis | with no comments
Filed under: ,

TSQL Challenge 6 - Solution by Cleber Augusto Martins

Cleber is a new challenger. He provides us a nice and readable solution using UNION and CROSS JOIN. Cleber Martins works for ACI Worldwide as a Sr. Business Solutions Analyst for the Risk products. Cleber is based in Brazil and has 8 years of experience...
Posted: 06-02-2009 4:27 PM by Antoine Gémis | with no comments
Filed under: ,

TSQL Challenge 6 Winners

Again there were a lot of participants for this challenge , and a lot of different solutions. Regarding all these solutions this is the short list of the winners we choose for this challenge: Arnaud Lhopiteau Arnaud Lhopiteau is a MCSD .NET & Senior...
Posted: 05-26-2009 8:24 PM by Rui Carvalho | with 1 comment(s)
Filed under: ,

TSQL Challenge 5 - Solution by Aurelien Verla

Aurelien is a new challenger that closes the initial winners of the TSQL Challenge 5. Aurelien Verla is Online Strategies Team Manager at Wygwam. Web Developer since 10 years, his first approach with databases systems was Access ! MVP around ASP.NET Platform...
Posted: 05-25-2009 8:07 PM by Rui Carvalho | with no comments
Filed under: ,

TSQL Challenge 5 - Solution by Friedrich Paul

Friedrich Paul is another many-times-winner of the TSQL Challenges. He uses like Leonid only one CTE with the same split parsing recursively mechanism . This solution is very goods in terms of code optimization (even if it is too much compressed for a...
Posted: 05-13-2009 9:52 PM by Rui Carvalho | with no comments
Filed under: , , , ,

TSQL Challenge 5 - Solution by Divya Agrawal

Divya is a new challenger that sends us a very interesting solution. She show us that it can be done without CTE in one very short and simple query. We really enjoyed her solution not only because it is a completely different solution but also because...
Posted: 05-12-2009 2:18 PM by Rui Carvalho | with 1 comment(s)
Filed under: , , ,

TSQL Challenge 5 - Solution by Leonid Koyfman

There were a lot of different solutions for this challenge but globaly the key point to release the split in line in an unique query was to use CTEs. As most people send us valuable queries with CTEs, we took in consideration also other notation points...
Posted: 05-12-2009 12:20 PM by Rui Carvalho | with no comments
Filed under: , , , , , ,
More Posts Next page »

Copyright © Beyondrelational.com