TRANSFORM Avg(CASE WHEN [temp].[sumUnits] > THEN [temp].[SumAvgRent] / [temp].[sumUnits] ELSE END) AS Expr1SELECT [temp].[Description] FROM [temp] GROUP BY [temp].[Description]PIVOT [temp].[Period];需要将此查询转换为SQL Server & E/ f2 Q% a. R* H: p6 c我已经读有其他帖子,但我不能把它们转换成同一个帖子 S, i t1 Y8 f: p' m. a# D }9 `- ]# t9 t% a 解决方案: