Having not looked into SQL Server 2000, does anyone know if they've added
this kind of functionality yet?
If not, that's a major oversight in my opinion. Even though there are
efficient ways to handle parent/child relationships, the ID/ParentID is used
a ton. The CONNECT BY PRIOR is definite a sweet feature of Oracle and I was
hoping MS would do something to add similar functionality to SQL Server
2000...
-Dan
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 11:47 AM
To: CF-Talk
Subject: RE: tree structure
Probably not helpful, but if you happen to be using Oracle,
you can retrieve hierarchical data using the rather bizarre
CONNECT BY PRIOR construct.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
