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 vote205 views1 answer
How to dump .csv file into mysql
SQL
0 vote204 views1 answer
Mysqldump ignore table
SQL
0 vote198 views1 answer
Unique index in mysql
SQL
1 vote237 views1 answer
Psql view enum values
SQL
2 votes171 views2 answers
Mysql get last character of string
SQL
0 vote212 views1 answer
Azure sql server check foreign key
SQL
0 vote209 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
1 vote194 views1 answer
Select statement to print longest name
SQL
0 vote201 views1 answer
Sql combine results from two tables
SQL
4 votes162 views3 answers
Create table if not exists postgresql
SQL