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
......
阅读全文