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 vote151 views1 answer
Mysql milliseconds
SQL
0 vote103 views1 answer
Check sql query executed wp
SQL
14 votes149 views2 answers
Sql cast
SQL
0 vote148 views1 answer
Add column in sql server ubuntu
SQL
0 vote159 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote157 views1 answer
Get date ISO in psql
SQL
1 vote196 views1 answer
Postgresql pass array in function
SQL
0 vote161 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
19 votes144 views4 answers
Rename database in sql
SQL
0 vote164 views1 answer
How to create a table in sql stack overflow
SQL