select 日期 from ( select row_number() over(order by getdate()) no, dateadd(dd,number,CONVERT(char(7),getdate(),120)+'-01') as 日期 from master..spt_values where type='p' and DatePart(weekday,dateadd(dd,number,CONVERT(char(7),getdate(),120)+'-01'))=1 and CONVERT(char(7),getdate(),120)= CONVERT(char(7), dateadd(dd,number,CONVERT(char(7),getdate(),120)+'-01'),120))a where no=3
select row_number() over(order by getdate()) no,
dateadd(dd,number,CONVERT(char(7),getdate(),120)+'-01') as 日期
from master..spt_values
where type='p' and DatePart(weekday,dateadd(dd,number,CONVERT(char(7),getdate(),120)+'-01'))=1
and CONVERT(char(7),getdate(),120)= CONVERT(char(7),
dateadd(dd,number,CONVERT(char(7),getdate(),120)+'-01'),120))a
where no=3
/*
日期
-----------------------
2011-04-17 00:00:00.000
http://topic.csdn.net/u/20091102/09/298b629b-617e-40a7-8faf-dbeeadbf5fea.html