>>Not a definitive answer but I found these two links useful:
>>http://msdn.microsoft.com/en-us/library/ee336250.aspx
>>http://msdn.microsoft.com/en-us/library/ff394115.aspx
>
>I found this ...
>
>http://msdn.microsoft.com/en-us/library/ee336270.aspx
>
>... which mentions that WITH common_table_expression is supported. And hopefully that means all of it, not just some of it. So, perhaps that should be a definitive answer. Who knows ...

At least that's the way I'd read it.....

>>But we are finding lots of cases where scripts generated for SQL2008 won't (without tweaking) work for SQL Azure.
>
>Yes, we found that too. I don't usually rely on generated scripts and end up tweaking them anyway, so a few more tweaks to make them Azure compatible is par for the course. <g>

Still annoying tho'......
And doing the same all over again if you to run against CE :-{