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.

Tricky Data for TSQL Challenge 25

I have been struggling to clear the evaluation queue and was badly in need for help to speed up the process. Seth offered to help and took the responsibility of building the tricky data for TSQL Challenge 25.

Seth has put quite a lot of efforts into this and has come up with a sandbox along with some tricky data for this challenge. You can see the sandbox here. I would recommend you all read his blog post that explains the factors he considered while building the above data.

The first version of the sandbox had a couple of issues which some of you notified my privately. The version we just uploaded has taken care of all the problems reported so far. I would request you all to take a look at the sandbox and try to run your solutions on that and let us know if you spot something that needs correction.


Share

Comments

# re: Tricky Data for TSQL Challenge 25

Thursday, April 15, 2010 6:38 AM by karinloos

I do have one issue.   In the basic testing sandbox, the date is expected as a varchar(10) field in the format yyyy-mm-dd

In the logic testing this is a smalldatetime.

This does provide some conversion issues.  I have a solution which passes the logic testing, but fails basic due to a date formatting issue.

Regardless of whether or not this could or could not be possible to achieve,  the expected output data should be of the same format and type through all testing to avoid unnecessary fails.


# re: Tricky Data for TSQL Challenge 25

Thursday, April 15, 2010 7:49 AM by Jacob Sebastian

Updated..Does it look good now?


# re: Tricky Data for TSQL Challenge 25

Thursday, April 15, 2010 8:53 AM by karinloos

Yes thank you


Copyright © Beyondrelational.com