Код

select  sp408,sp411,max(_1sjourn.date_time_iddoc)  from ra405
inner join _1sjourn on _1sjourn.iddoc = ra405.iddoc
where debkred = 0
group by sp408,sp411
 

Код

	|(SELECT ТOP 1
	|    $РегПТ.Товар [Товар $Справочник.Номенклатура]
	|   ,$РегПТ.ОстатокТовара  as КолПрихода
	|   ,JOURN.date_time_iddoc as ДатаПрихода
	|FROM  $Регистр.ПартииТоваров as РегПТ (nolock)
	|INNER JOIN
	|    _1sjourn JOURN(nolock) ON (РегПТ.IDDOC = JOURN.iddoc AND JOURN.date_time_iddoc >= :ГодНазад AND JOURN.date_time_iddoc <= :ДатаКон~)
	|WHERE (РегПТ.debkred = 0) AND ($РегПТ.Товар  in "+ТекстТовара+") and ($РегПТ.Фирма = $ПустойИд)
	|ORDER BY JOURN.date_time_iddoc DESC)";
 

Код

select  sp408 as Товар
			 , ra405.iddoc  as Документ
			 ,sum(sp411) as Количество
			 ,max(_1sjourn.date_time_iddoc) as ДатаВремяДок
from ra405
inner join _1sjourn on _1sjourn.iddoc = ra405.iddoc
where debkred = 0
group by sp408,ra405.iddoc 

Код

	ТекстПрихода = "
//	|SELECT ТOP 1
	|SELECT
	|    РегПТ.IDDOC
	|   ,CAST(LEFT(JOURN.Date_Time_IDDoc, 8) as DateTime) as ДатаДок
	|   ,SUM($РегПТ.ОстатокТовара)  as КолПрихода
	|FROM  $Регистр.ПартииТоваров as РегПТ (nolock)
	|LEFT JOIN
	|    _1sjourn JOURN(nolock) ON (РегПТ.IDDOC = JOURN.iddoc)
	|WHERE (РегПТ.debkred = 0) AND ($РегПТ.Товар  in "+ТекстТовара+") and ($РегПТ.Фирма = $ПустойИд)
	|GROUP BY РегПТ.IDDOC,CAST(LEFT(JOURN.Date_Time_IDDoc, 8) as DateTime)
	|ORDER BY CAST(LEFT(JOURN.Date_Time_IDDoc, 8) as DateTime) DESC
	|";
 

Код

select sq.t [товар $справочник.товары]
	, $началопериода.день(sq.d) дата
	, sum($ra.количество) количество
from $регистр.остатки ra (nolock)
	inner join _1sjourn jr (nolock) on ra.iddoc = jr.iddoc
	inner join (
		select $ra.Товар t
			, max(jr.date_time_iddoc) d
		from $регистр.остатки ra (nolock)
			inner join _1sjourn jr (nolock) on ra.iddoc = jr.iddoc
		where $ra.Товар in (select val from #сптовары)
			and ra.debkred = 0
	) sq on $ra.Товар = sq.t and jr.date_time_iddoc = sq.d
group by sq.t
	, sq.d