>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

I hope it is. We haven't yet switched, although we're planning for some clients.