select max(case when datepart(weekday,SumDate)=4 then PayNum else 0 end) as '星期三', max(case when datepart(weekday,SumDate)=5 then PayNum else 0 end) as '星期四'.. from tb union all select max(case when datepart(weekday,SumDate)=3 then PayMoney else 0 end) as '星期三', max(case when datepart(weekday,SumDate)=3 then PayMoney else 0 end) as '星期三' .. from tb
max(case when datepart(weekday,SumDate)=4 then PayNum else 0 end) as '星期三',
max(case when datepart(weekday,SumDate)=5 then PayNum else 0 end) as '星期四'..
from
tb
union all
select
max(case when datepart(weekday,SumDate)=3 then PayMoney else 0 end) as '星期三',
max(case when datepart(weekday,SumDate)=3 then PayMoney else 0 end) as '星期三'
..
from
tb
2,pivot 或者 unpivot