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

14 votes259 views1 answer
Excel is not a database
SQL
2 votes256 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote280 views1 answer
Mysql uuid
SQL
3 votes271 views3 answers
Restart mysql mac
SQL
2 votes277 views2 answers
Install postgresql
SQL
1 vote259 views1 answer
Mysql view command
SQL
0 vote256 views1 answer
IIF
SQL
0 vote271 views1 answer
Sql select lowest value row
SQL
2 votes276 views3 answers
Postgres create view
SQL
0 vote289 views1 answer
What is server_default = func.now() in sqlalchemy
SQL