On Friday 09 January 2004 10:17, Evan Brown wrote: > Hey Guys > > I have a bit of a SQL problem and I need some advice. I have a table that > is used to record settings for a device. After the settings are recorded > the device is used. The operator may change the settings after that first > round and re save the settings then run the device again and get a > different result. I have to generate a report that displays the differences > in the settings between runs. Any ideas on comparing 2 different rows of > data in the same table, and then store those differences in another table. >
You could just add a timestamp field into the table, and instead of updating, just insert. The device can always be started by the row with the greatest timestamp. (ie the newest record) Then your reports can be generated for any given timespan. Andy _______________________________________________ clug-talk mailing list [EMAIL PROTECTED] http://clug.ca/mailman/listinfo/clug-talk_clug.ca
