Foreach item in a table update another table T-sql

Question

I have the following update statement

Declare @customerName varchar(40)
Declare @age int

UPDATE [somedatabase].[contact] set age = @age where name = @customerName;

I also have a seperate table lets call cusHash with names and ages. Names are unique. I would like to read the cusHash and run my update statement for all of its values.

http://stackoverflow.com/questions/1604091/update-a-table-using-join-in-sql-server — Pரதீப், Jan 16 '17 at 15:34

score 5 · Accepted Answer · answered Jan 16 '17 at 15:29

5

Instead of going over the values of cusHash one by one, it would be much easier to use an update statement with a join clause:

UPDATE co
SET    co.age = ch.age 
FROM   [somedatabase].[contact] co
JOIN   [somedatabase].[cusHash] ch ON co.name = ch.name

answered Jan 16 '17 at 15:29

Mureinik

297,002
52
306
350

Foreach item in a table update another table T-sql

1 Answers1