SELECT cast(cast( Cast([date_tt] as datetime)-datepart(weekday, Cast([date_tt] as datetime))+1 as date)as datetime) as Period,
	DTT.id_tt
	,DTT.id_tov
	,SUM([post]) post
	,SUM([digust]) digust
	,SUM(([spisanie] + [spisanie_dost])*[price]) spisanie
	,SUM([spisanie_kach]*[price]) spisanie_kach
	,SUM([boi]) boi
	,SUM([akcia]) akcia
	,SUM([razniza]) razniza
	,SUM([razniza]) raznizaRaschet
	,SUM([summa]) summa
	,SUM([quantity]) rashod
 	,SUM([quantity]) rashodKKM
	,SUM([vozvrat_pok]) vozvrat_pok
	,SUM([peremPlus]) polucheno
	,SUM([peremMinus]) peremesheno
	,SUM([complect]) complect
	,SUM([discount50]) discount50
	,Avg([price]) price
FROM [vv03].[dbo].[DTT] DTT (nolock) 

where date_tt >= '2017-11-13' and date_tt <= '2017-12-10'
			
GROUP BY 
	 DTT.id_tt, DTT.id_tov , cast(cast( Cast([date_tt] as datetime)-datepart(weekday, Cast([date_tt] as datetime))+1 as date)as datetime)