Adding N/A

The Default LAG

Finding the last month's values

The "Median" Function

Calculate the Days Between Orders

Using TOP with ROW_NUMBER

Calculate Moving Averages using T-SQL in SQL Server

Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]

Calculate the Days Between First and Last Orders

An Intro to SQL Window Functions

Learn about some window function basics in T-SQL

What’s the Difference Between PERCENT_RANK and CUME_DIST?

Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.