Our SQL Server loop kept writing the previous row's value

It ran fine for months, then started corrupting data. The cause was two T-SQL behaviors I thought I understood. We had a batch procedure that resolved a value for each item and wrote it to a permanent...