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 vote309 views1 answer
How to change null display in psql
SQL
2 votes296 views1 answer
Create table with primary key
SQL
20 votes334 views1 answer
Get all table name in sql through php
SQL
3 votes299 views2 answers
Oracle apex charging debug
SQL
3 votes333 views2 answers
Sqlite show table structure
SQL
0 vote292 views1 answer
Mysql function variable
SQL
0 vote307 views1 answer
Mssql now diff 90 day
SQL
0 vote306 views1 answer
Sql select max value for each group
SQL
5 votes310 views1 answer
Sqlite alter table add column
SQL
0 vote292 views1 answer
Order by monthly in sql
SQL