Код

	|set nocount on
	|
	|DECLARE @ТоварФильтр char(9)
	|
	|SET @ТоварФильтр = ?
	|
	|BEGIN TRANSACTION
	|
	|DECLARE @vu TABLE ( objid CHAR(9), PRIMARY KEY CLUSTERED (objid) )
	|
	|INSERT INTO @vu
	|SELECT ID FROM
	|$Справочник.Номенклатура (NOLOCK)
	|WHERE
	|$Справочник.Номенклатура.ГлавныйЛист = @ТоварФильтр
	|AND
	|ID <> @ТоварФильтр
	|AND
	|isfolder<>1
	|
	|exec _1sp__1SCONST_TLockX
	|
	|delete from _1sconst
	|where
	|id in (select id from "+ИмяВрТаб+")
	|and
	|objid in (select * from @vu)
	|and docid = '     0   '
	|
	|insert into _1sconst
	|(id, objid, date, value, docid, time, actno,lineno_,tvalue)
	|select seed.id as id, tlist.objid as objid, seed.date as date, seed.value as value, seed.docid as docid, seed.time as time, seed.actno as actno, seed.lineno_ as lineno_, seed.tvalue as tvalue
	|from
	|(select * from _1sconst
	|where
	|id in (select id from "+ИмяВрТаб+")
	|and
	|objid = @ТоварФильтр
	|and docid = '     0   '
	|) seed
	|cross join
	|@vu
	|tlist
	|
	|COMMIT TRANSACTION
	|"