Untitled

-- Создание таблицы buyer_invoice_analysis
CREATE TABLE buyer_invoice_analysis (
    concative NVARCHAR(MAX), -- Определите правильные типы данных для каждого столбца в соответствии с вашими потребностями
    d_date DATE,
    c_number NVARCHAR(MAX),
    is_posted NVARCHAR(MAX),
    price DECIMAL(18, 2),
    quantity DECIMAL(18, 2),
    amount DECIMAL(18, 2),
    today DATE,
    prev_day DATE,
    prev_day_01 DATE,
    count_change INT,
    status_change NVARCHAR(255)
);

-- Копирование данных из временной таблицы #temp_buyer_invoice в buyer_invoice_analysis
INSERT INTO buyer_invoice_analysis (concative, d_date, c_number, is_posted, price, quantity, amount, today, prev_day, prev_day_01, count_change, status_change)
SELECT concative, d_date, c_number, is_posted, price, quantity, amount, today, prev_day, prev_day_01, count_change, status_change
FROM #temp_buyer_invoice;