alba_fox

/* Скрипт для отбора */ SELECT b.id,     b.documentclass_ID,     b.dispstatus_id,     b.doc_date,     b.doc_number,     b.amount,    'UPDATE BUDGORDER B SET B.DIRECTION_ID ='||B.DIRECTION_ID||    ', B.DIRECTION_CODE_BUDGLEVEL = '||'"'||B.DIRECTION_CODE_BUDGLEVEL||'"'||    --', B.DIRECTION_DIRECT_GROUP_NAME = '||B.DIRECTION_DIRECT_GROUP_NAME||    ', B.DIRECTION_CODE_NUMBER = '||'"'||B.DIRECTION_CODE_NUMBER||'"'||    ', B.DIRECTION_CAPTION = '||'"'||B.DIRECTION_CAPTION||'"'||    ' where B.ID ='||B.ID||' AND B.direction_id is null;' AS FIX   FROM BUDGORDER B  WHERE B.budget_id IN (SELECT b2.id FROM budget b2 WHERE b2.finyear = 2020)    AND B.documentclass_id IN (10)    AND B.direction_id IS NOT NULL;