ВЫБРАТЬ
	ПоступлениеТоваров.Ссылка КАК Документ,
	ПоступлениеТоваров.НомерСчетаФактуры,
	ПоступлениеТоваров.ДатаСчетаФактуры,
	ПоступлениеТоваров.Контрагент,
	ВложенныйЗапрос.СуммаВсего
ИЗ
Документ.ПоступлениеТоваров КАК ПоступлениеТоваров
ЛЕВОЕ СОЕДИНЕНИЕ
	(ВЫБРАТЬ
                      ПоступлениеТоваровТовары.Ссылка,
		СУММА(ПоступлениеТоваров.Товары.СуммаВсего) КАК СуммаВсего
	ИЗ
		Документ.ПоступлениеТоваров.Товары КАК ПоступлениеТоваровТовары
           СГРУППИРОВАТЬ ПО ПоступлениеТоваровТовары.Ссылка
	) КАК ВложенныйЗапрос 
ПО ПоступлениеТоваров.Ссылка = ВложенныйЗапрос.Ссылка
	
ГДЕ
	ПоступлениеТоваров.Ссылка В(&мДок)
	И ПоступлениеТоваров.КодСчетФактурыАльфа =  0 

INSERT INTO #tt1
(f_2, f_3)
SELECT
_Document257_Q_000_T_001._IDRRef AS f_2,
_Document257_Q_000_T_001._Fld4369RRef AS f_3
FROM
_Document257 _Document257_Q_000_T_001 WITH(NOLOCK)

SELECT
f_2,
f_3,
f_1+ 0 
FROM #tt1 WITH(NOLOCK)

SELECT
CAST(SUM(_Document257_VT4389._Fld4401) AS NUMERIC( 21 , 2 )) AS f_4,
0x00000000 AS _KeyField,
f_1 AS f_1
FROM
#tt1 WITH(NOLOCK)
INNER JOIN _Document257_VT4389 WITH(NOLOCK)
ON f_2 = _Document257_VT4389._Document257_IDRRef
GROUP BY
f_1

TRUNCATE TABLE #tt1

SELECT
_Document257_VT4389_Q_000_T_001._Document257_IDRRef AS f_1,
_Document257_1._Fld4369RRef AS f_2,
CAST(SUM(_Document257_VT4389_Q_000_T_001._Fld4401) AS NUMERIC( 21 , 2 )) AS f_3
FROM
_Document257_VT4389 _Document257_VT4389_Q_000_T_001 WITH(NOLOCK)
LEFT OUTER JOIN _Document257 _Document257_1 WITH(NOLOCK)
ON _Document257_VT4389_Q_000_T_001._Document257_IDRRef = _Document257_1._IDRRef
GROUP BY
_Document257_VT4389_Q_000_T_001._Document257_IDRRef,
_Document257_1._Fld4369RRef

GROUP BY
_Document257_VT4389_Q_000_T_001._Document257_IDRRef,
_Document257_1._Fld4369RRef

SELECT
_Document257_Q_000_T_001._IDRRef AS f_1,
_Document257_Q_000_T_001._Fld4373RRef AS f_2,
#V8TblAli1_Q_000_T_002._Q_001_F_001 AS f_3
FROM
_Document257 _Document257_Q_000_T_001 WITH(NOLOCK)
LEFT OUTER JOIN (
SELECT
_Document257_VT4389_Q_001_T_001._Document257_IDRRef AS _Q_001_F_000RRef,
CAST(SUM(_Document257_VT4389_Q_001_T_001._Fld4401) AS NUMERIC( 21 , 2 )) AS _Q_001_F_001
FROM
_Document257_VT4389 _Document257_VT4389_Q_001_T_001 WITH(NOLOCK)
GROUP BY
_Document257_VT4389_Q_001_T_001._Document257_IDRRef
) #V8TblAli1_Q_000_T_002
ON _Document257_Q_000_T_001._IDRRef = #V8TblAli1_Q_000_T_002._Q_001_F_000RRef

|ВЫБРАТЬ
|	ПоступлениеТоваров.Ссылка КАК Документ,
|	ПоступлениеТоваров.Организация,
|	ПоступлениеТоваров.Ответственный,
|	ПоступлениеТоваров.Контрагент,
|	ВложенныйЗапрос.Сумма
|ИЗ
|Документ.ЗаказПокупателя КАК ПоступлениеТоваров
|ЛЕВОЕ СОЕДИНЕНИЕ
|	(ВЫБРАТЬ
|       ПоступлениеТоваровУслугТовары.Ссылка,
|		СУММА(ПоступлениеТоваровУслугТовары.Сумма) КАК Сумма
|	ИЗ
|		Документ.ЗаказПокупателя.Товары КАК ПоступлениеТоваровУслугТовары
|       СГРУППИРОВАТЬ ПО ПоступлениеТоваровУслугТовары.Ссылка
|	) КАК ВложенныйЗапрос 
|ПО ПоступлениеТоваров.Ссылка = ВложенныйЗапрос.Ссылка
|	

|";

SELECT
_Document257_Q_000_T_001._IDRRef AS f_1,
_Document257_Q_000_T_001._Fld4373RRef AS f_2,
_Document257_Q_000_T_001._Fld4374RRef AS f_3,
_Document257_Q_000_T_001._Fld4369RRef AS f_4,
#V8TblAli1_Q_000_T_002._Q_001_F_001 AS f_5
FROM
_Document257 _Document257_Q_000_T_001 WITH(NOLOCK)
LEFT OUTER JOIN (
SELECT
_Document257_VT4389_Q_001_T_001._Document257_IDRRef AS _Q_001_F_000RRef,
CAST(SUM(_Document257_VT4389_Q_001_T_001._Fld4401) AS NUMERIC( 21 , 2 )) AS _Q_001_F_001
FROM
_Document257_VT4389 _Document257_VT4389_Q_001_T_001 WITH(NOLOCK)
GROUP BY
_Document257_VT4389_Q_001_T_001._Document257_IDRRef
) #V8TblAli1_Q_000_T_002
ON _Document257_Q_000_T_001._IDRRef = #V8TblAli1_Q_000_T_002._Q_001_F_000RRef

  
SELECT _Document257_Q_000_T_001._IDRRef AS f_1, _Document257_Q_000_T_001._Fld4373RRef AS f_2, _Document257_Q_000_T_001._Fld4374RRef AS f_3, _Document257_Q_000_T_001._Fld4369RRef AS f_4, #V8TblAli1_Q_000_T_002._Q_001_F_001 AS f_5 FROM _Document257 _Document257_Q_000_T_001 WITH(NOLOCK) LEFT OUTER JOIN ( SELECT _Document257_VT4389_Q_001_T_001._Document257_IDRRef AS _Q_001_F_000RRef, CAST(SUM(_Document257_VT4389_Q_001_T_001._Fld4401) AS NUMERIC( 21 , 2 )) AS _Q_001_F_001 FROM _Document257_VT4389 _Document257_VT4389_Q_001_T_001 WITH(NOLOCK) GROUP BY _Document257_VT4389_Q_001_T_001._Document257_IDRRef ) #V8TblAli1_Q_000_T_002 ON _Document257_Q_000_T_001._IDRRef = #V8TblAli1_Q_000_T_002._Q_001_F_000RRef
  |--Merge Join(Right Outer Join, MERGE:([_Document257_VT4389_Q_001_T_001].[_Document257_IDRRef])=([_Document257_Q_000_T_001].[_IDRRef]), RESIDUAL:([decima].[dbo].[_Document257].[_IDRRef] as [_Document257_Q_000_T_001].[_IDRRef]=[decima].[dbo].[_Document257_VT4389].[_Document257_IDRRef] as [_Document257_VT4389_Q_001_T_001].[_Document257_IDRRef]))
       |--Compute Scalar(DEFINE:([Expr1006]=CONVERT(numeric(21,2),[Expr1004],0)))
       |    |--Stream Aggregate(GROUP BY:([_Document257_VT4389_Q_001_T_001].[_Document257_IDRRef]) DEFINE:([Expr1004]=SUM([decima].[dbo].[_Document257_VT4389].[_Fld4401] as [_Document257_VT4389_Q_001_T_001].[_Fld4401])))
       |         |--Clustered Index Scan(OBJECT:([decima].[dbo].[_Document257_VT4389].[_Documen257_VT4389_IntKeyInd] AS [_Document257_VT4389_Q_001_T_001]), ORDERED FORWARD)
       |--Clustered Index Scan(OBJECT:([decima].[dbo].[_Document257].[PK___Document257__0A0406BE] AS [_Document257_Q_000_T_001]), ORDERED FORWARD)

|ВЫБРАТЬ
|	ПоступлениеТоваров.Ссылка КАК Документ,
|	ПоступлениеТоваров.Организация,
|	ПоступлениеТоваров.Ответственный,
|	ПоступлениеТоваров.Контрагент,
|	ПоступлениеТоваров.Товары.(
|   СУММА(Сумма) КАК ИтогоСумма
| ) КАК ТЧ
|ИЗ
|Документ.ЗаказПокупателя КАК ПоступлениеТоваров
|	
|";

SELECT TOP  0  CAST(0x AS BINARY( 16 )) f_2,
CAST(0x AS BINARY( 16 )) f_3,
CAST(0x AS BINARY( 16 )) f_4,
CAST(0x AS BINARY( 16 )) f_5,
IDENTITY (INT,  1 ,  1 ) f_1
INTO #tt1

INSERT INTO #tt1
(f_2, f_3, f_4, f_5)
SELECT
_Document257_Q_000_T_001._IDRRef AS f_2,
_Document257_Q_000_T_001._Fld4373RRef AS f_3,
_Document257_Q_000_T_001._Fld4374RRef AS f_4,
_Document257_Q_000_T_001._Fld4369RRef AS f_5
FROM
_Document257 _Document257_Q_000_T_001 WITH(NOLOCK)

SELECT
f_2,
f_3,
f_4,
f_5,
f_1+ 0 
FROM #tt1 WITH(NOLOCK)


SELECT
CAST(SUM(_Document257_VT4389._Fld4401) AS NUMERIC( 21 , 2 )) AS f_6,
0x00000000 AS _KeyField,
f_1 AS f_1
FROM
#tt1 WITH(NOLOCK)
inner JOIN _Document257_VT4389 WITH(NOLOCK)
ON f_2 = _Document257_VT4389._Document257_IDRRef
GROUP BY
f_1

INSERT INTO #tt1 (f_2, f_3, f_4, f_5) SELECT _Document257_Q_000_T_001._IDRRef AS f_2, _Document257_Q_000_T_001._Fld4373RRef AS f_3, _Document257_Q_000_T_001._Fld4374RRef AS f_4, _Document257_Q_000_T_001._Fld4369RRef AS f_5 FROM _Document257 _Document257_Q_000_T_001 WITH(NOLOCK)
  |--Table Insert(OBJECT:([tempdb].[dbo].[#tt1]), SET:([tempdb].[dbo].[#tt1].[f_2] = [decima].[dbo].[_Document257].[_IDRRef] as [_Document257_Q_000_T_001].[_IDRRef],[tempdb].[dbo].[#tt1].[f_3] = [decima].[dbo].[_Document257].[_Fld4373RRef] as [_Document257_Q_000_T_001].[_Fld4373RRef],[tempdb].[dbo].[#tt1].[f_4] = [decima].[dbo].[_Document257].[_Fld4374RRef] as [_Document257_Q_000_T_001].[_Fld4374RRef],[tempdb].[dbo].[#tt1].[f_5] = [decima].[dbo].[_Document257].[_Fld4369RRef] as [_Document257_Q_000_T_001].[_Fld4369RRef],[tempdb].[dbo].[#tt1].[f_1] = [Expr1006]))
       |--Compute Scalar(DEFINE:([Expr1006]=getidentity((85575343),(2),NULL)))
            |--Top(ROWCOUNT est 0)
                 |--Clustered Index Scan(OBJECT:([decima].[dbo].[_Document257].[PK___Document257__0A0406BE] AS [_Document257_Q_000_T_001]))
 SELECT f_2, f_3, f_4, f_5, f_1+ 0  FROM #tt1 WITH(NOLOCK)
  |--Compute Scalar(DEFINE:([Expr1004]=[tempdb].[dbo].[#tt1].[f_1]+(0)))
       |--Table Scan(OBJECT:([tempdb].[dbo].[#tt1]))
 SELECT CAST(SUM(_Document257_VT4389._Fld4401) AS NUMERIC( 21 , 2 )) AS f_6, 0x00000000 AS _KeyField, f_1 AS f_1 FROM #tt1 WITH(NOLOCK) inner JOIN _Document257_VT4389 WITH(NOLOCK) ON f_2 = _Document257_VT4389._Document257_IDRRef GROUP BY f_1
  |--Compute Scalar(DEFINE:([Expr1008]=CONVERT(numeric(21,2),[Expr1007],0), [Expr1009]=0x00000000))
       |--Hash Match(Aggregate, HASH:([tempdb].[dbo].[#tt1].[f_1]) DEFINE:([Expr1007]=SUM([decima].[dbo].[_Document257_VT4389].[_Fld4401])))
            |--Hash Match(Inner Join, HASH:([tempdb].[dbo].[#tt1].[f_2])=([decima].[dbo].[_Document257_VT4389].[_Document257_IDRRef]), RESIDUAL:([decima].[dbo].[_Document257_VT4389].[_Document257_IDRRef]=[tempdb].[dbo].[#tt1].[f_2]))
                 |--Table Scan(OBJECT:([tempdb].[dbo].[#tt1]))
                 |--Clustered Index Scan(OBJECT:([decima].[dbo].[_Document257_VT4389].[_Documen257_VT4389_IntKeyInd]))

SELECT
f_2,
f_3,
f_4,
f_5,
f_1+ 0 
FROM #tt1 WITH(NOLOCK)