Database Challenges

TSQL Challenge 30 - A Matrix Transposition challenge in TSQL

This is a matrix transposition challenge and your job is to change the position of the numbres in a 5x5 matrix. Transposition includes converting rows to columns and sorting the values horizontally and vertically.

TSQL Challenge 29 - Reorganize sales data by sales amount

This challenge presents a tough task of reorganizing the data in a sales table. The table is not normalized correctly and the sales detail data of three items are stored in each row.

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database

TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses

This challenge is related to a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.

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

TSQL Challenge 25 - Appointments and Recurring Schedules

• TSQL Challenge 25 - All Solutions
• TSQL Challenge 25 - Accepted Solutions

TSQL Challenge 24 - Find discrepancies in the scheduled activities and actual activities performed by employees

• TSQL Challenge 24 - All Solutions
• TSQL Challenge 24 - Accepted Solutions

TSQL Challenge 23 - Calculate the uptime and downtime of a system by reading the data from an audit log

TSQL Challenge 22 - Filling balls into boxes based on rules and preferences

Who among us wouldn't want to go back to our childhood and enjoy those lovely playful time once again?

TSQL Challenge 21 - Reading, recognizing and processing graphical representation of digits