i need to make a query where i have to display all names of a category
heirarchically.
C1-->C2-->C3-->C4
where C1 is the top level category
it shud b displayed as C1/C2/C3/C4
Also there can b any no of category levels.
pls anybody help me
manuUse Order By Fielda, FieldB, FieldC.
manu_ashok@.yahoo.com (Manu Ashok) wrote in message news:<54b28501.0404120702.60317431@.posting.google.com>...
> pls anybody help me with this.
> i need to make a query where i have to display all names of a category
> heirarchically.
> C1-->C2-->C3-->C4
> where C1 is the top level category
> it shud b displayed as C1/C2/C3/C4
> Also there can b any no of category levels.
> pls anybody help me
> manu|||dear rowan
abt that heirarchical query, the no of levels are not known. also the
table has name & immediate parent id in it.
pls do help me.
how do i use order by when i do not know the levels.
i'm a newbie to sql & asp
manu
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Use Order By Fielda, FieldB, FieldC.
manu_ashok@.yahoo.com (Manu Ashok) wrote in message news:<54b28501.0404120702.60317431@.posting.google.com>...
> pls anybody help me with this.
> i need to make a query where i have to display all names of a category
> heirarchically.
> C1-->C2-->C3-->C4
> where C1 is the top level category
> it shud b displayed as C1/C2/C3/C4
> Also there can b any no of category levels.
> pls anybody help me
> manu|||What are the fields in your table and what do you want the output to look like?
Manu Ashok <manu_ashok@.yahoo.com> wrote in message news:<407cd063$0$202$75868355@.news.frii.net>...
> dear rowan
> abt that heirarchical query, the no of levels are not known. also the
> table has name & immediate parent id in it.
> pls do help me.
> how do i use order by when i do not know the levels.
> i'm a newbie to sql & asp
> manu
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||dear rowan
abt that heirarchical query, the no of levels are not known. also the
table has name & immediate parent id in it.
pls do help me.
how do i use order by when i do not know the levels.
i'm a newbie to sql & asp
manu
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What are the fields in your table and what do you want the output to look like?
Manu Ashok <manu_ashok@.yahoo.com> wrote in message news:<407cd063$0$202$75868355@.news.frii.net>...
> dear rowan
> abt that heirarchical query, the no of levels are not known. also the
> table has name & immediate parent id in it.
> pls do help me.
> how do i use order by when i do not know the levels.
> i'm a newbie to sql & asp
> manu
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Dear
Please visit following url:
http://www.winnetmag.com/SQLServer/...threadid=116492
May be it will help you
Regards
Saghir Taj
MCDBA
phantomtoe@.yahoo.com (Rowan) wrote in message news:<4bbf8d70.0404141504.30aa2a95@.posting.google.com>...
> What are the fields in your table and what do you want the output to look like?
> Manu Ashok <manu_ashok@.yahoo.com> wrote in message news:<407cd063$0$202$75868355@.news.frii.net>...
> > dear rowan
> > abt that heirarchical query, the no of levels are not known. also the
> > table has name & immediate parent id in it.
> > pls do help me.
> > how do i use order by when i do not know the levels.
> > i'm a newbie to sql & asp
> > manu
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!|||Dear
Please visit following url:
http://www.winnetmag.com/SQLServer/...threadid=116492
May be it will help you
Regards
Saghir Taj
MCDBA
phantomtoe@.yahoo.com (Rowan) wrote in message news:<4bbf8d70.0404141504.30aa2a95@.posting.google.com>...
> What are the fields in your table and what do you want the output to look like?
> Manu Ashok <manu_ashok@.yahoo.com> wrote in message news:<407cd063$0$202$75868355@.news.frii.net>...
> > dear rowan
> > abt that heirarchical query, the no of levels are not known. also the
> > table has name & immediate parent id in it.
> > pls do help me.
> > how do i use order by when i do not know the levels.
> > i'm a newbie to sql & asp
> > manu
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
No comments:
Post a Comment