Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
344 B
1
Indexable
Never
UPDATE kpc
SET kpc.ИНДЕКС = go.NAIVENOVANIE_OKVED
FROM #KP_CommonClientsOkved AS kpc
INNER JOIN [SANDBOX_DB_TEAM_21].[dbo].[GEN_OKVED] AS go
    ON kpc.agent_inn_dil = go.INN
WHERE go.VID_OKVED = 'основной' -- Если нужно обновить только для основных ОКВЭДов
  AND kpc.ИНДЕКС IS NULL;
Leave a Comment