Re: Need help with a simple trigger

[Darren White]

I'll describe what I'm trying to do.

I have a table with perhaps 20 columns and 50 rows. The position of data is fixed and continually updates, i.e. table doesn't grow in size.

I want to log particular columns of data and so set up a new table2 where the columns represent the rows of the first table. So table1.row1 = table2.col1

For example, in the first table I may have a column "temperature", where the 50 rows are temperature readouts from 50 different sensors. I want to log the temperature over time for particular sensors. So my log table for temperature would have columns sensor1, sensor2, sensor3....sensor50.