类似于：

SELECT workflow
, case when min(status) = max(status) THEN min(status) -- if all status is same, set to status
     when min(case when status = 'Error' then 0 end) = 0 then 'Intederminate' -- if any status is error then intedermined
  else 'Running' end
FROM #ProcessLog
group by workflow

也许？