I woulnd't recommend a WHILE loop. It'll be far slower, due to it's inherent repetitive nature. 🙂

When using SQL, try to think in Datasets, rather than programmatically. SQL is far faster at performing changes, evaluating expressions, etc, at a dataset level than it is at doing it Row By Agonising Row (coined as RBAR).