Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
语句已终止。
发生时间: 2015-12-03 09:15:39
错误编号: ExecuteBatch
错误信息: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
语句已终止。
Sql语句: INSERT INTO #TM_HS_HookRelation(FSrcBillTypeID,FSrcEntryID,FDesBillTypeID,FDesEntryID,FFlag)
SELECT PAY.FBillTypeID,PAYEntry.FEntryID,STK.FBillTypeID,STKEntry.FEntryID,1
FROM T_AP_PAYABLE_LK LK02
INNER JOIN T_AP_PAYABLEENTRY PAYEntry ON PAYEntry.FEntryID=LK02.FEntryID
INNER JOIN T_AP_PAYABLE PAY ON PAY.FID=PAYEntry.FID
INNER JOIN t_STK_InStockEntry STKEntry ON STKEntry.FEntryID=LK02.FSID
INNER JOIN t_STK_InStock STK ON STK.FID=STKEntry.FID
INNER JOIN #TM_HS_HookPayBillToHook tmp ON tmp.FID=PAYEntry.FEntryID AND tmp.FBillTypeID=PAY.FBillTypeID
WHERE PAYEntry.FHookStatus<>'C' and LK02.FSTABLENAME LIKE 'T_STK_INSTOCKENTRY%'
INSERT INTO #TM_HS_HookRelation(FSrcBillTypeID,FSrcEntryID,FDesBillTypeID,FDesEntryID,FFlag)
SELECT PAY.FBillTypeID,PAYEntry.FEntryID,STK.FBillTypeID,STKEntry.
推荐阅读