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

8 votes202 views1 answer
My sql version
SQL
0 vote216 views1 answer
Databricks install odbc driver connect to sql server
SQL
4 votes200 views2 answers
Installing sql on ubuntu
SQL
0 vote184 views3 answers
Insert or ignore postgres
SQL
0 vote205 views1 answer
Provide hardcoded value in the mysql query
SQL
17 votes260 views4 answers
Show all tables in oracle
SQL
0 vote189 views2 answers
Null value in column violates not-null constraint
SQL
0 vote186 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
8 votes203 views1 answer
See all users mysql
SQL
0 vote196 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL