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

5 votes206 views2 answers
Update all rows mysql
SQL
0 vote222 views1 answer
Postgres reorder columns
SQL
2 votes225 views1 answer
Sql server current date minus 5 years
SQL
0 vote202 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote220 views1 answer
Drop CHECK constraint sql
SQL
0 vote226 views1 answer
Postegresql update to null
SQL
0 vote231 views1 answer
How to delete duplicate rows in oracle
SQL
4 votes213 views4 answers
What is primary key
SQL
0 vote219 views2 answers
SQL BULK INSERT
SQL
0 vote214 views4 answers
Mysql select bottom 10 rows
SQL