sal.sql

来自「用友系统二次开发 存货管理 客户管理 订货审核 退货审核 铺货计划 」· SQL 代码 · 共 10 行

INSERT INTO InventoryBarCodeSet 
(cInvCode, cBarCode, cRuleId, cAssignId, cInvName, cInvCCode, cInvCName, cFree1, cFree2) 
DELETE FROM ItemAllotAnalysis
WHERE fchrID IN (SELECT ItemAllotAnalysis.fchrID
		   FROM ItemAllotAnalysis INNER JOIN Item ON ItemAllotAnalysis.fchrItemID = Item.fchrItemID FULL OUTER JOIN
	 OPENDATASOURCE ('SQLOLEDB','SERVER=erpserver1;UID=sa;PWD=11111;DATABASE=UFSOFT_U8_Retail' ).UFDATA_168_2008.dbo._PM_V_InventoryColorSize
	    		       UF_DATA ON Item.fchrItemCode = UF_DATA.cInvCode AND ItemAllotAnalysis.fchrValueName = UF_DATA.cFree
	          WHERE (UF_DATA.cInvCode IS NULL))