Subject Re: [firebird-support] CTE recursive WITH error
Author Vlad Khorsun
> I use firebird 2.1 with Xp sp2.
> I have a simple table (tree) with 3 columns "Id","father" and "Description".
> The table is autoreference.
> I would like to use the WITH for CTE recursive, but I have this error:
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> CTE 'RIC' has cyclic dependencies.
> I have try to execute the all SQL Code WITH in SQL Server 2005 and
> work successfully.

MS SQL Server not requires RECURSIVE keyword and violate SQL standard.

Use WITH RECURSIVE for recursive queries.