set @sql = '
                BEGIN TRAN
                    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
                    INSERT INTO #TStudentCode(StudentCode,TaskHandledID,HandleStepId) 

                    --查出不在标记表中的数据
                    SELECT TOP 100 SS.StudentCode,null,0  
                    FROM [01_SubjectiveScoreInfo] AS SS 
                      INNER JOIN SubjectiveItemInfo AS SI  
                        ON SS.TestCode=SI.TestCode 
                          AND SS.MajorQuestionID=SI.MajorQuestionID 
                          AND SS.MinorQuestionID=SI.MinorQuestionID
                    WHERE SS.TestCode=''' + @TestCode + ''' 
                      AND SI.QuestionGroupCode=''' + @QuestionGroupCode + '''   
                      AND (SI.MinorQuestionCount=0 
                        OR SI.MinorQuestionID>0)
                      AND SS.ID NOT IN
                      (
                        SELECT DISTINCT ID  FROM [01_SubjectiveScoreInfoFlag] WITH(NOLOCK)
                      )
                    GROUP BY SS.StudentCode
                    
                    INSERT INTO [01_SubjectiveScoreInfoFlag](ID)
                    SELECT SS.ID
                    FROM [01_SubjectiveScoreInfo] AS SS 
                      INNER JOIN SubjectiveItemInfo AS SI  
                        ON SS.TestCode=SI.TestCode 
                          AND SS.MajorQuestionID=SI.MajorQuestionID 
                          AND SS.MinorQuestionID=SI.MinorQuestionID 
                      INNER JOIN #TStudentCode TS
                        ON SS.StudentCode = TS.StudentCode
                    WHERE SI.QuestionGroupCode=''' + @QuestionGroupCode + '''
                    AND SS.ID NOT IN
                    (
                      SELECT DISTINCT ID  FROM [01_SubjectiveScoreInfoFlag] WITH(NOLOCK)
                    )
                COMMIT TRAN
                ' 
        exec sp_executesql @sql