Using SQL Server 2000 will make things more difficult. You don't have access to the windowing function row_number() for one.

I will think if I can come up with another possible answer.