大力：在查询分析器里通过的，但用到视图里有错阿

[竹君子]

还是刚才的分项

报错说：查询设计器步支持 case

该怎么办呢

[竹君子]

：：“查询设计器不支持 CASE SQL 构造。”





SELECT ISNULL(aaa.CategoryName, bbb.CategoryName)
AS CategoryName, ISNULL(aaa.QuestionID, bbb.QuestionID) AS QuestionID,
ISNULL(aaa.QuestionContent, bbb.QuestionContent) AS QuestionContent,
ISNULL(aaa.AvgScore, '') AS CurScore, ISNULL(bbb.AvgScore, '') AS LastScore,
ISNULL(aaa.AvgScore, '') - ISNULL(bbb.AvgScore, '') AS Distance,
Rate=Str(CASE WHEN isnull(bbb.AvgScore,'')<> 0 THEN (isnull(aaa.AvgScore,'')-isnull(bbb.AvgScore,''))/isnull(bbb.AvgScore,'') ELSE 0 END,6,2)
FROM (SELECT *
FROM SurveyQuestion
WHERE Status = 2) aaa FULL OUTER JOIN
(SELECT *
FROM SurveyQuestion
WHERE Status = 3) bbb ON aaa.QuestionID = bbb.QuestionID
GROUP BY ISNULL(aaa.CategoryName, bbb.CategoryName), ISNULL(aaa.QuestionID,
bbb.QuestionID), ISNULL(aaa.AvgScore, ''), ISNULL(bbb.AvgScore, ''),
ISNULL(aaa.AvgScore, '') - ISNULL(bbb.AvgScore, ''), aaa.QuestionID,
ISNULL(aaa.QuestionContent, bbb.QuestionContent),Str(CASE WHEN isnull(bbb.AvgScore,'')<> 0 THEN (isnull(aaa.AvgScore,'')-isnull(bbb.AvgScore,''))/isnull(bbb.AvgScore,'') ELSE 0 END,6,2)

[gmc007]

写语句在“查询分析器”创建

[zjcxc]

在查询分析中用
create view 视图名 as 查询语句

查询设计器确实不支持