I am connecting to a historian and I can only connect to it with OLE DB and it only allows SET and SELECT statements in SQL queries. It follows the SQL-92 convention.
So I want to query one column in the historian and produce a few columns based on some kind of sorting.
In that one column in the historian the data looks like this:
I then want to sort that data into three columns looking like so:
column A| column B| column C
CAR_PART_A BOAT_PART_A PLANE_PART_A
CAR_PART_B BOAT_PART_B PLANE_PART_B