Fill Gaps in Time Series with this simple trick in SQL

Time-based data, like a list of transactions or events, can contain gaps. Such gaps can cause issues when you have to process this data. Let’s look at an easy method on how to fill such gaps.

Salvatore Cagliari
CodeX
Published in
5 min readSep 8, 2021

--

Photo by Elena Mozhvilo on Unsplash

The problem

--

--

Salvatore Cagliari
CodeX
Writer for

Nerd passionate about technology, and space science and interested in many other things. On the Business side, an expert in Data Analytics and Power BI.