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