sqlserver话语

select rtrim(Kmdm) as Kmdm,	rtrim(Fzhs) as Fzhs,	rtrim(Yefx) as Yefx,	rtrim(Kmlb) as Kmlb,    '${annual}' as annual,    '${ACCOUNT_CODE}' as ACCOUNT_CODE,	kmxz,rtrim(kmmc) as kmmc,zjm,	'1'+kmxz+'00' as code_type,	'0' as ENABLED,'0' as STATE,    (case 		when len(rtrim(Kmdm))=3 then '000'		when len(rtrim(Kmdm))>3 then substring(rtrim(Kmdm),1,len(rtrim(Kmdm))-2)	end) as parent_code,     (select count(1) from gl_kmxx b where rtrim(b.kmdm) like rtrim(a.Kmdm) + '%' ) as is_subfrom gl_kmxx a where gsdm=''