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 vote276 views1 answer
Mysql wsrep ls
SQL
0 vote265 views7 answers
10 random questions use python and SQL
SQL
0 vote293 views1 answer
Sql stored procedure update if parameter is not null
SQL
20 votes282 views4 answers
Sqlite create table if not exists
SQL
0 vote245 views1 answer
Java spring boot connect to sql server
SQL
0 vote288 views1 answer
Mysql join only one column
SQL
1 vote286 views2 answers
Sql multiline comment
SQL
0 vote292 views1 answer
Group by max date
SQL
2 votes312 views1 answer
Mysql id of inserted row
SQL
0 vote295 views1 answer
How to to get time in sql
SQL