>>>Oh, one more question about CTE. Do you know if CTE is fully supported in SQL Azure? I already Googled and it seems that it is, but I didn't find that many posts about it. We're not currently using SQL Azure, and I don't anticipate that we will be in the near future, but we've tried to make our schema, scripts and procs at least compatible with SQL Azure, just in case ...
>>>
>>>~~Bonnie
>>
>>Hi,
>>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
>>
>>But we are finding lots of cases where scripts generated for SQL2008 won't (without tweaking) work for SQL Azure.
>
>Both links don't mention CTE.

But if are *not* mentioned in the second link then, by implication, they *are* supported :-}