SQL SERVER DATERANGE - LAST 30 DAYS

gistfile1.sql

--  SQL SERVER DATERANGE
--  Generates a list the last 30 dates.

WITH DATERANGE AS (
  SELECT
		CAST( CONVERT( VARCHAR , DATEADD( dd , -30 , GETDATE() ) , 101 ) AS DATETIME ) AS DATE
	UNION ALL
	SELECT
		DATEADD( dd , 1 , DATE )
	FROM	DATERANGE
	WHERE	1=	1
		AND	DATEADD( dd , 1 , DATE ) <= CAST( CONVERT( VARCHAR , GETDATE() , 101 ) AS DATETIME )

)
SELECT
	DATE
FROM	DATERANGE