Chris, > Unfortunately, SQL is pretty bad at handling arbitrary-depth menus > (esp. without WITH RECURSIVE or CONNECT BY). Fortunately, the amount > of data is likely to be pretty small, so it is not too bad using > stored procedures.
See connect_by() in tablefunc. Please don't reinvent the wheel. --Josh ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
