SELECT  TA.UNIQ, SA.STOREID, CONVERT(date, SA.DB, 4) AS DOC_DATE, SA.CASHCODE, SA.SHIFT
       ,TA.CHECKNUM, TA.BCODE, TA.ARTICUL
       ,TA.VATRATE1, TA.VATCODE1, va.NAME as VATCODENAME
       ,SUM(TA.VATSUM1 * OP.[SIGN]) AS VATSUM1 
       ,SUM(TA.BQUANT  * OP.[SIGN]) AS QTY_SUM
          ,SUM(TA.BQUANT * TA.PRICE * OP.[SIGN]) AS SUM_1
          ,SUM(TA.SUMB * OP.[SIGN]) AS SUMI
FROM dbo.ACS AS SA 
INNER JOIN  dbo.ACT AS TA 
       ON TA.CSID  = SA.UNIQ
INNER JOIN  dbo.OP AS OP 
       ON TA.OPCODE = OP.OPCODE
LEFT JOIN  dbo.VAT AS VA
       on VA.CODE = TA.VATCODE1
WHERE  (SA.DB >=  CONVERT(date,DATEADD(DAY, -3, getdate())) AND   SA.DB  < CONVERT(date, GETDATE())) 
AND   SA.STOREID > 3
GROUP BY  TA.UNIQ, SA.STOREID, CONVERT(date, SA.DB, 4), SA.CASHCODE, SA.SHIFT
         ,TA.CHECKNUM, TA.BCODE, TA.ARTICUL
         ,TA.VATRATE1, TA.VATCODE1, va.NAME;

DECLARE @DateNow DATETIME
SELECT @DateNow = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL = (
    SELECT '
	UPDATE STATISTICS [' + SCHEMA_NAME(o.[schema_id]) + '].[' + o.name + '] [' + s.name + ']
		WITH FULLSCAN' + CASE WHEN s.no_recompute = 1 THEN ', NORECOMPUTE' ELSE '' END + ';'
	FROM (
		SELECT 
			  [object_id]
			, name
			, stats_id
			, no_recompute
			, last_update = STATS_DATE([object_id], stats_id)
		FROM sys.stats WITH(NOLOCK)
		WHERE auto_created = 0
			AND is_temporary = 0 -- 2012+
	) s
	JOIN sys.objects o WITH(NOLOCK) ON s.[object_id] = o.[object_id]
	JOIN (
		SELECT
			  p.[object_id]
			, p.index_id
			, total_pages = SUM(a.total_pages)
		FROM sys.partitions p WITH(NOLOCK)
		JOIN sys.allocation_units a WITH(NOLOCK) ON p.[partition_id] = a.container_id
		GROUP BY 
			  p.[object_id]
			, p.index_id
	) p ON o.[object_id] = p.[object_id] AND p.index_id = s.stats_id
	WHERE o.[type] IN ('U', 'V')
		AND o.is_ms_shipped = 0
		AND (
			  last_update IS NULL AND p.total_pages > 0 -- never updated and contains rows
			OR
			  last_update <= DATEADD(dd, 
				CASE WHEN p.total_pages > 4096 -- > 4 MB
					THEN -2 -- updated 3 days ago
					ELSE 0 
				END, @DateNow)
		)
    FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)')

PRINT @SQL
--EXEC sys.sp_executesql @SQL