Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 09, 2021 06:43 PM
SELECT FullName FROM CLEARSCADA..Core.CDBPoint
SELECT TOP( 100000 ) "RecordTime", "FormattedValue", "StateDesc"FROM CS1..Historic.CDBHistoricWHERE "Id" = 124 AND "RecordTime" > { ts '2008-06-02 00:00:00' }ORDER BY "RecordTime" DESC
SELECT TOP( 100000 ) "RecordTime", "FormattedValue", "StateDesc"FROM CS..Historic.CDBHistoricWHERE "Id" = 124ORDER BY "RecordTime" DESC
SELECT * FROM OPENQUERY(CS, 'SELECT TOP( 100000 ) RecordTime, FormattedValue, StateDescFROM CDBHistoricWHERE Id = 2133 AND RecordTime > { ts ''2008-06-02 00:00:00'' }ORDER BY RecordTime DESC')
declare @x as datetimeset @x = convert(datetime , '2008-06-02 00:00:00')select Id, RecordTime, StateDesc from alpha..Historic.CDBHistoric where RecordTime > @x
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.