Looking for help on whether the following query can be simplified. You want the EXCEPT clause. Check out the microsoft documentation on EXCEPT. Google "T-SQL EXCEPT" and that should get you going.

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 ...