Have PI OLEDB work with structured annotations.Hopefully at the very least with String Type annotations.3 votes
We did install the SQL Client software on our SQL server, but there was no option to exclude the SQL Commander Lite. So, we had to turn around and uninstall SQL Commander Lite. I'd just like to suggest for future install packages that there be an option to exclude SQL Commander Lite.2 votes
Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as:
SELECT time, (time - 1d) as datekey
This query works
SELECT time, (time + 1d) as datekey
A similar query can be written using a linked server but requires the additional overhead of a sql server or ssms.
SELECT time, DATEADD(day, -1, time) as datekey
WHERE tag='sinusoid'1 vote
- Don't see your idea?