Author: Roy Harvey (SQL Server MVP)
Date: Jul 21, 2008 23:33
...> 10,10,1 10,11,2 10,12,3 10,13,4 10,14,5 10,15,6 but i am getting like 10,10,1 10,11,1 10,12,1 10,13,1 10,14,1 10,15,1 As for why the results look that way, the UPDATE command updates ALL the rows together. The getnumber function executes before any rows are updated against the table as it exists as the UPDATE command starts. Roy Harvey Beacon Falls, CT
| 
