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 vote170 views2 answers
How to count codition
SQL
0 vote157 views1 answer
Mysql function variable
SQL
1 vote167 views2 answers
Mysql join two tables
SQL
-1 vote175 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote175 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote197 views1 answer
Sql string function update replace
SQL
0 vote165 views1 answer
Create synonym for dblink in oracle
SQL
-1 vote254 views5 answers
Left join
SQL
0 vote186 views2 answers
Sql stored procedure for access frontend
SQL
0 vote151 views1 answer
Output to file mysql
SQL