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 vote214 views1 answer
Pl sql search saurce code
SQL
0 vote238 views1 answer
T-SQL Create Trigger
SQL
0 vote225 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote238 views1 answer
Select top values sql
SQL
0 vote241 views1 answer
Sqlite unique multiple columns
SQL
1 vote237 views2 answers
Test sqlsrv connection
SQL
5 votes226 views2 answers
Add column postgres with default value
SQL
0 vote241 views1 answer
Set column in all row mysql
SQL
2 votes187 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote224 views1 answer
Pgadmin see indexes
SQL