SET NOCOUNT ON
DECLARE @StatsToUpdate TABLE ( StatName NVARCHAR(MAX) )
DECLARE @StatUpdating NVARCHAR(MAX)

INSERT  INTO @StatsToUpdate
        ( StatName 
        )
        SELECT  'UPDATE STATISTICS dbo.' + OBJECT_NAME + ' ' + index_name
        FROM    ( SELECT TOP 1
                            OBJECT_NAME(A.object_id) AS Object_Name ,
                            A.name AS index_name ,
                            STATS_DATE(A.OBJECT_ID, index_id) AS StatsUpdated ,
                            DATEDIFF(d, STATS_DATE(A.OBJECT_ID, index_id),
                                     GETDATE()) DaysOld
                  FROM      sys.indexes A
                            INNER JOIN sys.tables B ON A.object_id = B.object_id
                  WHERE     A.name IS NOT NULL
                            AND DATEDIFF(d, STATS_DATE(A.OBJECT_ID, index_id),
                                         GETDATE()) >= 0
                ) StatsThatAreTooOld

WHILE ( SELECT  COUNT(*)
        FROM    @StatsToUpdate
      ) > 0 
    BEGIN
        SET @StatUpdating = ( SELECT TOP 1
                                        statname
                              FROM      @StatsToUpdate
                            )
        EXECUTE sp_executesql @StatUpdating 
        PRINT 'Done ' + @StatUpdating
        DELETE  FROM @StatsToUpdate
        WHERE   StatName = @StatUpdating
    END

select o.object_id,o.name,s.stats_id,s.name
from sys.objects o
	inner join sys.stats s on o.object_id = s.object_id
where o.type = 'U'
and stats_date(o.object_id,s.stats_id) <= getdate()-20
order by o.object_id,s.stats_id