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 vote229 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote239 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote233 views1 answer
Mysql utc timestamp
SQL
0 vote227 views1 answer
Postgresql find missing id
SQL
0 vote196 views1 answer
Mysql find foreign key references
SQL
16 votes257 views3 answers
Get count of duplicate records
SQL
1 vote227 views1 answer
How to make a select in sql
SQL
3 votes249 views1 answer
Oracle list privileges
SQL
4 votes251 views2 answers
Installing sql on ubuntu
SQL
0 vote255 views1 answer
Mysql backup query
SQL