Update the table without looping

[shinelawrence]

Hi All,

I have two tables, I need single query update the column of new from first table into the second table of New Column without looping. Kindly do the needful.

Please refer the screenshot.

Thanks,
Lawrence

[bitsmed]

https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-2017

[ahmeds08]

Can you try this?

UPDATE
Table2 SET
Table2.New=T1.New FROM
Table1 T1
INNER JOIN
Table2 T2 ON
T1.Rnk= T2.Rnk;

[shinelawrence]

@ahmeds08

UPDATE
Table2 SET
Table2.New=T1.New FROM
Table1 T1
INNER JOIN
Table2 T2 ON
T1.Rnk= T2.Rnk;

Thanks for your reply, it's working