Look at the operators precedence if you are using Oracle, the "IN" comes 3 levels before "OR", in SQL Server they are on the same level.

Always run your code first in development enviroment

I was a VB6 programmer. SQL for me was just a "select statements" tool for ADO.Then I took SQL7 certification course and realize how I much more programming...

When you create stored procedure set default values for all parameters ( may be even '%' as default).

Then, when you call it from ADO, create CommandText line like:"exec MyProc "...

You have to include field "PARENT" where you can put ID of the previous Root or subroot or if it's Main root - it's own ID

SET applies to built in function, like:

SET NOCOUNT ON;SET ROWCOUNT 4 etc.

For SET/SELECT in other cases - SELECT is more useful ( you can't use SET in many cases) so...