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
Sql dmv to capture updates
SQL
2 votes156 views1 answer
Sql server current date minus 5 years
SQL
2 votes138 views1 answer
Oracle find unusable indexes
SQL
0 vote198 views1 answer
Run docker container with database as rds metabase
SQL
0 vote149 views1 answer
Insert using condition postgres
SQL
2 votes130 views1 answer
Sqlplus clear screen
SQL
0 vote139 views1 answer
How to see the query of a view in mysql
SQL
27 votes137 views5 answers
Add column in table
SQL
0 vote149 views1 answer
Get who is hired in february in sql
SQL
0 vote140 views1 answer
Psql select * from table
SQL