Tag: gaps-in-data

SQL Server filling gaps in time series

I’m having trouble with a request in SQL. I have two tables, one representing a vector of dates and another timeseries of prices for different securities: Dates: DateId Date 1 2021-01-01 2 2021-01-02 3 2021-01-03 TimeSerie: SecurityId DateId Value 1 1 0.25 1 3 0.32 2 1 0.41 2 2 0.67 The timeserie may have gaps, for example in the

Limiting records by included/excluded/null date ranges

gaps-in-data oracle sql

First, a description of my task. I need to identify customers that have placed orders within the past 2 years. However, I need a subset of those records. There needs to be 1 or more orders placed …