Home Forums SQL Server 2005 Development Query really slow with eager spool RE: Query really slow with eager spool
Stéphane
SSC-Addicted
Points: 470
More actions
January 10, 2007 at 9:04 am
#682417
The problem with that update is that I don't have the exact IP converted in float in tbl_ip2countries. I mean, I have only a range so Canada is assigned to 123.123.123.0 to 123.123.123.256. So I can't join on r.ipFloat = c.ipFloat.
Thanks!