>>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.
If it's not broken, fix it until it is.
My Blog