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,746 reads
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,746 reads
Your job is to scan the trades data and identify combination of trades that match a given rollup data.
2011-05-30
889 reads
This challnge invites you to generate a Sierpinsky carpet using TSQL
2011-05-16
2,508 reads
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,294 reads
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,193 reads
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,527 reads
This challenge is intended to calculate company's wage spent below a top level manager.
2011-03-21
1,620 reads
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,697 reads
The purpose of this challenge is to test your query writing skills with a limited set of TSQL keywords.
2011-02-21
1,701 reads
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,396 reads
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
I have a record, in those the three columns where firstname / last name...
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers