Insert State Column based on Latitude/Longitude Data
I have a fact table with Latitude and Longitude data, but no states. Is there a way I can leverage the USA States Geocoding data tables to determine the state for each of my lat/long combinations? Ideally I'd like some way to just insert the state column to my fact table data based on the lat/long. Is this possible?