And I should mention: we're stuck with SQL 2000 due to an ancient dinosaur of a 3rd party program the company is locked into and depends on for some of the business. That makes doing pivot tables an enormous pain.