T-sql update table variale

UPDATE @searchResult
SET [record_id] = r.[record_id], 
    [record_name] = r.[record_name]
FROM @searchResult SR
CROSS APPLY (
    SELECT TOP 1 *
    FROM [records]
    WHERE [record_name] LIKE [name_template]   -- Your wish, but do you really need LIKE matching??
    ORDER BY [record_id] DESC
) AS r;

Source: stackoverflow.com

Similar codes

0 vote274 views1 answer
Python mysql query to dataframe
SQL
0 vote275 views1 answer
Sql values not in another table
SQL
0 vote271 views1 answer
How to connect pgadmin with excel
SQL
4 votes277 views1 answer
Mysql query first character
SQL
2 votes289 views2 answers
Postgres change owner of schema
SQL
2 votes274 views4 answers
Sql query interview questions
SQL
0 vote261 views1 answer
Select from 3 tables one is empty
SQL
0 vote266 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote221 views1 answer
Mysql select top 2
SQL
0 vote267 views1 answer
Cara menampilkan user di mysql terminal
SQL