;
;With DT_Temp as

(

    Select SalesID, Sum(Weight) as Weight

    From @DetailSales

    Group By SalesID

)

Select SUM(HS.AllPrice) Price, SUM(DS.Weight) Vazn

From

        @HeaderSales HS INNER JOIN DT_Temp DS

ON

        HS.SaleID = DS.SalesID