Geez...

Still the same results. Works great for 40-50-60, but not for any other number...

I tried this hint:

update

r

set

countryId = c.countryId

from

#regions r join tbl_ip2countries c WITH (INDEX(PK_tbl_ip2countries))

on

r.ipFloat between c.ipFrom and c.ipTo

Does not improve anything...

Thanks for your time guys!

Stephane