Criação de statisticas via CTE

WITH CTE_COLS AS (
SELECT OBJECT_ID , STATS_ID,
       STUFF(
              (
			     SELECT ',' + CAST(C.name AS VARCHAR(20))
				 FROM SYS.stats_columns SC2
				 inner join sys.columns c on C.object_id= Sc2.object_id AND sc2.column_id=C.column_id
				 inner join sys.types t on t.user_type_id = c.user_type_id and t.system_type_id = c.system_type_id
				 WHERE SC2.object_id = SC1.object_id
				 AND SC2.stats_id = SC1.stats_id
				 and c.collation_name <> 'latin1_general_CI_AS'
				 and t.name in ('varchar','nvarchar','char','text','ntext')
			     FOR XML PATH ('')
			   ), 1, 1, ''
             ) AS COLS
FROM SYS.stats_columns SC1
GROUP BY object_id, stats_id
)
SELECT conmando='CREATE STATISTICS ' + S.NAME +' ON '+ O.NAME + ' ('+ CTE.COLS + ') )' + char(10) + 'GO' 
FROM SYS.objects O
JOIN SYS.stats S
ON O.object_id = S.object_id
JOIN CTE_COLS CTE
ON CTE.object_id = S.object_id
AND CTE.stats_id = S.stats_id
where s.user_created = 1 and s.auto_created = 0
and o.is_ms_shipped = 0
ORDER BY 1