window functions

Calculate Moving Averages using T-SQL in SQL Server

  • Article

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 […]

5 (4)

2020-02-04

5,672 reads

Introduction to T-SQL Window Functions

  • Article

T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.

2018-06-28

4,353 reads

Blogs

Creating a New Sequence–#SQLNewBlogger

By

I wrote about sequences in an editorial recently and decided to start using them....

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

How should I store currency values in SQL Server?

By

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...

Read the latest Blogs

Forums

Filestream or Filetable or None...what to be used?

By Feivel

I've been assigned with a project that includes converting the columns in the existing...

How to force MS SQL to select a partition instead of making a full table scan

By svenflock

Hi all, I am currently designing a datamart layer in MS SQL 2016 Enterprise....

Daily 3 Coping

By Steve Jones - SSC Editor

Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers