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

    Problem with Sql code...please help

    silviu andries

      Hello everyone,

       

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

       

      select count(ClaimId)

      FROM

      (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,

      Silviu.