In SQL Server, the GENERATE_SERIES()
function is a relational operator that returns a series of values between a given start and stop point. These are returned in a single-column table.
Although the GENERATE_SERIES()
function only works with numeric values, we can combine it with other functions to create a series of dates.
The GENERATE_SERIES()
function was introduced in SQL Server 2022 (16.x) and requires the compatibility level to be at least 160.