1 Replies - 456 Views - Last Post: 11 March 2009 - 11:13 PM Rate Topic: -----

#1 madhusudhans  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 23-January 09

regarding max,min value of date differences between same row

Posted 11 March 2009 - 10:23 PM

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

eventtime datetime

simid varchar(4)

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

Is This A Good Question/Topic? 0
  • +

Replies To: regarding max,min value of date differences between same row

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1633
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: regarding max,min value of date differences between same row

Posted 11 March 2009 - 11:13 PM

[rules][/rules]
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1