select type_no,code_id,code_name,english_name,code_type,memo
from #SDB..t_bd_base_code
where (case when (#SV = 'isszmv6' or #SV = 'isszmv7') and (type_no = 'SI' or  type_no =  'PP') then '1' else '0' end) = '0'
