title: Using SQL to get the previous rows data
body: <p>I have a requirement where I need to get data from the previous row to use in a calculation to give a status to the current row. It's a history table. The previous row will let me know if a data has changed in a date field.</p>
  
  <p>I've looked up using cursors and it seems a little complicated. Is this the best way to go?</p>
  
  <p>I've also tried to assgin a value to a new field...</p>
  
  <p>newField =(Select field1 from Table1 where "previous row") previous row is where I seem to get stuck. I can't figure out how to select the row beneath the current row. </p>
  
  <p>I'm using SQL Server 2005</p>
  
  <p>Thanks in advance.</p>