Setting OrderNumber of rows in a table
## Summary A developer attempted to set sequential `OrderNumber` values for time zones, prioritizing US entries first (sorted alphabetically) followed by others (also alphabetically). The initial approach with `ROW_NUMBER()` failed due to improper partitioning/ordering and incorrect update logic. ## Root Cause – The `ROW_NUMBER()` calculation in the subquery operated solely on the **subset of US … Read more