A couple dumb questions:

1) Is there a RETAIL_YEAR column in your A_SALES_DAILY_FACT table? (I can't imagine why there wouldn't be if you just upgraded the DW db from 2000 to 2005 -- I told you it is a dumb question)

2) Does the SELECT work in SSMS against your DW db? (also try it without the double quotes, does that work?)

HTH,

Rob