2025-09-04 16:30:45 执行时长：5.64秒 sql:select count(*) from ( SELECT DISTINCT 人员专业能力.ID as [~ID~] ,[人员编号_人员信息表].AuditorCode AS [人员编号],人员专业能力.[AuditorName] AS [人员姓名],[组织机构_组织机构].OrgName AS [组织机构],[认证领域_认证领域].FieldName AS [认证领域],[专业代码_专业代码库].ProfessionalCode AS [专业代码],人员专业能力.[SubjectName] AS [专业名称],[风险等级_代码表].CodeName AS [风险等级],[能力来源_代码表].CodeName AS [能力来源],人员专业能力.[ByDate] AS [通过日期] FROM GB_AuditorProfessional 人员专业能力 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员专业能力.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN Base_Org [组织机构_组织机构] WITH(NOLOCK) ON 人员专业能力.Org = [组织机构_组织机构].OrgID LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员专业能力.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_ProfessionalCode [专业代码_专业代码库] WITH(NOLOCK) ON 人员专业能力.ProfessionalCode = [专业代码_专业代码库].ID LEFT JOIN Pub_MediumClass [中类编码_专业中类] WITH(NOLOCK) ON 人员专业能力.MediumClassEncoding = [中类编码_专业中类].MediumClassEncoding LEFT JOIN Pub_MajorCategories [大类编码_专业大类] WITH(NOLOCK) ON 人员专业能力.CategoryEncoding = [大类编码_专业大类].CategoryEncoding LEFT JOIN Pub_Code [风险等级_代码表] WITH(NOLOCK) ON 人员专业能力.RiskLevel = [风险等级_代码表].CodeID LEFT JOIN Pub_Code [能力来源_代码表] WITH(NOLOCK) ON 人员专业能力.SourceOfAbility = [能力来源_代码表].CodeID WHERE [人员编号_人员信息表].[StaffStatus] = '127' ) as CurrentCount

2025-09-04 16:43:48 执行时长：7.22秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'11113-2025-EO-E') delete from  GB_CertiDoc where ProjectNo = N'11113-2025-EO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'11113-2025-EO-E-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'11113-2025-EO-E-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_InvalidDoc where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM GB_ProjectPlan WHERE ID='509000065' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509000065' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509000065' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509000065' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509000065') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509000065' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509000065') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509000065'

2025-09-04 16:43:48 执行时长：6.1秒 sql:delete from base_bizcolumnattach where AccessPath='GB_CertiApplyApproveDoc' and  keyvalue='509000196ISC2701' and datacolumnid='002168'

2025-09-04 16:43:55 执行时长：6.41秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'11113-2025-EO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'11113-2025-EO-O') delete from  GB_CertiDoc where ProjectNo = N'11113-2025-EO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'11113-2025-EO-O-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'11113-2025-EO-O-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_InvalidDoc where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditProblem where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_AuditorContactRecord where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanCombine where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1') delete from  GB_ProjectPlanTeam where TaskNo = N'dd4554045f044b5bb463d2a74e51a7d1' DELETE FROM GB_ProjectPlan WHERE ID='509000066' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509000066' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509000066' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509000066' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509000066') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509000066' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509000066') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509000066'