将用友会计科目名称转换为方便AX使用的科目名称

--更新一级科目名称

UPDATE _COA SET KMMC_N=KMMC_O WHERE LEN(KMBM_O)=4

--更新二级科目名称

UPDATE _COA SET KMMC_N=B.KMMC_O+' - '+A.KMMC_O
FROM _COA AS A INNER JOIN (SELECT * FROM _COA WHERE LEN(KMBM_O)=4) AS B
ON LEFT(A.KMBM_O,4)=B.KMBM_O
WHERE LEN(A.KMBM_O)=6

--更新三级科目名称

UPDATE _COA SET KMMC_N=B.KMMC_N+' - '+A.KMMC_O
FROM _COA AS A INNER JOIN (SELECT * FROM _COA WHERE LEN(KMBM_O)=6) AS B
ON LEFT(A.KMBM_O,6)=B.KMBM_O
WHERE LEN(A.KMBM_O)=8

转载于:https://www.cnblogs.com/joshuali/archive/2009/11/18/4339344.html