Код

select top 100
SUM(T1.sp16028) as флНайденТранспорт,
SUM(T1.sp15650) as СуммаСНДС,
SUM(T1.sp15893) as флЭкспорт,
SUM(T1.sp15894) as КурсВал,
SUM(T1.sp15990) as Отсрочка,
SUM(T1.sp16155) as СуммарныйВес,
SUM(T1.sp15645) as СуммаБезСкидки,
SUM(T1.sp15646) as Скидка,
SUM(T1.sp15647) as НДС,
SUM(T1.sp15896) as СуммаБезНДС,
SUM(T1.sp16041) as СуммаГрнСНДС,
SUM(T1.sp16280) as флОплатаУслуг
from uai_cb.dbo.dh15608 AS T1 (NOLOCK)
	INNER JOIN uai_cb.dbo.CRM_ЗаявкаДок As TabView (NOLOCK) ON (TabView.IDDOC = T1.IDDOC)
	INNER JOIN uai_cb.dbo._1SJOURN As TabJ (NOLOCK) ON (TabJ.IDDOC = T1.IDDOC)
	INNER JOIN uai_cb.dbo.ВидыДокументов AS TabV ON (TabV.IDDOCDEF = TabJ.IDDOCDEF)
where 1 = 1
	AND (TabJ.IDDOCDEF = 15608)
order by