Home Forums SQL Server 2005 T-SQL (SS2K5) All INDEX details query - gives duplicate entires RE: All INDEX details query - gives duplicate entires

  • There are columns with different data, in my results:

    user_seeks, user_scans, user_lookups, and user_updates

    If you don't want the values you listed to repeat, you need to either exclude the above columns or group by the columns you don't want to repeat and use an aggregate function (MAX(), MIN(), etc.) of the others.