采购执行明细表，查找一个单号要等待10多分钟，查询多个...

采购执行表打开一个单号特慢，在99%要等10多分钟，数据库CPU占用要80%，打开多个就报错

多个就报错
查询出现异常。System.InvalidOperationException: Cannot access destination table 'TMP6FD45A801AF311E7B812BDCFD23'. ---> System.Data.SqlClient.SqlException: 对象名 'TMP6FD45A801AF311E7B812BDCFD23' 无效。
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQuery()
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
--- End of inner exception stack trace ---
Server stack trace:
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at Kingdee.BOS.App.Data.Sql.SqlDatabase.CopyDataToDestination(DbCommand cmd, DataTable table)
at Kingdee.BOS.App.Data.Sql.SqlDatabase.BulkInserts(DbCommand cmd, DataTable dt)
at Kingdee.BOS.App.Data.DBUtils.BulkInserts(Context ctx, String InsertstrSql, String CreateSql, DataTable dt)
at Kingdee.BOS.App.Data.DBUtils.BulkInserts(Context ctx, DataTable dt)
at Kingdee.K3.SCM.App.Purchase.Report.PurchaseRptCommon.GetInvoceBillNo(Context ctx, String invoceBillnoTable)
at Kingdee.K3.SCM.App.Purchase.Report.PurchaseOrderExecuteRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.b__49()