[thelist] Recursive Queries

Rob Smith rob.smith at lexjet.com
Wed Mar 8 16:08:00 CST 2006


>With no information provided whatsoever about
>your database or path structure?

I didn't know that mattered. I'm in an SQL 2000/2005 environment. The
"path structure" as you say is an a-typical recursive menu structure.

Row_id	Name		Parent_ID
1		test		1
2		sub1		1
3		sub2		1
4		1sub1		2
5		2sub1		2
Etc.


Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)





More information about the thelist mailing list