Hi,
Does anyone know if SQL Server has an equivalent to Oracle's 'hierarchical
queries'?
Oracle Example:
select emp_id, mgr_emp_id
from persons
start with emp_id = 123456
connect by prior_emp_id = mgr_emp_id
Looking for a way to do this in SQL Server.
Thanks!
Levi
=====
Levi Taylor
<cf_coldfusion_developer>
http://www.esoftsolutions.com
__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
