我试图从创建的过程中获取单个值，但显示错误为 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, 基本上我想返回 @statusReturn 但我怎么做不到，谁能告诉我如何做到这一点。

CREATE PROCEDURE [DBO].[uspGetJobStausAnyalyticaSpdDeltaRefresh]
( @Execution_Job_ID INT) 
AS 
  BEGIN
  SELECT TOP 3 
               ji.jobname, 
               jel.* 
    INTO       #tempjobstatus 
    FROM       jobexecutionlog jel  
    INNER JOIN jobinfo ji 
    ON         jel.jobid=ji.jobid 
    WHERE      jel.jobid IN (897,809,876) 
    AND        jel.jobexecutionlogid <= @Execution_Job_ID 
    ORDER BY   2 DESC 

    DECLARE @statusSPDRefresh  VARCHAR(30), 
      @statusAnalyticsRefresh  VARCHAR(30), 
      @statusJobExecutionLogId INT , 
      @statusReturn            INT
      SET @statusSPDRefresh = 
    ( 
           SELECT jobstatus 
           FROM   #tempjobstatus 
           WHERE  jobname ='Refresh')
           IF (@statusSPDRefresh = 'Failed') 
    BEGIN 
      SET @statusAnalyticsRefresh = 
      ( 
             SELECT jobstatus 
             FROM   #tempjobstatus 
             WHERE  jobname ='AnaRefresh') 
      IF (@statusAnalyticsRefresh = 'In Progress') 
      BEGIN 
        SET @statusJobExecutionLogId = 
        ( 
               SELECT jobexecutionlogid 
               FROM   #tempjobstatus 
               WHERE  jobname ='AnaRefresh') 
        UPDATE jobexecutionlog 
        SET    jobstatus = 'Failed' 
        WHERE  jobexecutionlogid = @statusJobExecutionLogId 
        SET    @statusReturn=1 
      END 
      ELSE SET @statusReturn =0
    END 
    ELSE  IF (@statusSPDRefresh = 'Completed') 
    BEGIN 
      SET @statusAnalyticsRefresh = 
      ( 
             SELECT jobstatus 
             FROM   #tempjobstatus 
             WHERE  jobname ='AnaRefresh') 
      IF (@statusAnalyticsRefresh = 'In Progress') 
      BEGIN 
        SET @statusJobExecutionLogId = 
        ( 
               SELECT jobexecutionlogid 
               FROM   #tempjobstatus 
               WHERE  jobname ='AnaRefresh') 
        UPDATE jobexecutionlog 
        SET    jobstatus = 'Completed' 
        WHERE  jobexecutionlogid = @statusJobExecutionLogId 
        SET    @statusReturn=1 
      END 
      ELSE SET @statusReturn =0
    END 
    ELSE 
   BEGIN 
    SET @statusReturn=0 
    END
    DROP TABLE #tempjobstatus
    END