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 |
|
gmcgahey
Starting Member
13 Posts |
 Posted - 2006-10-06 : 06:51:55
|
| Newbie question..I have a stored proc that recalculates account balances over several open financial periods. The logic is:update table set Open Period 1 Balance = balance brought fwd from previous yr + period 1 movementupdate table set Open Period 2 Balance = Open Period 1 Balance (calculated above) + period 2 movementThanksGavin My question is whether this update will work 100% of the time if line 2 is directly dependent on the outcome of line 1.Is there a better way to do this? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-06 : 06:57:09
|
| Yes, provided first UPDATE doesn't result in mess !!Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Simple Update Query Question - pls hlp