批量更改采购负责人

–1、导入excle到数据库updatebuyer表
验证无重复：SELECT COUNT(fnumber),fnumber FROM updatebuyer GROUP BY fnumber ORDER BY COUNT(fnumber) DESC

–2、查询采购负责人英文O的fitemid为136928

SELECT FItemID,* FROM t_Emp WHERE FName=‘O’

–3、更新物料采购负责人所在表t_ICItemMaterial内的字段FOrderRector

UPDATE t_ICItemMaterial SET FOrderRector=136928 WHERE FItemID IN (SELECT v.FItemID FROM updatebuyer u LEFT JOIN t_ICItem v ON u.FNumber=v.fnumber)

SELECT FName,* FROM t_Emp r ORDER BY r.FName

SELECT u.FOrderRector,* 

    FROM CVT_TT_ICInventory_Money u

        LEFT JOIN t_ICItem v

            ON u.FItemID = v.FItemID

        LEFT JOIN t_Emp r

            ON v.FOrderRector = r.FItemID;