5 Replies Latest reply on May 16, 2016 2:47 PM by cor.bader

    Error Question

    Mike Brooks

      Hello all,

       

      I have a lot of workbooks saved that were working properly. Now that I am trying to open them, I am getting the following error on several of them:

      [Microsoft][SQL Server Native Client 11.0][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.[Microsoft][SQL Server Native Client 11.0][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

       

       

      Here is an example of a query I am running:

       

       

       

      If DATEDIFF('day',[Delayed Start Date], TODAY()) >90 AND ISNULL([Case_Note_Date]) Then 1

      Elseif DATEDIFF('day', [Case_Note_Date], TODAY()) > 80 Then 1

      END

      If DATEDIFF('day',[Delayed Start Date], TODAY()) >90 AND ISNULL([Case_Note_Date]) Then 1
      Elseif DATEDIFF('day', [Case_Note_Date], TODAY()) > 80 Then 1
      END

       

      Any guidance on why I am getting this error all the sudden?

       

      Mike