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 vote331 views1 answer
Truncate left characters mysql
SQL
0 vote495 views1 answer
Sql insert exemplo
SQL
34 votes383 views5 answers
Oracle alter table add column
SQL
0 vote351 views2 answers
Get top 1 row of each group
SQL
16 votes357 views2 answers
Sql exists
SQL
0 vote339 views1 answer
How to query all tables mysql at the same time
SQL
0 vote335 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote360 views1 answer
Oracle tablespace autoextend
SQL
0 vote389 views1 answer
Stored procedure function relation
SQL
8 votes384 views6 answers
Insert command in sql
SQL