2025-09-13 20:18:09 执行时长：6.91秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'21395-2025-QEO-E') delete from  GB_CertiDoc where ProjectNo = N'21395-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'21395-2025-QEO-E-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'21395-2025-QEO-E-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_InvalidDoc where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM GB_ProjectPlan WHERE ID='509001001' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509001001' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509001001' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509001001' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509001001') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509001001' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509001001') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509001001'

2025-09-13 20:18:15 执行时长：6.58秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'21395-2025-QEO-Q') delete from  GB_CertiDoc where ProjectNo = N'21395-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'21395-2025-QEO-Q-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'21395-2025-QEO-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_InvalidDoc where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM GB_ProjectPlan WHERE ID='509001003' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509001003' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509001003' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509001003' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509001003') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509001003' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509001003') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509001003'

2025-09-13 20:18:22 执行时长：6.59秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'21395-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'21395-2025-QEO-O') delete from  GB_CertiDoc where ProjectNo = N'21395-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'21395-2025-QEO-O-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'21395-2025-QEO-O-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_InvalidDoc where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditProblem where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_AuditorContactRecord where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanCombine where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60') delete from  GB_ProjectPlanTeam where TaskNo = N'5ed2a401bcfd4de3ba2ecd9bde8bbc60' DELETE FROM GB_ProjectPlan WHERE ID='509001005' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='509001005' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='509001005' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='509001005' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='509001005') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='509001005' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='509001005') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='509001005'

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

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

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