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

SQL Server Attach and Detach Database Examples

In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.

Creating a Node Table

Switching Database context in transaction

Stable Marriages Using SQL Server

In this article, we see how SQL can be used to determine matches between two groups, given a set of preferences.

Choosing the Column

Introduction to Gaps and Islands Analysis

T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.

More Choice

CHOOSing a value