T-SQL Challenges

Article

The challenge is to write a query that returns the articles to be displayed in the home page of the website. N number of articles from each category is to be selected where N is configured in the Categories table. Each category should select the most recent N articles. ArticleID can be used to identify the most recent articles. An article with a higher number indicates a more recent article.

2010-04-19

2,022 reads

TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses

by Press Release

SQLServerCentral.com

T-SQL Challenges

Article

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2010-04-05

2,580 reads

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

by Press Release

T-SQL Challenges

T-SQL Challenges

Article

Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your chalenge 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.

2010-03-22

1,783 reads

TSQL Challenge 25 - Appointments and Recurring Schedules

by Press Release

T-SQL Challenges

T-SQL Challenges

Article

The task is to look at the appointments and the recurrence of schedules to come up with a list of meetings for a given period.

2010-03-08

2,431 reads

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

by Additional Articles

T-SQL Challenges

T-SQL Challenges

Article

This is a problem that I had seen in one of the forums many years back. This problem is related to a reporting requirement from the data stored by a 'poorly designed' system.

2010-02-22

1,839 reads

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

by Press Release

T-SQL Challenges

T-SQL Challenges

Article

It is again time to play with some date/time values. This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.

2010-02-08

2,225 reads

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

by Press Release

T-SQL Challenges

T-SQL Challenges

Article

We have got some boxes and balls. Our job is to put balls into those boxes. But, wait a second! The balls should be filled into the boxes based on some rules and preferences configured by the user. Here are the rules.

2010-01-28

2,109 reads

Celko's SQL Stumper: The Class Scheduling Problem

by Additional Articles

SimpleTalk

T-SQL Challenges

Article

What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!

2010-01-27

1,535 reads

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

by Press Release

T-SQL Challenges

T-SQL Challenges

Article

Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here is something that is very interesting where you might need to process records in a 'three-line-at-a-time' fashion.

2010-01-11

2,826 reads

Discuss

TSQL Challenge 20 - finding repeating digits on Fibonacci sequence numbers

by Press Release

T-SQL Challenges

T-SQL Challenges

Article

Can you generate repeating digits in a Fibonacci series?

2009-12-28

2,168 reads

T-SQL Challenges

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

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

TSQL Challenge 25 - Appointments and Recurring Schedules

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

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

Celko's SQL Stumper: The Class Scheduling Problem

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

TSQL Challenge 20 - finding repeating digits on Fibonacci sequence numbers

Blogs

A bespoke reporting solution doesn’t have to cost the earth

Presenting with Visual Studio Code

Advice I Like: In 100 Years

Forums

Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

Can You Let Go of Determinism

Question of the Day

Lots of FKs