СпрПрайЛисты = Справочники.ПрайсЛисты;
НовыйПрайсЛист = СпрПрайЛисты.СоздатьЭлемент();
НовыйПрайсЛист.Записать();
UUID = НовыйПрайсЛист.Ссылка.УникальныйИдентификатор();
ГУИДSQL = ПреобразоватьUUIDвГУИДSQL(UUID);

USE [UPP_11_04_2018]
GO

Truncate table _Reference29065

DROP TABLE IF EXISTS #Temp

CREATE TABLE #Temp(
	[_IDRRef] uniqueidentifier default newsequentialid() not null primary key clustered,
	[_Marked] [binary](1) NOT NULL,
	[_PredefinedID] [binary](16) NOT NULL,
	[_Description] [nvarchar](10) NOT NULL,
	[_Fld29066] [varbinary](max) NOT NULL
) 
GO


SET NOCOUNT ON
DECLARE @prevCount int;

SELECT @prevCount =   (SELECT MAX(CAST(_Description AS int)) FROM _Reference29065) 

declare @count int;
set @count = 0;
while @count < 10 begin
   
   IF @prevCount IS NULL
   BEGIN
   insert #Temp ([_Marked],[_PredefinedID],[_Description],[_Fld29066])
    values (0,0,@count,0x01010800000000000000EFBBBF7B2255227D);
	END
   ELSE
   insert #Temp ([_Marked],[_PredefinedID],[_Description],[_Fld29066])
	values (0,0,@count+@prevCount+1,0x01010800000000000000EFBBBF7B2255227D);

   set @count = @count + 1;
end;
go

DROP TABLE IF EXISTS #Temp_VT

CREATE TABLE #Temp_VT(
	
	[_KeyField] int identity(1,1) not null primary key clustered,--[binary](16) NOT NULL,
	sequence int not null
) 
GO

SET NOCOUNT ON
declare @count int;
set @count = 0;
while @count < 40000 begin
   insert #Temp_VT (sequence)
   values (@count);

   set @count = @count + 1;
end;
go 
 
INSERT INTO _Reference29065 (

	[_IDRRef] ,
	[_Marked],
	[_PredefinedID],
	[_Description] ,
	[_Fld29066] 

)

SELECT
      
	dbo.GUIDto1C(_IDRRef),
	[_Marked],
	[_PredefinedID],
	[_Description] ,
	[_Fld29066] 
	
FROM #Temp 

  
Truncate table _Reference29065_VT29100
go 

DECLARE @IDRRef binary(16)
DECLARE cur CURSOR FOR 
SELECT _IDRRef FROM _Reference29065 ORDER BY _IDRRef;
OPEN cur

FETCH NEXT FROM cur INTO @IDRRef

WHILE @@FETCH_STATUS = 0
BEGIN 
  
	INSERT INTO [dbo].[_Reference29065_VT29100]
           ([_Reference29065_IDRRef]
           ,[_KeyField]
           ,[_LineNo29101]
           ,[_Fld29102]
           ,[_Fld29103RRef]
           ,[_Fld29104])
     SELECT 
           @IDRRef
           ,_KeyField--<_KeyField, binary(4),>
           ,0--<_LineNo29101, numeric(5,0),>
           ,''--<_Fld29102, nvarchar(25),>
           ,0--<_Fld29103RRef, binary(16),>
           ,0--<_Fld29104, numeric(15,2),>)
	FROM #Temp_VT
		
    FETCH NEXT FROM cur INTO @IDRRef
END
CLOSE cur
DEALLOCATE cur

USE [UPP_11_04_2018]
GO

Truncate table _Reference29065

SET NOCOUNT ON

declare @count int;
set @count = 0;
while @count < 10 begin
   
	INSERT INTO _Reference29065 (

	[_IDRRef] ,
	[_Marked],
	[_PredefinedID],
	[_Description] ,
	[_Fld29066] 

	)
	SELECT 
	newid(),0,0,@count,0x01010800000000000000EFBBBF7B2255227D
	
   set @count = @count + 1;
end;
go


DROP TABLE IF EXISTS #Temp_VT

CREATE TABLE #Temp_VT(
	
	[_KeyField] int identity(1,1) not null primary key clustered,
	sequence int not null
) 
GO

SET NOCOUNT ON
declare @count int;
set @count = 0;
while @count < 40000 begin
   insert #Temp_VT (sequence)
   values (@count);

   set @count = @count + 1;
end;
go 

Truncate table _Reference29065_VT29100
go

DECLARE @IDRRef binary(16)
DECLARE cur CURSOR FOR 
SELECT _IDRRef FROM _Reference29065 ORDER BY _IDRRef;
OPEN cur
FETCH NEXT FROM cur INTO @IDRRef
WHILE @@FETCH_STATUS = 0
BEGIN 
  
	INSERT INTO [dbo].[_Reference29065_VT29100]
           ([_Reference29065_IDRRef]
           ,[_KeyField]
           ,[_LineNo29101]
           ,[_Fld29102]
           ,[_Fld29103RRef]
           ,[_Fld29104])
     SELECT 
           @IDRRef
           ,_KeyField--<_KeyField, binary(4),>
           ,0--<_LineNo29101, numeric(5,0),>
           ,''--<_Fld29102, nvarchar(25),>
           ,0--<_Fld29103RRef, binary(16),>
           ,0--<_Fld29104, numeric(15,2),>)
	FROM #Temp_VT
		
    FETCH NEXT FROM cur INTO @IDRRef
END
CLOSE cur
DEALLOCATE cur

Truncate table _Reference29065_VT29100
go

DECLARE @IDRRef binary(16)
DECLARE cur CURSOR FOR 
SELECT _IDRRef FROM _Reference29065 ORDER BY _IDRRef;
OPEN cur

FETCH NEXT FROM cur INTO @IDRRef

WHILE @@FETCH_STATUS = 0
BEGIN 
  
	INSERT INTO [dbo].[_Reference29065_VT29100]
           ([_Reference29065_IDRRef]
           ,[_KeyField]
           ,[_LineNo29101]
           ,[_Fld29102]
           ,[_Fld29103RRef]
           ,[_Fld29104])
     SELECT 
           @IDRRef
           ,_KeyField--<_KeyField, binary(4),>
           ,0--<_LineNo29101, numeric(5,0),>
           ,''--<_Fld29102, nvarchar(25),>
           ,0--<_Fld29103RRef, binary(16),>
           ,0--<_Fld29104, numeric(15,2),>)
	FROM #Temp_VT
		
    FETCH NEXT FROM cur INTO @IDRRef
END
CLOSE cur
DEALLOCATE cur

INSERT INTO @P1(img)
SELECT BulkColumn 
FROM Openrowset( Bulk '"+ИмяФайла+"', Single_Blob) AS img

SELECT dbo.sp_getid(СпрПоставщиков.Ссылка) AS Ссылка
FROM @P1 AS TT
INNER JOIN dbo.Справочник.ПрайсыПоставщиков AS СпрПоставщиков
ON  CAST(СпрПоставщиков.Файл AS varbinary(max)) = TT.img