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 vote145 views1 answer
Oracle list of long running queries
SQL
0 vote151 views1 answer
Mysql disable query caching
SQL
0 vote208 views1 answer
Postgres extract number from string
SQL
1 vote159 views2 answers
Sql left characters
SQL
0 vote154 views2 answers
Add colum in sql
SQL
1 vote154 views2 answers
Oracle replace
SQL
8 votes158 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote151 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
11 votes164 views2 answers
Safe mode off mysql
SQL
0 vote180 views1 answer
How much space does sql server take per row
SQL