Using a CTE as a Tally Table

Sometimes you need to output blank lines
- in effect displaying Records for Missing Data. This article explains how to use a CTE to do this

Using a Derived Table to Compare Data with Values from a Previous Year

Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL

Drop table in one shot

Display Median Values

DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this

Variable assignments

T-SQL Window Functions and Performance

T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.

Generating Completely Random Sample Output from a Dataset

This short article shows a simple example of how to generate completely random sample output from a Dataset

Creating Compound Interest Calculations in SQL

This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills

Assignments

Build Better Habits