title: Update SQL with consecutive numbering
body: <p>I want to update a table with consecutive numbering starting with 1. The update has a where clause so only results that meet the clause will be renumbered.  Can I accomplish this efficiently without using a temp table?</p>