4W条人才表循环处理业务sql优化过程

     UPDATE  pt
        SET     StatusText = CASE 
                                  WHEN EXISTS ( SELECT  1
                                    FROM    pas_ContractQuit c
                                    WHERE   IsActive=1 AND ‘,‘+TalentIDs+‘,‘ LIKE ‘%,‘+CONVERT(NVARCHAR(20),pt.ID)+‘,%‘)
                                  THEN ‘已退租‘
                                  ELSE ‘未申请‘
                             END
        FROM    pas_Talent pt

--定义人才行转列start
SELECT  b.col ID
INTO    #TalentIDs
FROM    pas_ContractQuit c
        OUTER APPLY ( SELECT    *
                      FROM      dbo.Split(TalentIDs, ‘,‘)
                    ) b
WHERE   IsActive = 1
        --定义人才行转列end

UPDATE  pt
SET     StatusText = CASE WHEN EXISTS ( SELECT  1
                                        FROM    #TalentIDs
                                        WHERE   pt.ID = #TalentIDs.ID )
                          THEN ‘已退租‘
                          ELSE ‘未申请‘
                     END
FROM    pas_Talent pt