Facebook Twitter Sign in | Join
Pushing database changes needn't be hard work with SQL Compare
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 Challenge 18 – Basic Testing Results

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 description. If you see that your solution did not pass the basic testing, we would suggest you review the results of your solution and make sure that it matches 100% with the output given in the challenge. If you still could not spot the problem with your solution, contact us and we will let you  know what went wrong with your solution.

We are currently integrating the notification module to the evaluation process, so that you will get a notification at each evaluation phase. If your solution fails, the notification will give you the exact reason for the failure. Till the notification is fully integrated, you can contact us and we will do it manually.


 Share

Related Posts

Re-evaluation of TSQL Challenge 18 completed

TSQL Challenge 18 – The Calendar Puzzle - Winners Announced!

TSQL Challenge 18 – Logic Testing Results

Tricky data for TSQL Challenge 18 – English, Swedish and Czech

TSQL Challenge 18 – Accepted solutions

TSQL Challenge #18 – Evaluation Started

TSQL Challenge 18 - Generate text formatted month calendars

Comments

# re: TSQL Challenge 18 – Basic Testing Results

Monday, March 08, 2010 10:32 AM by karinloos

I just checked the basic testing results and my solution is not amongst those listed, however when i run my solution against the data provided i get the results u require.

Is this a little bug of the new system you are using?

# re: TSQL Challenge 18 – Basic Testing Results

Monday, March 08, 2010 10:52 AM by karinloos

Further to my above comment, I notice that my 2nd solution which i submitted which limited the output to 31 chars was not amongst the "all solutions" or accepted solutions, possibly this is the problem. I thought initially maybe that solution 2 had replaced solution 1 , but in retrospect possibly this is why my solution had not passed basic testing.

# re: TSQL Challenge 18 – Basic Testing Results

Monday, March 08, 2010 11:28 AM by Jacob Sebastian

@karinloos,

It could be that the solution got overwritten due to the two submissions. It usually happens if you submit two files with the same name. You should add a version number to the end of the file to differentiate it with the previous submission.

I found that you are leaving two spaces between the month name and the year "FEBRUARY  2010" instead of "FEBRUARY 2010" in the solution that failed.

# re: TSQL Challenge 18 – Basic Testing Results

Monday, March 08, 2010 11:31 AM by karinloos

How does one go about uploading the correct solution

# re: TSQL Challenge 18 – Basic Testing Results

Monday, March 08, 2010 11:37 AM by Jacob Sebastian

If you have two version of your solution, you can add a version number to the end, such as "jacob_sebastian_tsqlchallenge_24_1.sql" and "jacob_sebastian_tsqlchallenge_24_2.sql" where the 1 and 2 at the end of the file name differentiates the submissions.

You can go ahead and resubmit your correct solution to the media library.

# re: TSQL Challenge 18 – Basic Testing Results

Tuesday, March 09, 2010 4:52 AM by karinloos

Thank you , i have uploaded the corrected solution

# re: TSQL Challenge 18 – Basic Testing Results

Wednesday, March 10, 2010 8:58 AM by karinloos

At which point do you re-evaluate resubmissions?

# re: TSQL Challenge 18 – Basic Testing Results

Wednesday, March 10, 2010 9:26 AM by Jacob Sebastian

It varies. This submission will go with the evaluation process that we will do over this weekend.

Copyright © Beyondrelational.com