July 16, 2013 at 9:37 pm
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
July 17, 2013 at 2:21 am
Hi, thanks for the response.
1) yes there is
2) it does the same with or without quotes ie fail the syntax check. It checks ok syntacically if I remove the where clause with or without the quotes. It won't work as a query as there is no join on the table in the where clause. Like I say I assume that's because it's a 'query binding' type so I'm guessing this will only work as a AS partiion not a SQL query.
We have other old partitions that have similar code, so I think there might be something different between the 2000 & 2008 editions that isn't now compatible or needs writing a different way!?
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply