UPDATE fine SET fine.name = RES.name FROM fine INNER JOIN (select Query) AS RES ON fine .CODE=RES.CODE
WITH SelectQuery AS ( SELECT CODE, name FROM ... ) UPDATE fine SET fine.name = RES.name FROM fine INNER JOIN SelectQuery AS RES ON fine.CODE=RES.CODE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)