This challenge is to generate an HTML calendar based on the data stored in a table. The concept is very similar to the calendar we generate for the Quiz Series.

An ETL application receives product and category information in a text file. The category hierarchy is specified as a string. Your job is to read the hierarchy information and generate a relational table (result set) representing the hierarchy of catego

Yes, the testing is in progress. The solutions that pass the test will start showing up in the list rightaway. Wait for a blog post that announces that the testing is completed. You will also get an email notification about the success/failure status of yo

[quote user="Sergejack"]If you intend to use number above 39, I suggest you put a reminder of the Roman Number syntax.[/quote] Added a table that shows the mapping between Roman and Decimal

updated

I found that "select * from results1" works as well. what is your database collation?

Strange!! I am not able to get the error. "select * from perm3" successfully ran on my 2005, 2008 R2 and Denali instances.

Help us improve the performance evaluation process of TSQL Challenges. Share your feedback on the new testing method here

Rule added

+1