You should post this question in the 2000 forum because you may start getting 2005 solutions to the problem that will not work in 2000. For example, I think I could make this work with a Common Table Expression, but you won't be able to run that in your SQL Server 2000 system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning