Hi,

Statistically speaking, what you're doing doesn't make a lot of sense - when you introduce the group by variables you get an average value for each distinct set of the...

Thanks for your help guys - I'll try out some of your suggestions and see which option works out to be the most efficient.

Cheers,

Frank

Hi Dave,

Yes, that's an elegant solution, however, I'm running this on SQL Server 2000, so...

Frank