Необходимо объявить скалярную переменную!

USE TestBase
GO
 
CREATE PROCEDURE InsertIntoVendor 
    @userData InsertVendor READONLY,
    @product dbo.InsertProduct READONLY,
    @offer InsertOffer READONLY
AS
BEGIN
    INSERT INTO dbo.Product
    (
        [Price],
        [Url],
        [Picture],
        [Description],
        [CurID],
        [CatID]
    )
    VALUES
    (
        @product.[Price],
        @product.[Url],
        @product.[Picture],
        @product.[Description],
        @product.[CurID],
        @product.[CatID]
    )
 
    INSERT INTO dbo.Offer
    (
        [ID],
        [Bid],
        [Cbid],
        [Available]
    )
    VALUES
    (
        @offer.[ID],
        @offer.[Bid],
        @offer.[Cbid],
        @offer.[Available]
    )
 
    INSERT INTO dbo.VendorModel 
    (
        [ProductID],
        [Delivery],
        [ManufacturerWarranty],
        [LocalDeliveryCost],
        [TypePrefix],
        [Vendor],
        [VendorCode],
        [Model],
        [CountryOrigin],
        [OfferID]
    )
    VALUES
    (
        @userData.ProductID,
        @userData.Delivery,
        @userData.ManufacturerWarranty,
        @userData.LocalDeliveryCost,
        @userData.TypePrefix,
        @userData.Vendor,
        @userData.VendorCode,
        @userData.Model,
        @userData.CountryOrigin,
        @userData.OfferID
    )
END
GO

 
--МАССОВАЯ ВСТАВКА НЕСКОЛЬКИХ ФАЙЛОВ_CSV ИЗ ПАПКИ 
--Пока что ругается на курсор
 
  
    IF (OBJECT_ID('tempdb..#csv_temp') IS NOT NULL) DROP TABLE #csv_temp;
    
    CREATE TABLE #csv_temp(
            [Times] VARCHAR (100),
            [Caller_Name] INT,
            [Caller_Number] INT,
            [Callee_Name] INT,
            [Callee_Numbers] VARCHAR(100),
            [DOD] VARCHAR(100),
            [DID] VARCHAR(100),
            [Call_Duration_(s)] INT,
            [Talk_Duration_(s)] INT,
            [STATUS] VARCHAR(100),
            [Source_Trunk] VARCHAR(50),
            [Destination_Trunk] VARCHAR(100),
            [Communication_Type] VARCHAR(100),
            [PIN_Code] VARCHAR(10),
            [Caller_IP_Address] VARCHAR(200),
            [Cost] VARCHAR(100),
            [Billing_Account] VARCHAR(100)
            ) 
 
    -- Переменые 
    DECLARE @filename VARCHAR(255),
            @path     VARCHAR(255),
            @SQL      VARCHAR(8000),
            @cmd      VARCHAR(1000),
            @Times   VARCHAR(1000), 
            @Caller_Name  INT,
            @Caller_Number INT,
            @Callee_Name INT,
            @Callee_Numbers VARCHAR(100),
            @DOD VARCHAR(100),
            @DID VARCHAR(100),
            @Call_Duration_(s)INT,
            @Talk_Duration_(s) INT,
            @STATUS VARCHAR(100),
            @Source_Trunk VARCHAR(50),
            @Destination_Trunk VARCHAR(100),
            @Communication_Type VARCHAR(100),
            @PIN_Code VARCHAR(10),
            @Caller_IP_Address VARCHAR(200),
            @Cost VARCHAR(100),
            @Billing_Account VARCHAR(100)
    --получить список файлов для обработки:
    SET @path = 'C:\serg\'
    SET @cmd = 'dir ' + @path + '*.csv /b'
    
    INSERT INTO #csv_temp
    (       [Times] ,
            [Caller_Name],
            [Caller_Number],
            [Callee_Name],
            [Callee_Numbers] ,
            [DOD],
            [DID],
            [Call_Duration_(s)],
            [Talk_Duration_(s)],
            [Status],
            [Source_Trunk],
            [Destination_Trunk],
            [Communication_Type],
            [PIN_Code],
            [Caller_IP_Address],
            [Cost],
            [Billing_Account]
        )
    --SELECT '17'
    VALUES (
    (SELECT [Times] FROM #csv_temp ),
    (SELECT [Caller_Name] FROM #csv_temp ),
    (SELECT [Caller_Number] FROM #csv_temp ),
    (SELECT [Callee_Name] FROM #csv_temp ),
    (SELECT [Callee_Numbers] FROM #csv_temp ),
    (SELECT [DOD] FROM #csv_temp ),
    (SELECT [DID] FROM #csv_temp ),
    (SELECT [Call_Duration_(s)] FROM #csv_temp ),
    (SELECT [Talk_Duration_(s)] FROM #csv_temp ),
    (SELECT [Status] FROM #csv_temp ),
    (SELECT [Source_Trunk] FROM #csv_temp ),
    (SELECT [Destination_Trunk] FROM #csv_temp ),
    (SELECT [Communication_Type] FROM #csv_temp ),
    (SELECT [PIN_Code] FROM #csv_temp ),
    (SELECT [Caller_IP_Address] FROM #csv_temp ),
    (SELECT [Cost] FROM #csv_temp ),
    (SELECT [Billing_Account] FROM #csv_temp )
     )
    
    EXEC Master..xp_cmdShell @cmd
    UPDATE #csv_temp SET [Times] = @path where [Times] is null
 
 
    -- Курсор
    declare c1 cursor for SELECT 
            [Times],
            [Caller_Name],
            [Caller_Number],
            [Callee_Name],
            [Callee_Numbers] ,
            [DOD],
            [DID],
            [Call_Duration_(s)],
            [Talk_Duration_(s)],
            [Status],
            [Source_Trunk],
            [Destination_Trunk],
            [Communication_Type],
            [PIN_Code],
            [Caller_IP_Address],
            [Cost],
            [Billing_Account]
 
 FROM #csv_temp where Times like '%.csv%'
 
--Открываем Курсор
    open c1
--- выборка данных
    ---fetch next from c1 into @path,@filename
 fetch next from c1 into @Times,@Caller_Name,@Caller_Number,
@Callee_Name,@Callee_Numbers,@DOD,@DID,@Call_Duration_(s),
@Talk_Duration_(s),@Status,@Source_Trunk,@Destination_Trunk,
@Communication_Type,@PIN_Code,@Caller_IP_Address,@Cost,@Billing_Account
 
 
    While @@fetch_status <> -1
      begin
      --bulk insert won't take a variable name, so make a SQL AND EXECUTE it instead:
       SET @SQL = 'BULK INSERT #csv_temp FROM ''' + @path + @filename + ''' '
           + '     WITH ( 
                   FIELDTERMINATOR = '';'', 
                   ROWTERMINATOR = ''0x0a'', 
                   FIRSTROW = 2 
                ) '
   -- Вывод результата
   print @SQL
    EXEC (@SQL)
 
   --   fetch NEXT FROM c1 INTO @path,@filename
      END
    close c1
    deallocate c1
--------------------------------------------------------------------------------------