Can you clarify your requirements again and which DB you want them? I don't know what this recursive CTE was supposed to do.
>yes , i use VFP ....
>
>if i change to 2005 SQL Server and use CTE.
>it display error...
>Msg 530, Level 16, State 1, Line 1
>The statement terminated. The maximum recursion 100 has been exhausted before statement completion.
>
>How can i do, thank you ~~~
>
>
>WITH Tests(tid, tname, counts) AS
>(
> SELECT sysid, sysName, 0 AS counts
> FROM syslib
> UNION ALL
> SELECT sysid, sysName, counts + 1
> FROM syslib I
> JOIN Tests T ON
> T.tid = I.sysid
>)
>SELECT sysid, sysName, T.counts
> FROM syslib I
> JOIN Tests T ON
> T.tid = I.sysid
>
>
If it's not broken, fix it until it is.
My Blog