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,305 reads
Jacob Sebastian
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,201 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,535 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,626 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,702 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,704 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,401 reads
TSQL Challenge 48 - Parse and evaluate Arithmetic Expressions using TS
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,292 reads
TSQL Challenge 47 - Read the modification history and identify the fir
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.
2011-01-10
953 reads
TSQL Challenge 46 - Remove leading occurrences of the first character
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
2010-12-27
1,725 reads
Blogs
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers