条件判断语句出错
if (@tempAssess> =95)
update [TotalAssess] set FinalAssess= '优秀 ';
else
if (@tempAssess> =80)
update [TotalAssess]
set FinalAssess= '称职 ';
else
if (@tempAssess> =60)
update [TotalAssess]
set FinalAssess= '基本称职 ';
else
update [TotalAssess]
set FinalAssess= '不称职 ';

[解决办法]
if (@tempAssess> =95)
begin
update [TotalAssess]
set FinalAssess= '优秀 ';
end
else
begin
if (@tempAssess> =80 and @tempAssess <95)
begin
update [TotalAssess]
set FinalAssess= '称职 ';
end
else
begin
if (@tempAssess> =60 and @tempAssess <90)
begin
update [TotalAssess]
set FinalAssess= '基本称职 ';
end
else
begin
update [TotalAssess]
set FinalAssess= '不称职 ';
end
end
end
[解决办法]
段代本身有，你查其余的代有有。