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 vote370 views1 answer
Sql server set complex constraints
SQL
0 vote343 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
2 votes385 views5 answers
Install postgresql 10 centos 7
SQL
0 vote369 views1 answer
Sql delete from with relation
SQL
0 vote364 views1 answer
Linebreak sql
SQL
4 votes360 views1 answer
Oracle select first 10 rows
SQL
0 vote380 views1 answer
Trigger stock phpmyadmin
SQL
2 votes343 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote368 views1 answer
Oracle sql log to console
SQL
0 vote352 views1 answer
How to check default value of column in sql server
SQL