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

12 votes195 views3 answers
Install sqlite driver ubuntu
SQL
25 votes244 views4 answers
Metadata
SQL
1 vote192 views2 answers
How to check username in mysql command line
SQL
1 vote166 views1 answer
Import in mysql without a software
SQL
0 vote189 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
65 votes574 views6 answers
Sql add column to table
SQL
3 votes215 views3 answers
Mysql select table names
SQL
0 vote247 views1 answer
Mysql concatenate select results
SQL
0 vote208 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote218 views1 answer
Sql script to remove default from column
SQL