• I don't think they are off by that much, especially given the DISTINCT. How many total rows in the table? Did you check dbcc showstatistics to see how the numbers looked for the period? Is this discrepancy causing some problem?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service