Thanks for the ideas. The dense rank option worked really well. My original code took about 15 minutes to update the sales table that has about 400,000 rows, and the...