行转列

选择字号： 超大 标准 发布时间：2010-7-28 22:21:23 | 作者：admin | 0个评论 | 人浏览

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

 

标签：

猜你喜欢