Update IP Location Column

UPDATE pageview
SET pageview.IPLocation = (
		SELECT TOP 1 (city + ', ' + region + ' ' + postalCode)
		FROM GeoCityLocation glcl
		INNER JOIN [GeoCityBlocks] glcb ON glcl.locId = glcb.locId
		WHERE (
				pageview.[ipint] BETWEEN startIpNum
					AND endIpNum
				)
			AND region = 'MI'
		)
WHERE url LIKE '%<URL>%'
	AND IPLocation IS NULL

See Page View Details and Get City/State/Country From IP