金蝶K3WISE-即时库存分仓长代码查询SQL.docx

④内部公开请勿外传SETNOCOUNTONDECLARE@STRITEMNUMBERNVARCHAR(700)DECLARE@STRSTOCKNONVARCHAR(100)DECLARE@STRSELECTSQLVARCHAR(3000)SET@STRITEMNUMBER=*FItemLongNo*SET@STRSTOCKNO=*FStockLongNo*SET@STRITEMNUMBER=+@STRITEMNUMBER+SET@STRSTOCKNO=+@STRSTOCKNO+SET@STRSELECTSQL=CREATETABLE#TEMPINVENTORY([FBRNO][VARCHAR](10)NOTNULL,[FITEMID][INT]NOTNULL,[FBATCHNO][VARCHAR](200)NOTNULL,[FSTOCKID][INT]NOTNULL...