First order of business is to understand what kind of business process you want to have surrounding that kind of issue.  Last one in wins can be painful, as you've...

Just to add some specific content to this thread, here's some things SQL 2000 can NOT use:

1.) ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD, LAG, or any aggregate where you add...

As long as we're at it, we might as well correct what appears to be a slight typo, and perhaps simplify some of the code:CREATE PROCEDURE dbo.getDashboard (
...