Using Wonderware's industrial sql server (MS SQL server embedded), how can we change the output format of a query result. When we run the following query
SELECT value, datetime, tagname
WHERE tagname = 'temperature1'
AND DateTime > '24 Mar 1998 05:00'
we get a column of "temperature1" (column name is tagname) and a column of the actual temperatures (column name is value). We want 1 column named temperature1 with all the values. Additionally the AS syntax does not work, nor does the CASE statement. Wonderware has been very little help.