提升SQL Server游标性能：优化投标报名审批流程中的任务更新

USE [JSTI_SystemDataBase]
GO

/****** Object:  StoredProcedure [dbo].[UpdateTaskQS]    Script Date: 2021/4/15 14:10:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[UpdateTaskQS] 
AS
BEGIN
SET NOCOUNT ON;
DECLARE @activityID NVARCHAR(50),@flowID NVARCHAR(50),@formInstanceID NVARCHAR(50),@chargeDept NVARCHAR(50)
DECLARE @userID NVARCHAR(50),@userName NVARCHAR(50),@YWuserID NVARCHAR(50),@YWuserName NVARCHAR(50)
DECLARE @allUserID NVARCHAR(2000),@allUserName NVARCHAR(2000),@index INT
--事务开始
BEGIN TRAN  
--定义游标
DECLARE updateTaskQS CURSOR FOR
--数据源
   SELECT ID,FlowID FROM dbo.WF_Activity WHERE Name='投标报名审批流程-传阅任务'
AND UserIDs NOT IN (
SELECT ID FROM dbo.A_User WHERE ID IN (
SELECT ChildGroupID AS UserID FROM dbo.A_GroupRelation WHERE ParentGroupID IN (
SELECT ID FROM dbo.A_Group WHERE  ISNULL(A_Group.OrgRole,'')=(
SELECT ID FROM dbo.A_Group WHERE Code='BusinessSchoolGeneralManager'
)) AND RelationType='User'
)