create table #Tmp ( ProcessId varchar(50), jiedian varchar(50), 节点审批效率 varchar(50) ); Insert into #Tmp(ProcessId,jiedian,节点审批效率) select case ProcessId when 6 then 'xxxxx1' when 10 then 'xxxxx1' when 4 then 'xxxxx1' when 5 then 'xxxxx1' when 2 then 'xxxxx1' when 3 then 'xxxxx1' when 7 then 'xxxxx1' end as 流程类别,jiedian, --(SUM(shichang)/24),COUNT(id), (SUM(shichang)/24)/COUNT(id) as 节点审批效率 from View_nqfw_list group by ProcessId ,jiedian having ProcessId !='12' and ProcessId !='11' order by ProcessId select ProcessId , max(case jiedian when'审批' then 节点审批效率 else 0 end) 审批, max(case jiedian when '发起' then 节点审批效率 else 0 end) 发起, max(case jiedian when'会签'then 节点审批效率 else 0 end) 会签, max(case jiedian when'办公室'then 节点审批效率 else 0 end) 办公室 from #Tmp group by ProcessId drop table #Tmp