use t24v001

IF OBJECTPROPERTY (OBJECT_ID('TMP_RETURN_GOODS_ACCOUNT_TYPES'),'ISTABLE') = 1 DROP TABLE TMP_RETURN_GOODS_ACCOUNT_TYPES
select * INTO TMP_RETURN_GOODS_ACCOUNT_TYPES FROM (SELECT DISTINCT AccCode FROM RETURN_GOODS_ACCOUNT_TYPES) AS T1
DELETE FROM RETURN_GOODS_ACCOUNT_TYPES 
INSERT INTO RETURN_GOODS_ACCOUNT_TYPES select * FROM TMP_RETURN_GOODS_ACCOUNT_TYPES