CTE迴圈年曆

DECLARE @S_DATE AS DATE
DECLARE @E_DATE AS DATE
SET @S_DATE='2014/01/01'
SET @E_DATE='2014/12/31'
;
WITH CTE_DATE AS
(
 SELECT @S_DATE AS S_DATE
 UNION ALL
 SELECT DATEADD(d,1, S_DATE) AS S_DATE
 FROM CTE_DATE
 WHERE S_DATE<@E_DATE
)
SELECT S_DATE
FROM CTE_DATE
OPTION (MAXRECURSION 0)