I have upsized an Access table into SQL. I'm now going through all data and moving the data into normalized tables. I'm moving the data into variables so I can look tings up with other queries/sprocs.

I hate to sound dogmatic, but ninety-some % of the time, a set-based approach will work better than reading row by row.