© Kathi Kellenberger, Clayton Groom, and Ed Pollack 2019
K. Kellenberger et al.Expert T-SQL Window Functions in SQL Server 2019https://doi.org/10.1007/978-1-4842-5197-3_10

10. Time Range Calculations

Kathi Kellenberger1 , Clayton Groom2 and Ed Pollack3
Edwardsville, IL, USA
Smithton, IL, USA
Albany, NY, USA

A very common reporting requirement is to produce totals by different ranges of time for comparison. Typical reports will contain totals by month, quarter, and year, sometimes with comparisons to the same period in the prior year or for month-to-date or year-to-date totals. Products like SQL Server Analysis Services and Power BI provide functions to navigate date hierarchies. With window functions in SQL Server 2012 or later, you can produce ...

Get Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.