2025-12-19 21:13:07 执行时长：5.89秒 sql:select count(*) from ( SELECT DISTINCT 人员审核活动统计.ID as [~ID~] ,人员审核活动统计.[AuditorName] AS [姓名],[标准代码_认证标准].StandardCode AS [标准代码],人员审核活动统计.[ApproveDays] AS [审核天数],[人员编号_人员信息表].AuditorCode AS [人员编号],人员审核活动统计.[ProfessionalCode] AS [受审核方专业代码],[组织名称_组织信息].CorpName AS [组织名称],[审核类别_审核类别].ClassName AS [审核类别],[认证领域_认证领域].FieldName AS [认证领域],[审核方式_审核方式].ApproveMode AS [审核方式],人员审核活动统计.[BeginDate] AS [审核开始日期],人员审核活动统计.[EndDate] AS [审核截止日期],[组内职责_代码表].CodeName AS [组内职责],(case 人员审核活动统计.[DocumentReview] when 1 then '√' else '' end) AS [文审],人员审核活动统计.[PlanNo] AS [计划编号],[见证情况_见证情况].WitnessName AS [见证情况] FROM GB_AuditorAuditHis 人员审核活动统计 WITH(NOLOCK)  LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 人员审核活动统计.StandardCode = [标准代码_认证标准].ID LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员审核活动统计.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 人员审核活动统计.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 人员审核活动统计.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员审核活动统计.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 人员审核活动统计.ApproveMode = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 人员审核活动统计.Duty = [组内职责_代码表].CodeID LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 人员审核活动统计.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 人员审核活动统计.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 人员审核活动统计.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Base_Org [人员合同来源_组织机构] WITH(NOLOCK) ON 人员审核活动统计.AuditorOrg = [人员合同来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 人员审核活动统计.Org = [合同来源_合同来源].Org LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 人员审核活动统计.DecideResult = [批准结论_批准结论].ResultCode WHERE [人员审核活动统计].BeginDate>='2025-09-19' ) as CurrentCount

2025-12-19 21:30:53 执行时长：5.89秒 sql:exec GB_PartnerBizStatistics '2025','ISC0601'