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

1 vote282 views1 answer
Search for tables with name postgresql
SQL
0 vote309 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote292 views1 answer
Mysql query bulk insert
SQL
0 vote311 views1 answer
Rails sql query converstion
SQL
0 vote290 views1 answer
Empty table sqlite
SQL
0 vote304 views1 answer
How to update sql server version
SQL
0 vote304 views2 answers
Imageview setimageresource null
SQL
0 vote348 views1 answer
Sql server query all database objects
SQL
1 vote316 views1 answer
Sql check roles
SQL
0 vote297 views1 answer
Copy Table from SQL to CSV
SQL