Mike Scalise

Mike Scalise

My thoughts on SQL Server, Project Management, Fitness, and all points in between

SQL Challenges

TSQL Challenges were a contest founded by Jacob Sebastian in 2009. With his permission, I am re-publishing these puzzles to help SQL Server enthusiasts test and hone their query-writing skills. Here are the puzzles, followed by the original about page for the challenges.

TSQL Challenges

T-SQL Challenge #1
T-SQL Challenge #1 (re-released) – Pair-wise and ordered assignment of objects from two different lists
T-SQL Challenge #2
T-SQL Challenge #3

TSQL Beginners’ Challenges

T-SQL Beginners’ Challenge #1 – Find the second highest salary for each department
T-SQL Beginners’ Challenge #2 – Fight Your Fear for Date Calculations
T-SQL Beginners’ Challenge #3 – Find the Factorial