sqlserver 查询一周内数据，查询每月每天数据

1.依次查询 最近七天星期几

select   datename(weekday,getdate()-6) as a,
		 datename(weekday,getdate()-5) as b,
		 datename(weekday,getdate()-4) as c,
		 datename(weekday,getdate()-3) as d,
		 datename(weekday,getdate()-2) as e,
		 datename(weekday,getdate()-1) as f,
		 datename(weekday,getdate()-0) as g

查询结果：

2.根据月份查询 今天之前的所有数据

with t as (
 select convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) date 
 from (select substring(convert(varchar,dateadd(month,-0,getdate()),120),1,7)+'-01' day) t1,
      (select number from MASTER..spt_values WHERE TYPE='P' AND number>=0 and number<=31) t2  
where convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) like 
 substring(convert(varchar,dateadd(month,-0,getdate()),120),1,7)+'%')
 select id