Jason's 程設BLOG

declare @sd datetime = '20121226'
declare @dd datetime = '20141231'
declare @t table (c1 datetime)

while @sd <= @dd
begin
	if DATENAME(weekday,@sd) = 'Monday' 

	insert into @t values (@sd)
	set @sd = DATEADD(day,1,@sd)
end

SELECT convert(VARCHAR(8),c1,112) FROM  @t