5 Replies Latest reply on Nov 21, 2017 3:23 PM by vkaufmann

    Is there a PRINT command in the basic SQL commands available in PI SQL Commander ?

    SalGarcia

      I have the following very simple query to bring timestamp and value for two tags:

       

      SELECT time,value FROM piarchive..picomp2

      WHERE tag = 'TAG_A' AND time BETWEEN '2017-09-21 08:49:00' AND '2017-09-21 10:42:00'

      UNION

      SELECT time,value FROM piarchive..picomp2

      WHERE tag = 'TAG_A' AND time BETWEEN '2017-09-21 08:49:00' AND '2017-09-21 09:42:00'

       

      Now the output is a running table with no text to differentiate between the output from the first SELECT and the second SELECT, I was trying to use the PRINT command after the UNION statement to insert a string between the SELECTS, but the software doesn't seem to recognize the PRINT command.

      Is there an equivalent command I can use? (PI SQL Commander 2016 R2)

       

      Thanks

      SGM