How to display all days in a month by SQL
Server?
DECLARE @RepMonth as datetime
SET @RepMonth = '04/01/2015';
WITH DayList (DayDate) AS
(
SELECT
@RepMonth
UNION ALL
SELECT DATEADD(d, 1, DayDate)
FROM
DayList
WHERE (DayDate < DATEADD(d, -1, DATEADD(m, 1, @RepMonth)))
)
SELECT *
FROM DayList
No comments:
Post a Comment