is it possible to query the piarchive.piinterp table in combination with join?
I want to query a lot of exact times of an pitag by using the sql server.
Select * from [myDB].[dbo].[myTable] as T1
join [PiServer].[piarchive]..[piinterp] as T2
on T1.pipointname = T2.tag
and T1.timestamp = T2.time