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

12 votes142 views4 answers
SQL Where
SQL
0 vote208 views2 answers
Cascade syntax in sql
SQL
6 votes179 views3 answers
Mysql remove user privileges
SQL
0 vote156 views1 answer
Mysql date time string format for marshmellow field schema
SQL
3 votes192 views2 answers
Brew restart mysql
SQL
0 vote241 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote144 views1 answer
Sql string length postgresql
SQL
9 votes142 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote157 views1 answer
Java sql timestamp now
SQL
2 votes147 views1 answer
SELECT INTO
SQL