Recursive CTE’s Recursive CTEs are unique, such that they are allowed to reference their own. With this special ability, you can use

Read More
What is a Recursive CTE (Common Table Expression)?

The Common Table Expressions or CTE’s for short are used within SQL Server to simplify complex joins and subqueries, and to provide

Read More
Common Table Expressions – The Ultimate Guide

In this puzzle we’re going to learn how to find the person whose birthday, among others, is in the middle.  Knowing how

Read More
Use SQL to Calculate Median Values.

In this puzzle, we’re going to learn how to find a gap in a sequence using SQL Server.  I was recently reviewing

Read More
How to Find a Gap in a Sequence using SQL SERVER

In this puzzle, we’re going with with SQL Percentile Rank to work through a problem to identify the top and bottom student

Read More
SQL Percentile Rank Puzzle