Hi,

>>Does anyone know whether SQL Compact Edition supports Common Table Expressions?
>>
>>TIA,
>>Viv
>
>In my quick search I didn't find an answer on this question, but I found a special forum for this http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1 and a very interesting article http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-common-table-expressions/
>
>Sorry for not being helpful.

Thanks. The second link is certainly helpful.
I've been playing with CTE and recursion in SQL Express and didn't know that multiple recursive members were allowed (but I'm not sure my head is ready for it :-})
Best,
Viv