2 Replies Latest reply: Apr 26, 2012 4:11 AM by silviu andries RSS

    Problem with Sql code...please help

      Hello everyone,


      I have a problem with the following SQL code that must be inserted into my pivot table expression:


      select count(ClaimId)


      (SELECT CLaimId

      FROM Dauna 

      WHERE DataRaportare <= '20111231'

      GROUP BY CLaimId

      HAVING SUM(RezervaRamasa) != 0


      I have tried to use "aggr" function and set analysis, but the result is wrong...

      Please help me with this.


      Best regards,