14 Replies Latest reply on Jun 21, 2018 5:56 PM by vkaufmann

    PI SQL commander and SSRS: how to retrieve multiple values with the same timstamp

    Johan_Van_Acker

      Hello,

       

      Any idea how to retrieve all values on a equal certain timestamp?

      Here some screenshots:

       

      PI Data Archive

      4 values with the same timestamp

       

      PI SQL Commander

      With this query I only get the last value.

       

      SSRS

      The same with SSRS

       

      Somebody has any idea what I should change to get all the values?

       

      Thanks

       

      Johan