SQL计算一年内有多少天是星期一、二、三、四、五、六、日

SqlServer

declare @a varchar (20)
select @a='2021'
if object_id(N'tempdb..#t',N'U') is not null
drop table #t
create table #t (rq datetime)
declare @b datetime
select @b=(select DATEADD (year, DATEDIFF(year,0,@a),0))
while @b<(select DATEADD(year, DATEDIFF (year,0 ,@a),365))
begin
insert into #t values ( @b)
select @b= (select DATEADD (day ,1,@b) )
end
select
sum (case when datename (weekday,rq)='星期日' then 1 else 0 end) as 星期日天数,
sum (case when datename (weekday,rq)='星期一' then 1 else 0 end) as 星期一天数,
sum (case when datename (weekday,rq)='星期二' then 1 else 0 end) as 星期二天数,
sum (case when datename (weekday,rq)='星期三' then 1 else 0 end) as 星期三天数,
sum (case when datename (weekday,rq)='星期四' then 1 else 0 end) as 星期四天数,
sum