Microsoft recently unveiled some SQL Server servicing changes affecting SQL Server 2017 and newer editions, including the upcoming SQL Server 2019, which just reached the preview stage last month.

The problem is that these records expire at some point, but there is no explicit row saying "id-score combination is no longer valid". So, I want to create a set of records for each month ...

I have a table with rows that have a date column. I need to find all open dates (dates with no entries in the database table) starting from the current day to the end of next month.