DECLARE @tbl_Test_EOMONTH AS TABLE
(
SampleDate DATETIME
)
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-12-20')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-11-08')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-10-16')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-09-26')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2016-01-31')
SELECT DATEADD(DAY,8-DATEPART(WEEKDAY,DATEADD(DAY,0,EOMONTH([SampleDate])))
,EOMONTH([SampleDate])) AS FirstSunday_ofTheNextMonth
FROM @tbl_Test_EOMONTH
GO
No comments:
Post a Comment