Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Connect by prior does it determine hierachical q??

Author  Topic  Dek Starting Member 7 Posts Posted - 2001-11-15 : 21:20:55 I am trying to determine if a set off SQL output I have has been generated by Hierarchical Queries. I can see from output in front of me an immediate ordering by salary. My question is could this be classified as hierarchical query? Given text I have read: CONNECT BY PRIOR: specifies parent-child rel. ... this clause is required for a hierarchical query. Generally speaking I would say yes because there is a hierarchical relationship in the sense of salary but would SQL classify this as so in the light of information I have read? Can a hierachical query in it's strictest sense