UPDATE n.wmsLog

SET n.wmsLog.countrya2 = dbo.GeoIP.a2

FROM n.wmsLog INNER JOIN dbo.GeoIP ON n.wmsLog.longIP BETWEEN dbo.GeoIP.startLongIP AND dbo.GeoIP.endLongIP

WHERE n.wmsLog.pubpoint = 'abcd'

I think this is what you were looking for???

I know this is just an example that you presented in the article. So I have a recommedation ( learnt over time).

When you are working with connections to the database...