Subject Recursive selectable stored procedures
Author Fulvio Senore
Hello to everybody.

I have a tree-like "folder structure" table, and each folder contains
many rows stored in another table.
Now I need to look for all the rows in a folder and its subfolders that
meet some search criteria.

I would like to use a selectable stored procedure to return the matching
rows, but this structure requires a recursive procedure to travel the

Here is the question: is it possible to have a recursive selectable
stored procedure? In case it is possible, is there an example somewhere?

Thanks in advance.

Fulvio Senore