Posted by iamonthisboat on 12/21/05 23:27

I have a data set like so:


UTC_TIME Timestamp NodeID Message Flag
Line
Station
11/19/2005 10:45:07 1132397107.91 1 3 5 1028
1034
11/3/2005 21:05:35 1131051935.20 2 3 5 1009
1043
11/25/2005 21:12:16 1132953136.59 3 3 5 1037
1049


I added the UTC_TIME column in as aconversion of the unix timestamp in

the TIMESTAMP column.


Keeping things simple and straightforward, I need to be able to
calculate the difference from one record to the next (ordered by
TIMESTAMP or UTC_TIME) and output the result into another column in the

table.


NODEID is the unique id.


First, what is the function to do so if, say, I only wanted to
calculate the difference between 2 records as just a basic SELECT
statement. That way I can answer quick question based on any one or two

NODEID's.


Second, how would I further that to continually calculate (as stated
above)?


WOuld this be a stored procedure? A trigger? A cursor?


I am learning as I go here. Any help is greatly appreciated.


R.

[Back to original message]