Thanks for the example, it was helpful to an extent, though did solve the complete problem.. I need a way to check the next an previous row values depending...
Thanks for correcting the statement.. I have tried the sql and it updates the value with the last DateTime value i.e., '2010-04-13 04:00:00.000' instead of updating it with the next...