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 vote181 views1 answer
Mysql select update same table
SQL
4 votes175 views1 answer
Wilayah indonesia sql
SQL
0 vote189 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote181 views1 answer
Gcloud sql instance list
SQL
9 votes187 views1 answer
Alter table column change data type to text mysql
SQL
0 vote202 views2 answers
Coursera spark sql max count
SQL
2 votes212 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote175 views1 answer
Load sql into mamp
SQL
0 vote182 views1 answer
Oracle sql number to varchar2
SQL
1 vote186 views1 answer
Postgres convert date to string
SQL