Unfortunately the date is along for the ride in this case. Normally the MatterNum and Date are the important information to the auditors, however in this case we want all data for a set of MatterNum. Of course this is driven off another table which has the client.

Scott, I will look into doing as you suggest. How long should the copy of data take? Notice despite my requests we have limited resources on the machines. It is the old "we can save money", which is followed by "why is the system so slow?".

Thanks for the information.

P.S. a rebuild of the index I originally tried to build finished in under 9 minutes.