TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,473 reads
T-SQL Challenges
TSQL Challenge 37 - Calculate the downtime and duration of servers bas
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,515 reads
TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,793 reads
TSQL Challenge 35 - Find the total number of 'Full Attendees' in 24HOP
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
2010-07-26
1,465 reads
TSQL Challenge 34-Search for two keywords within the maximum distance
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.
2010-07-12
1,689 reads
TSQL Challenge 33 - Calculate list of bookings fully paid on the book
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
2010-06-28
1,597 reads
TSQL Challenge 32 - Clean up phrases by removing noise words
The idea of this challenge is to clean up the phrase from the words identified as 'noise' words from the beginning and end of sentences.
2010-06-14
2,683 reads
TSQL Challenge 31 - Managing multiple overlapping date intervals.
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession
2010-05-31
2,449 reads
TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
2010-05-17
2,132 reads
TSQL Challenge 29 - Reorganize sales data by sales amount
Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.
2010-05-03
1,836 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers