Subject | Limit recursion in CTE |
---|---|
Author | Jiri Cincura |
Post date | 2008-08-13T18:43:34Z |
Hello *,
is there any way how to limit recursion when using CTE. Something like
select * from MyCTE
OPTION (MAXRECURSION 3)
that's in MSSQL.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
is there any way how to limit recursion when using CTE. Something like
select * from MyCTE
OPTION (MAXRECURSION 3)
that's in MSSQL.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com