2025-09-04 08:38:42 执行时长：6.89秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20970-2025-Q-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20970-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20970-2025-Q-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20970-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20970-2025-Q-Q') delete from  GB_CertiDoc where ProjectNo = N'20970-2025-Q-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20970-2025-Q-Q-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20970-2025-Q-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_AuditProblem where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_AuditProblem where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_InvalidDoc where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_AuditorContactRecord where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_AuditProblem where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_AuditorContactRecord where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanCombine where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d') delete from  GB_ProjectPlanTeam where TaskNo = N'fd9acf6b2ef6441594ad5570398eda0d' DELETE FROM GB_ProjectPlan WHERE ID='506002302' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='506002302' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='506002302' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='506002302' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='506002302') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='506002302' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='506002302') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='506002302'

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

2025-09-04 08:41:00 执行时长：6.28秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21234-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'21234-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21234-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'21234-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'21234-2025-QEO-Q') delete from  GB_CertiDoc where ProjectNo = N'21234-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'21234-2025-QEO-Q-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'21234-2025-QEO-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_AuditProblem where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_AuditProblem where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_InvalidDoc where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_AuditorContactRecord where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_AuditProblem where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_AuditorContactRecord where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanCombine where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581') delete from  GB_ProjectPlanTeam where TaskNo = N'ffdccc59be1544769feae860a3b03581' DELETE FROM GB_ProjectPlan WHERE ID='508001199' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='508001199' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='508001199' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='508001199' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='508001199') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='508001199' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='508001199') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='508001199'

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

2025-09-04 08:43:17 执行时长：5.54秒 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