BEGIN TRAN
　　
　　 --不加这句不会死锁，但会出现同一条记录被重复取出
    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; 

    INSERT INTO #TStudentCode(StudentCode,TaskHandledID,HandleStepId) 
    SELECT TOP 1 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 NOT EXISTS
      (
        SELECT TOP 1 1 
        FROM [01_SubjectiveScoreInfoFlag]
        WHERE ID = SS.ID
      )
    
    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 
    WHERE SS.TestCode=''' + @TestCode + '''    
      AND SI.QuestionGroupCode=''' + @QuestionGroupCode + '''   
      AND (SI.MinorQuestionCount=0 
        OR SI.MinorQuestionID>0)
      AND SS.StudentCode = (SELECT TOP 1 StudentCode FROM #TStudentCode)
      
COMMIT TRAN