One of the tables has a date column in the sql server database. I need to calculate the time difference between all the consecutive rows i.e., difference between row1 and row2,differance between row2 and row3 and so on... I do know that this can be possible using cursors... Please help me in how to do so... My table structure is as follows
finally i will calculate the minimun and maximun from that row datedifference values....
please help me
thanks in advance
one days data have large amount of data about 30,000 records
1 Replies - 485 Views - Last Post: 11 March 2009 - 11:13 PM
Replies To: regarding max,min value of date differences between same row
Page 1 of 1