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

1 vote115 views1 answer
Search for tables with name postgresql
SQL
0 vote137 views1 answer
Combine 2 columns search query mysql
SQL
0 vote112 views1 answer
Oracle last connection
SQL
0 vote122 views1 answer
Sql select sum group by id laravel join
SQL
0 vote115 views2 answers
Sql server Insert Into table
SQL
1 vote111 views1 answer
Base nosql
SQL
0 vote115 views1 answer
Query archive mode
SQL
1 vote114 views1 answer
Oracle sql listagg
SQL
24 votes108 views4 answers
Mssql get all table names
SQL
0 vote111 views1 answer
Mysqldump don't drop table
SQL