• Thanks for responding, and so quickly!

    The 'dense_rank()' and 'over(partition by' bits in the stored procedure are not functions in SQL 2000, and I don't have use of Analysis Services either unfortunately.

    Thanks,


    maddog