如果是正偏,显示为"+",如果是负偏向显示”-“,如果没有则显示”-“,该语句MSSQLserver2000下测试通过
代码正文
|
case when hjc=0 then '-' else
CAST ( case when (hj-hjc)>0 then '+' + cast ((hj-hjc) as varchar ) else cast ((hj-hjc) as varchar ) end as varchar (5000))
end as hj2,
case when hjc=0 then '-' else CAST ( CAST ( CASE WHEN wfhjc =wfhj THEN 0 WHEN wfhjc = 0 AND wfhj>0 THEN 100 ELSE (wfhj-wfhjc) * 100.0 / wfhjc END AS DECIMAL (10,2)) as varchar (5000)) end as wfl2,
|
|