Я продолжаю получать эту надоедливую ошибку всякий раз, когда я пытаюсь использовать этот код:
select
gam.acid,
gam.foracid,
gam.acct_name,
gam.sol_id,
sol.sol_desc,
gam.gl_sub_head_code,
case gsh.gl_code
when cast(gl_code as int) >= 01 and cast(gl_code as int) <=13
or cast(gl_code as int) >= 15 and cast(gl_code as int) <=24 then 'A'
when cast(gl_code as int) >= 28 and cast(gl_code as int) <= 31
or cast(gl_code as int) >= 33 and cast(gl_code as int) <= 39
or cast(gl_code as int) = 41
or cast(gl_code as int) >= 43 and cast(gl_code as int) <= 48 then 'L'
when cast(gl_code as int) = 51
or cast(gl_code as int) = 53
or cast(gl_code as int) >= 55 and cast(gl_code as int) <= 57 then 'C'
when cast(gl_code as int) >= 61 and cast(gl_code as int) <= 70
or cast(gl_code as int) >= 72 and cast(gl_code as int) <= 81 then 'I'
when cast(gl_code as int) = 84 or cast(gl_code as int) = 85
or cast(gl_code as int) >= 87 and cast(gl_code as int) <= 94 then 'E'
when cast(gl_code as int) >= 97 and cast(gl_code as int) <= 99 then 'S'
else null
end as gl_classification
from tbaadm.gam
Такое ощущение, что что-то в коде не на месте, или я что-то забыл сделать/добавить. Любая помощь будет оценена по достоинству.
case gsh.gl_code
только наcase
, как указано в ответах)? Вы уверены, что это изcase
, а не из предложения joins/where, которое вы не показали? - person Alex Poole   schedule 15.04.2014when cast(gl_code as int) >= 01 and cast(gl_code as int) <=13
Жаба всегда указывает на знак>=
рядом с01
- person JamesP   schedule 15.04.2014