SELECT
CASE NEWWORK
WHEN 'L1' THEN '0'
WHEN 'L2' THEN '10'
WHEN 'L3' THEN '20'
WHEN 'L4' THEN ' 40 '
WHEN 'L5' THEN '60'
WHEN 'L6' THEN '80 '
WHEN 'L7' THEN '100 '
WHEN 'L8' THEN '120'
WHEN 'L9' THEN '150'
WHEN 'L10' THEN '80 '
WHEN 'L11' THEN '100'
WHEN 'L12' THEN '120'
WHEN 'L13' THEN '150 '
ELSE '0'
END
再次請教高手~`
查詢10句以上
報告以下錯誤:
Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Server: Msg 125, Level 15, State 1, Line 1
Case expressions may only be nested to level 10.
報告以下錯誤:
Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Server: Msg 125, Level 15, State 1, Line 1
Case expressions may only be nested to level 10.
SELECT
CASE @i
WHEN 1 THEN 'a'
WHEN 2 THEN 'b'
WHEN 3 THEN 'c'
WHEN 4 THEN 'd'
WHEN 5 THEN 'e'
WHEN 6 THEN 'f'
WHEN 7 THEN 'g'
WHEN 8 THEN 'h'
WHEN 9 THEN 'i'
WHEN 10 THEN 'j'
WHEN 11 THEN 'k'
WHEN 12 THEN 'l'
WHEN 13 THEN 'm'
WHEN 14 THEN 'n'
WHEN 15 THEN 'o'
WHEN 16 THEN 'p'
WHEN 17 THEN 'q'
WHEN 18 THEN 'r'
WHEN 19 THEN 's'
WHEN 20 THEN 't'
ELSE 'Z' END