here I have another problem with the PI OLEDB SQL.
I need a SQL statement who reads the current value from the piarchive..pisnapshot (and also data from the pipoint..Alarm). The problem is I need only the the current value and with the SELECT string (see below) I get mutiple values with the same tag. Has anyone here a solution for the problem?
string sqlSelect = "SELECT DISTINCT a.tag, a.exdesc, a.descriptor, s.status, s.time
FROM pipoint..Alarm a, piarchive..pisnapshot s
WHERE a.pointsource = '@' AND s.status <> '0' AND time > '*-2m'"