Have SUM() fun!

Vedran Posted on 2020-05-26 Posted in TSQL and SQL Client Code 1 Comment Tagged with analytic, over, sql, visualization, windowing

Did you know that SUM() aggregate can be used together with OVER() clause?

A short intro to windowing functions:

SELECT SUM(Amount) OVER() -- What!?
FROM dbo.PersonCityAmount

1 2	SELECT SUM(Amount) OVER() -- What!? FROM dbo.PersonCityAmount

The result is graphically visualized by using only SQL Server Management Studio and unicode characters:

… or spatial data type:

One practical example of this method is visualizing SQL Agent Jobs from Daniel Hutmacher – very useful to make a better job schedule.

Watch the video and give it a thumbs up if you like it: