How to do an Update from a Select in Azure?

Question

I need to update a second table with the results of this query:

SELECT Tag, battery, Wearlevel, SensorTime 
FROM ( 
SELECT m.* , ROW_NUMBER() OVER (PARTITION BY TAG ORDER BY SensorTime DESC) AS rn 
FROM [dbo].[TELE] m  
) m2 
where m2.rn = 1;

But. I had a hard time fixing the SET without messing it up. I want to have a table which has all data from last date of each TAG without duplicates.

If you need further help, pls let me know. – Jason Pan May 06 '21 at 02:22 — Jason Pan, May 06 '21 at 02:22
Does my answer useful to you ? – Jason Pan May 07 '21 at 02:10 — Jason Pan, May 07 '21 at 02:10

score 0 · Accepted Answer · answered May 06 '21 at 02:12

Below code maybe you want.

UPDATE
    Table_A
SET
    Table_A.Primarykey = 'ss'+Table_B.Primarykey,
    Table_A.AddTime = 'jason_'+Table_B.AddTime
FROM
    Test AS Table_A
    INNER JOIN UsersInfo AS Table_B
        ON Table_A.id = Table_B.id
WHERE
    Table_A.Primarykey = '559713e6-0d85-4fe7-87a4-e9ceb22abdcf'

For more details, you also can refer below posts and blogs.

1. How do I UPDATE from a SELECT in SQL Server?

2. How to UPDATE from SELECT in SQL Server

How to do an Update from a Select in Azure?

1 Answers1