How would be the SQL statement to get the column names of a Transposed table in AF?
As far as I know, there is no direct way, within PI OLEDB Enterprise, to do that because there is no equivalent to the MS SQL catalog views in PI OLEDB.
You would currently have to leave the SQL world to get it. If you wanted the actual schema, then you might want to refer to this previous discussion: vcampus.osisoft.com/.../797.aspx
Depending on what you want, you could sort of fake it via the following query.
Select top 1 transposed.* from (Your tables/joins/etc go here) transposed where 1 = 0.
Thank you for your suggestion.
Retrieving data ...