Choosing Rows or Range

The DEFAULT RANGE

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