Good Friday to you, Is it possible to get the level as output from a recursive query call? There doesn't appear to be, unless I've not found it, a way by which to retrieve it from the results. The sql trace (on ms sql) provides that the sql is establishing level.
Alternatively a api getlistsql using recursive query doesn't appear to be productive (requires ";" prior to "with", although providing it ends with no results - ever). Appreciate any thoughts on the subject. Kind Regards, Eric CONFIDENTIALITY NOTICE: This email communication is intended only for the personal and confidential use of the recipient(s) designated above and may contain information which is subject to Federal and/or State privacy laws. In the event that you are not the intended recipient or the agent of the intended recipient, you are hereby notified that any review, disclosure, or use of the information contained herein is strictly prohibited. Do not copy or use the information contained within this communication, or allow it to be read, copied or utilized in any manner by any other person(s). If you have received this communication in error, please notify the sender immediately, either by response e-mail or by phone, and permanently delete the original e-mail, any attachment(s), and copies. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"