• The thing is, I am almost certain that you are mistaken in thinking that you get a resultset as the output from DBCC SHOW_STATISTICS (<table>, <index>).

    If you take a closer look at the results it returns it actually resembles 3 separate resultsets.

    quote:


    if you issue a DBCC SHOW_STATISTICS (<table>, <index>)

    you will get a resultset with the density.


    You may be able to do what you want through DTS.

    Nigel Moore
    ======================