How can I make a query in SQL Server to query for all rows for the next 5 days.
The problem is that it has to be days with records, so the next 5 days, might become something like, Today, Tomorrow, some day in next month, etc...

Basically I want to query the database for the records for the next non empty X days.

The table has a column called Date, which is what I want to filter.