merge into TMP392AC53F26DE11E680E0000C29A IT using (
SELECT FGUID,FMATERIALID,FSTOCKORGID,FOWNERTYPEID,FOWNERID,FKEEPERTYPEID,FKEEPERID,
FSTOCKID,FStockLocId,FSTOCKSTATUSID,FAuxPropId,FLOTID,FPRODUCEDATE,FEXPIRYDATE,FBOMID,FMTONO from TMP392AC53E26DE11E680E0000C29A ) IT2
ON (IT.FMATERIALID=IT2.FMATERIALID
AND IT.FSTOCKORGID=IT2.FSTOCKORGID
AND IT.FOWNERTYPEID=IT2.FOWNERTYPEID
AND IT.FOWNERID=IT2.FOWNERID
AND IT.FKEEPERTYPEID=IT2.FKEEPERTYPEID
AND IT.FKEEPERID=IT2.FKEEPERID
AND IT.FSTOCKID=IT2.FSTOCKID
AND IT.FSTOCKLOC=IT2.FStockLocId
AND IT.FSTOCKSTATUSID=IT2.FSTOCKSTATUSID
AND IT.FAuxPropId=IT2.FAuxPropId
AND IT.FLOTID=IT2.FLOTID
AND (IT.FPRODUCEDATE=IT2.FPRODUCEDATE OR (IT.FPRODUCEDATE IS NULL AND IT2.FPRODUCEDATE IS NULL))
AND (IT.FEXPIRYDATE=IT2.FEXPIRYDATE OR (IT.FEXPIRYDATE IS NULL AND IT2.FEXPIRYDATE IS NULL))
AND IT.FBOMID=IT2.FBOMID
AND IT.FMTONO = IT2.FMTONO
)
WHEN MATCHED THEN UPDATE SET IT.FGUID = IT2.FGUID
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 lstSqlObj, Int32 commandTimeout)
在 Kingdee.K3.SCM.App.Stock.Report.InvAgeAnalyze.CreateStockBillData(DateTime minDate)
在 Kingdee.K3.SCM.App.Stock.Report.InvAgeAnalyze.GetList(IRptParams filter)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass3d.
推荐阅读