select WorkingTT.CodeTT, Calendar.w, Calendar.y
from (
select 
	....) as WorkingTT
FULL JOIN
		(select 
				week as w,
				year as y 
			from tableofdate(cast('2000-01-01' as date), GETDATE())) as Calendar ON 1=1

select 
	cast(spr_tt._Code as varchar(50)) as CodeTT
	from _Reference15221 AS spr_tt 
	LEFT JOIN (
		SELECT
			REPLACE(ISNULL(t6._Description, ''), '"', '') AS [Торговая точка],
			ISNULL(t6._Fld16238, '') AS [Название торговой точки], 
			ISNULL(t6._Code, '') AS КодТТ,
			sum(t1._Fld14422) AS Сумма 
		FROM           
			dbo._AccumRg14411 AS t1 LEFT OUTER JOIN
			dbo._Reference93 AS t2 ON t1._Fld14412RRef = t2._IDRRef LEFT OUTER JOIN
			dbo._Document327 AS t3 ON t1._Fld14416_RRRef = t3._IDRRef LEFT OUTER JOIN
			dbo._Reference75 AS t4 ON t1._Fld14420RRef = t4._IDRRef LEFT OUTER JOIN
			dbo._Reference54 AS t5 ON t1._Fld14415RRef = t5._IDRRef LEFT OUTER JOIN
			dbo._Reference15221 AS t6 ON t5._Fld15516RRef = t6._IDRRef
		GROUP BY
			REPLACE(ISNULL(t6._Description, ''), '"', ''),
			ISNULL(t6._Fld16238, ''), 
			ISNULL(t6._Code, '')) AS WorkingTT ON (WorkingTT.КодТТ = spr_tt._Code) 
		where WorkingTT.Сумма IS NOT NULL