Database Challenges

TSQL Challenge 26 - Identify weekly schedule of training programs by course, classroom and timing

Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your challenge is to read the source data and build an output result set that shows the weekly schedule of each training topic and the class room in which training is scheduled.

What is tricky about this challenge is that your solution should work on SQL Server 2000. It indicates that you cannot use the new features introduced in SQL Server 2005, such as XML, PIVOT etc.

This challenge reminds us how difficult a simple problem was, back in the SQL Server 2000 days.

• TSQL Challenge 26 - All Solutions
• TSQL Challenge 26 - Accepted Solutions
• TSQL Challenge 26 - Basic Testing Sandbox (SQL Server 2000 Version)
• TSQL Challenge 26 - Basic Testing Sandbox
• TSQL Challenge 26 - Basic Testing Results
• TSQL Challenge 26 - Logic Testing Sandbox
• TSQL Challenge 26 - Logic Testing Results
• TSQL Challenge 26 - Performance Testing Data
• TSQL Challenge 26 - Performance Testing Results
• TSQL Challenge 26 - Winners