SET NOCOUNT ON;
DECLARE @SQL NVARCHAR(MAX)
DECLARE @ID  int
,@name NVARCHAR(2000)
      ,@dt NVARCHAR(2000)
      ,@telnum NVARCHAR(2000)
      ,@filial NVARCHAR(2000)
      ,@cod NVARCHAR(2000)
      ,@ans1 NVARCHAR(2000)
      ,@ans2 NVARCHAR(2000)
      ,@ans3 NVARCHAR(2000)
      ,@ans4 NVARCHAR(2000)
      ,@ans5 NVARCHAR(2000)
      ,@ans6 NVARCHAR(2000)
      ,@ans7 NVARCHAR(2000)
      ,@ans8 NVARCHAR(2000)
      ,@ans9 NVARCHAR(2000)
      ,@ans10 NVARCHAR(2000)
      ,@ans11 NVARCHAR(2000)
      ,@ans12 NVARCHAR(2000)
      ,@noans NVARCHAR(2000)

DECLARE vendor_cursor CURSOR FOR
SELECT [id]
      ,[name]
      ,[dt]
      ,[telnum]
      ,[filial]
      ,[cod]
      ,[ans1]
      ,[ans2]
      ,[ans3]
      ,[ans4]
      ,[ans5]
      ,[ans6]
      ,[ans7]
      ,[ans8]
      ,[ans9]
      ,[ans10]
      ,[ans11]
      ,[ans12]
      ,[noans]
   FROM [oktell].[dbo].[olp_temp_abonent_table_dialog]

OPEN vendor_cursor

FETCH NEXT FROM vendor_cursor
INTO   @ID,@name,@dt
      ,@telnum
      ,@filial
      ,@cod
      ,@ans1
      ,@ans2
      ,@ans3
      ,@ans4
      ,@ans5
      ,@ans6
      ,@ans7
      ,@ans8,@ans9,@ans10,@ans11,@ans12,@noans

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT '123 '
SET @SQL =  'INSERT INTO OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 12.0;Database='+@cod+''',''select [id],[dt],[tel] ,[name],[filial],[ans1],[ans2],[ans3],[ans4],[ans5],[ans6],[ans7],[ans8],[ans9],[ans10],[ans11],[ans12],[noans] from [Лист1$]'')'+
'SELECT ''' +CAST(@ID AS NVARCHAR(5))+
''','''+ ISNULL(@dt,'')+
''','''+ ISNULL(@telnum,'') +
''','''+ ISNULL(@name,'') +
''','''+  ISNULL(@filial,'')+
''','''+ ISNULL(@ans1,'') +
''','''+ISNULL(@ans2,'') +
''','''+ISNULL(@ans3,'')+
''','''+ISNULL(@ans4,'')+
''','''+ISNULL(@ans5,'')+
''','''+ISNULL(@ans6,'')+
''','''+ISNULL(@ans7,'')+
''','''+ISNULL(@ans8,'')+
''','''+ISNULL(@ans9,'')+'
'','''+ISNULL(@ans10,'')+
''','''+ISNULL(@ans11,'')+
''','''+ISNULL(@ans12,'')+
''','''+ISNULL(@noans,'')+''''
  PRINT @SQL

  EXECUTE (@SQL)

  DELETE [oktell].[dbo].[olp_temp_abonent_table_dialog] WHERE [id] =  @ID AND [cod] = @cod

FETCH NEXT FROM vendor_cursor
INTO   @ID,@name,@dt
      ,@telnum
      ,@filial
      ,@cod
      ,@ans1
      ,@ans2
      ,@ans3
      ,@ans4
      ,@ans5
      ,@ans6
      ,@ans7
      ,@ans8,@ans9,@ans10,@ans11,@ans12,@noans

END
CLOSE vendor_cursor;
DEALLOCATE vendor_cursor;