Transposing Results

Discussion created by bswnaosn on Apr 11, 2014
Latest reply on Apr 17, 2014 by bswnaosn

For my current project, I am looking to pull the snapshot values for a number of tags. Ideally I would like to have the typical results for the query transposed, so that the tags become columns. Is there no support for a query (OLEDB Provider) such as this?




SELECT tag, value
FROM [piarchive].[pisnapshot]
WHERE tag IN ( 'sinusoid', 'sinusoidu' )


    tag                  value


1 SINUSOID    123.456


2 SINUSOIDU 456.789


When I'm looking for:




1 123.456      456.789