Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
melchor010
Starting Member
2 Posts |
 Posted - 2011-03-01 : 15:37:57
|
| I have a table with the following columnsRow# Start Additions Deductions End1 1000.00 0.002 0.00 1000.003 500.00 0.004 0.00 30.00How do I populate the Start and End columns so that the End column will be the result of adding the columns Start, Additions, and Deductions and the Start column will be equal to the value of the End column of the previous row?Melchor |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
populating fields with values from previous row