AnsweredAssumed Answered

Execute SQL and read from file to read tags

Question asked by J.Groeneveld on Dec 15, 2015
Latest reply on Dec 22, 2015 by Roger Palmen

Hi all,

 

I want to execute a SQL command and read the input from a txt file.

 

As an example something like this:

 

SELECT *

FROM [piarchive].[piavg]

WHERE tag = <C:\TEMP\Input.txt> 

     AND time BETWEEN '*-1h' AND '*'

 

Did anyone of you did this and what is the proper way to do this?

 

Thanks in advance for saving my time

 

Jeroen

Outcomes