T-SQL to get all days between two dates (without variables or recursives CTE)

days_between_2_dates.sql

WITH 
	min_date AS
	(
		SELECT TOP 1 DATE_FIELD FROM TABLE_XPTO ORDER BY DATE_FIELD ASC
	),
	max_date AS
	(
		SELECT TOP 1 DATE_FIELD FROM TABLE_XPTO ORDER BY DATE_FIELD DESC
	)
SELECT 
	TOP (DATEDIFF(DAY, (SELECT MAX(DATE_FIELD) FROM min_date), (SELECT MAX(DATE_FIELD) FROM max_date)) + 1)
        Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, (SELECT MAX(DATE_FIELD) FROM min_date))
FROM
	sys.all_objects a
CROSS JOIN
	sys.all_objects b;