>I'm a little confused what you're trying to do...it looks like you're querying the temp table, one row at a time, and placing the columns from each row into a variable???

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.