>>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.