CODEWITHSUNDEEP
sql-servert-sql
Boris K
Boris K

Reputation: 3580

Updating one table's column in SQL Server from another

I have a table of measurements from weather stations, with station names (in Hebrew):

enter image description here

I also have created a table of those weather stations with their latitudes and longitudes:

enter image description here

I've written a query that should update the first table with the lat/longs from the second, but it's not working:

update t1
set t1.MeasurementLat = t2.Latitude,
    t1.MeasurementLong = t2.Longitude
from [dbo].[Measurements] as t1
inner join [dbo].[StationCoords] as t2 on t1.StationName like t2.Station

I think there is a problem with the way the station name is being read, and perhaps something to do with encoding, because this query brings back an empty result, too:

SELECT TOP (5) *
FROM [dbo].[Measurements]
WHERE [StationName] = 'אריאל מכללה';

Any ideas?

Upvotes: 0

Views: 35

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270873

Your example names are not the same. Perhaps this will work:

update m
    set MeasurementLat = sc.Latitude,
        MeasurementLong = sc.Longitude
    from dbo.[Measurements] m join
         dbo.[StationCoords] sc
         on m.StationName like sc.Station + '%';

Upvotes: 1

Related Questions