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

2 votes330 views1 answer
Mysql application.properties spring boot
SQL
0 vote304 views1 answer
Concat column value of same user in mysql
SQL
3 votes344 views2 answers
Check data in table mysql
SQL
0 vote337 views1 answer
List in one column mysql
SQL
0 vote316 views1 answer
Start and stop mysql
SQL
1 vote299 views1 answer
Import local sql into remote mysql
SQL
0 vote379 views1 answer
How to add auto increment primary key
SQL
0 vote311 views1 answer
Sql decode
SQL
0 vote305 views1 answer
Except in sql alchemy
SQL
3 votes337 views1 answer
Only join in sql
SQL