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

19 votes102 views2 answers
Mysql tinyint max value
SQL
0 vote100 views1 answer
Mysql isshow
SQL
0 vote165 views1 answer
How to rename a database in tsql
SQL
-1 vote59 views1 answer
Oracle db list usernames
SQL
0 vote104 views1 answer
Sql orcale i forgot what my name & password was
SQL
2 votes97 views1 answer
Install sqlite npm
SQL
5 votes171 views2 answers
Mysql date greater than 30 days
SQL
0 vote113 views1 answer
How to input data as id in database sql c#
SQL
0 vote106 views1 answer
Price-colour
SQL
0 vote114 views1 answer
How to check which table has data in mysql
SQL