Select *,
(select DetailName From SkyEvaluationDetail Where
SkyEvaluationDetail.EvaluationID=adc.EName) EName1
from (
select EName , max(case UserID when '1001' then Evalue else 0 end) [1001] , max(case UserID when '1002' then Evalue else 0 end) [1002] , max(case UserID when '1003' then Evalue else 0 end) [1003] from (select UserID,EName,Sum(EValue)/Count(*) as EValue
from SkyEvaluationVD Where EValue<>-10000 Group By UserID,EName) cccc group by EName) adc