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

1 vote200 views1 answer
Sql try catch
SQL
4 votes197 views1 answer
Wilayah indonesia database
SQL
1 vote226 views4 answers
Aggregate function in sql
SQL
0 vote234 views1 answer
How to insert same table data using mysql query
SQL
0 vote199 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
-1 vote211 views1 answer
Module operator in oracle sql
SQL
2 votes249 views1 answer
Mysql trigger after update
SQL
2 votes204 views1 answer
How to make insert script from table in SQL server
SQL
2 votes157 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote270 views1 answer
Jooq replace
SQL