TSQL Challenge 58 - Playing Chess in TSQL – Part 1
Your job is to read the input string and generate a result set that represents the position of pieces in a chess board.
2011-06-13
1,759 reads
T-SQL Challenges
TSQL Challenge 57 - Identify rows that match the rollup trade data
Your job is to scan the trades data and identify combination of trades that match a given rollup data.
2011-05-30
899 reads
TSQL Challenge 56 - Create a Sierpinski carpet using TSQL
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,518 reads
TSQL Challenge 55 - Multiply two very long decimal strings and return
This challenge to multiply two positive integer strings and return their product. The strings can be really long: up to 1024 digits
2011-05-02
1,307 reads
TSQL Challenge 54 - Find the longest matching area code
Your job is to write a query that identifies the longest matching country/area code from each phone number based on the information stored in an area-code reference table.
2011-04-18
1,202 reads
TSQL Challenge 53 - Finding empty and non-empty intervals
A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.
2011-04-04
1,538 reads
TSQL Challenge 52: Recursive Wage Calculation in a Parent-Child dimens
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,628 reads
TSQL Challenge 51 - Convert long Binary strings to Decimal strings
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,703 reads
TSQL Challenge 50 - Extracting a specifical range from random data wit
The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.
2011-02-21
1,706 reads
TSQL Challenge 49 - Identify overlapping time sheet entries of field t
Several technicians are sent to a customer premises to do a certain maintenance work. Your task is to process the activity log entered by each technician and identify overlaps.
2011-02-07
1,404 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers