Thanks, that works abit faster but its still very slow. 16hrs and no where near done

That took 46 seconds.

I tried select * from @basedata, but it didn't work. It says 'must declare the table variable @basedata'. I'm new to sql so apologies if this is...