>I found that if I comment the line
AND ABS((HP2.Price / HP1.Price) - 1) > .5 , the query takes 13 seconds.
What does ShowPlan produce? I betting that a Table Scan. I can't give an exact reason why it runs faster on 2000 w/o the ShowPlan. I guess that it's just improvements to the optimizer and engine.
-Mike