Регистры сведений. Очистка с отбором. HELP!

Запрос = Новый Запрос;
    Запрос.Текст = "    
    |ВЫБРАТЬ
    |	ЦеныНоменклатуры.Регистратор  
    |ИЗ
    |	РегистрСведений.ЦеныНоменклатуры КАК ЦеныНоменклатуры";

    Результат = Запрос.Выполнить();

    Выборка = Результат.Выбрать();
      
    НаборЗаписей = РегистрыСведений.ЦеныНоменклатуры.СоздатьНаборЗаписей();

    Пока Выборка.Следующий() Цикл

    	НаборЗаписей.Отбор.Регистратор.Установить(Выборка.Регистратор);

    	НаборЗаписей.Записать();	

    КонецЦикла;

exec sp_executesql N'SEL ECT
T1.Q_001_F_000RRef,
T1.Q_001_F_004RRef,
T1.Q_001_F_005RRef,
T1.Q_001_F_001RRef,
T1.Q_001_F_002RRef,
T1.Q_001_F_003_TYPE,
T1.Q_001_F_003_RRRef,
T13.Period_,
T13.Fld7294_TYPE,
T13.Fld7294_RTRef,
T13.Fld7294_RRRef,
T13.Fld7293_,
T13.Fld7292_,
T12._Fld816RRef,
T12._Fld820,
T1.Q_001_F_007_,
T1.Q_001_F_006_,
T17._Description,
T18._Description
FR OM (SEL ECT
T4.Q_001_F_000RRef AS Q_001_F_000RRef,
T4.Q_001_F_001RRef AS Q_001_F_001RRef,
T2.Q_001_F_000RRef AS Q_001_F_002RRef,
T2.Q_001_F_001_TYPE AS Q_001_F_003_TYPE,
T2.Q_001_F_001_RRRef AS Q_001_F_003_RRRef,
T4.Q_001_F_002RRef AS Q_001_F_004RRef,
T4.Q_001_F_003RRef AS Q_001_F_005RRef,
T4.Q_001_F_004_ AS Q_001_F_006_,
T4.Q_001_F_005_ AS Q_001_F_007_
FR OM (SEL ECT DISTINCT
T3._IDRRef AS Q_001_F_000RRef,
CASE WHEN T3._Fld821 = 0x01 THEN CASE WHEN T3._Fld822RRef IS NOT NULL THEN 0x08 END ELSE 0x01 END AS Q_001_F_001_TYPE,
CASE WHEN T3._Fld821 = 0x01 THEN T3._Fld822RRef ELSE @P1 END AS Q_001_F_001_RRRef
FR OM dbo._Reference48 T3
WHERE ((T3._Fld395 = @P2))) T2
INNER JOIN (SEL ECT DISTINCT
T5.Fld7290RRef AS Q_001_F_000RRef,
T5.Fld7291RRef AS Q_001_F_001RRef,
T9._Fld1513RRef AS Q_001_F_002RRef,
CASE WHEN (T10._ParentIDRRef = @P3) THEN T9._Fld1513RRef ELSE T10._ParentIDRRef END AS Q_001_F_003RRef,
T10._Fld2563 AS Q_001_F_004_,
CASE WHEN (T10._ParentIDRRef = @P4) THEN T10._Fld2563 ELSE T11._Fld2563 END AS Q_001_F_005_
FR OM (SELECT
T8._Fld7291RRef AS Fld7291RRef,
T8._Fld7290RRef AS Fld7290RRef
FR OM (SELECT
T7._Fld7289RRef AS Fld7289RRef,
T7._Fld7290RRef AS Fld7290RRef,
T7._Fld7291RRef AS Fld7291RRef,
MAX(T7._Period) AS MAXPERIOD_
FR OM dbo._InfoRg7288 T7
WHERE (T7._Fld395 = @P5)
GROUP BY T7._Fld7289RRef,
T7._Fld7290RRef,
T7._Fld7291RRef) T6
INNER JOIN dbo._InfoRg7288 T8
ON T6.Fld7289RRef = T8._Fld7289RRef AND T6.Fld7290RRef = T8._Fld7290RRef AND T6.Fld7291RRef = T8._Fld7291RRef AND T6.MAXPERIOD_ = T8._Period
WH ERE (T8._Fld395 = @P6)) T5
LEFT OUTER JOIN dbo._Reference85 T9
ON (T5.Fld7290RRef = T9._IDRRef) AND (T9._Fld395 = @P7)
LEFT OUTER JOIN dbo._Reference145 T10
ON (T9._Fld1513RRef = T10._IDRRef) AND (T10._Fld395 = @P8)
LEFT OUTER JOIN dbo._Reference145 T11
ON (T10._ParentIDRRef = T11._IDRRef) AND (T11._Fld395 = @P9)) T4
ON 1=1) T1
LEFT OUTER JOIN dbo._Reference48 T12
ON (T1.Q_001_F_002RRef = T12._IDRRef) AND (T12._Fld395 = @P10)
LEFT OUTER JOIN (SELECT
T16._Fld7289RRef AS Fld7289RRef,
T16._Fld7291RRef AS Fld7291RRef,
T16._Fld7292 AS Fld7292_,
T16._Fld7293 AS Fld7293_,
T16._Fld7290RRef AS Fld7290RRef,
T16._Period AS Period_,
T16._Fld7294_TYPE AS Fld7294_TYPE,
T16._Fld7294_RTRef AS Fld7294_RTRef,
T16._Fld7294_RRRef AS Fld7294_RRRef
FR OM (SELECT
T15._Fld7289RRef AS Fld7289RRef,
T15._Fld7290RRef AS Fld7290RRef,
T15._Fld7291RRef AS Fld7291RRef,
MAX(T15._Period) AS MAXPERIOD_
FR OM dbo._InfoRg7288 T15
WH ERE ((T15._Fld395 = @P11)) AND (T15._Period <= @P12)
GROUP BY T15._Fld7289RRef,
T15._Fld7290RRef,
T15._Fld7291RRef) T14
INNER JOIN dbo._InfoRg7288 T16
ON T14.Fld7289RRef = T16._Fld7289RRef AND T14.Fld7290RRef = T16._Fld7290RRef AND T14.Fld7291RRef = T16._Fld7291RRef AND T14.MAXPERIOD_ = T16._Period
WH ERE (T16._Fld395 = @P13)) T13
ON (((T1.Q_001_F_000RRef = T13.Fld7290RRef) AND (T1.Q_001_F_001RRef = T13.Fld7291RRef)) AND CASE WHEN (T12._Fld821 = 0x00) THEN CASE WHEN (T1.Q_001_F_002RRef = T13.Fld7289RRef) THEN 0x01 WHEN NOT (T1.Q_001_F_002RRef = T13.Fld7289RRef) THEN 0x00 END ELSE CASE WHEN 
(T12._Fld822RRef = T13.Fld7289RRef) THEN 0x01 WHEN NOT (T12._Fld822RRef = T13.Fld7289RRef) THEN 0x00 END END = 0x01)
LEFT OUTER JOIN dbo._Reference85 T17
ON (T1.Q_001_F_000RRef = T17._IDRRef) AND (T17._Fld395 = @P14)
LEFT OUTER JOIN dbo._Reference144 T18
ON (T1.Q_001_F_001RRef = T18._IDRRef) AND (T18._Fld395 = @P15)
WH ERE (T17._Marked = 0x00) AND T13.Fld7293_ = 0x01
ORDER BY (T1.Q_001_F_007_), (T1.Q_001_F_006_), (T17._Description), (T18._Description), (T1.Q_001_F_002RRef)',N'@P1 varbinary(16),@P2 numeric(10),@P3 varbinary(16),@P4 varbinary(16),@P5 numeric(10),@P6 numeric(10),@P7 numeric(10),@P8 numeric(10),@P9 numeric(10),@P10 numeric(10),@P11 numeric(10),@P12 datetime2(3),@P13 numeric(10),@P14 numeric(10),@P15 numeric(10)',0x00000000000000000000000000000000,0,0x00000000000000000000000000000000,0x00000000000000000000000000000000,0,0,0,0,0,0,0,'4018-04-16 00:00:00',0,0,0

Запрос = Новый Запрос;
    Запрос.Текст = "    
    |ВЫБРАТЬ ПЕРВЫЕ 1000
    |    ЦеныНоменклатуры.Регистратор 
    |ИЗ
    |    РегистрСведений.ЦеныНоменклатуры КАК ЦеныНоменклатуры
    | Где Номенклатура в (&ГруппаНоменклатуры)";