SQL Server 实现数据的行列转换 并且分组
select t1.UserNo,t1.Pad_Num,t2.EmployeeName,count(t1.Pad_Num) AS cnt
into #temp_pad from tb_pad as t1
left join tb_Employee as t2 on t2.EmployeeNo = t1.UserNo
where CONVERT(CHAR(10), T1.RecordDate, 120) between ''' + @beginDate + ''' and ''' + @endDate + '''
group by t1.UserNo, t1.Pad_Num,t2.EmployeeName
select EmployeeName AS ''姓名'',
max(case when Pad_Num= ''1'' then cnt else 0 end) 非常满意,
max(case when Pad_Num= ''7'' then cnt else 0 end) 满意,
max(case when Pad_Num= ''2'' then cnt else 0 end) 基本满意,
max(case when Pad_Num= ''3'' then cnt else 0 end) 不满意
from #temp_pad
group by EmployeeName