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 votes176 views1 answer
Invalid column name sql
SQL
0 vote200 views3 answers
Postgres date difference seconds
SQL
1 vote231 views1 answer
Encrypt password postgresql
SQL
0 vote201 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote185 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote183 views1 answer
Get last three characters in mysql column
SQL
0 vote143 views0 answer
SQL
16 votes186 views1 answer
CTE statement sql server
SQL
1 vote190 views1 answer
Show table status command in mysql
SQL
4 votes136 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL