If it is positive, it is displayed as +. If it is negative, it is displayed as "-". If it is not, it is displayed as "-". This statement is passed in the MSSQLserver2000 test -- hjc is the number of records, if there is no record, there is no comparability. Otherwise show compare value casewhenhjc0then-elseCAST (casewhen (hj-hjc) 0 then + + cast (hj-hjc) asvar
If it is positive, it is displayed as +. If it is negative, it is displayed as "-". If it is not, it is displayed as "-". This statement is passed in the MSSQLserver2000 test -- hjc is the number of records, if there is no record, there is no comparability. Otherwise, the Compare value case when hjc = 0 then'-'else CAST (case when (hj-hjc) 0 then' + '+ cast (hj-hjc) as var is displayed.
If it is positive, it is displayed as "+". If it is negative, it is displayed as "-". If it is not, it is displayed as "-". This statement is passed in the MSSQLserver2000 test.
<无>
-- Hjc indicates the number of records. If there is no record, there is no comparability. Otherwise, the Compare value case when hjc = 0 then'-'else CAST (case when (hj-hjc)> 0 then' + '+ cast (hj-hjc) as varchar) is displayed) else cast (hj-hjc) as varchar) end as varchar (5000) end as hj2, case when hjc = 0 then'-'else CAST (case when wfhjc = wfhj then 0 WHEN wfhjc = 0 AND wfhj> 0 THEN 100 else (wfhj-wfhjc) * 100.0/wfhjc end as decimal (5000) as varchar () end as wfl2,