[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