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 vote384 views1 answer
For select oracle
SQL
24 votes347 views5 answers
Sql server insert into select
SQL
0 vote362 views1 answer
On sql table data exists
SQL
3 votes349 views1 answer
RENAME table pl sql
SQL
3 votes379 views1 answer
Sql print all names that start with a given letter
SQL
0 vote342 views1 answer
Redudancy in SQL
SQL
49 votes399 views6 answers
Get duplicate records in sql
SQL
0 vote397 views1 answer
Add new column in sql with foreign key
SQL
7 votes371 views1 answer
Sql pagination oracle
SQL
0 vote348 views1 answer
Sql clear table
SQL