Major Error 0x80040E14, Minor Error 25501
  • hi please i'm writing this query in sql compact but i'm getting error Major Error 0x80040E14, Minor Error 25501:


    My query is that 

    declare @Sum float
    set @Sum= (
     select    SUM(O.ORDER_AMOUNT) -  SUM(P.PAYMENT_Amount)  as PENDING     
    from T_PAYMENT P  inner join T_INVOICE I on  P.INVOICE_ID=I.INVOICE_ID inner join T_ORDER O 
    on I.ORDER_ID=O.ORDER_ID LEFT OUTER JOIN   T_RETURNREQUEST RR on  O.ORDER_ID=RR.ORDER_ID  
    where ORDER_Status = 3 AND (RR.RETURNREQUEST_Status = 1 OR RR.RETURNREQUEST_Status IS NULL))
    declare @SOME float  =( select SUM(@Sum))
    print @SOME



    please how i can resolve this problem or if  there is an other method to get the same result thank you :) .
  • 1 Comment sorted by
  • Hello  @fadoua

    and try using SQL server express edition for running queries.


Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week

    Optimum Creative