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 vote130 views1 answer
Sql comparison operators
SQL
0 vote200 views1 answer
Check user sql password from command line
SQL
0 vote182 views1 answer
Capabilities of sql select statements
SQL
0 vote142 views1 answer
Use mysql in java program
SQL
0 vote134 views1 answer
Import all databases mysql
SQL
0 vote183 views1 answer
Generate sql from specific migration ef core
SQL
0 vote125 views1 answer
Minecraft duping allowed servers
SQL
0 vote152 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote126 views1 answer
Full syntax inner join
SQL
4 votes145 views1 answer
Id increment ms sql server
SQL