Posted by Dave Owen on 12/05/05 02:31

Frank --
As I read your question you are interested in expanding hierarchies. See
the article at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_5yk3.asp
(those aren't spaces; they're underscores) to see if this provides a
template.
There is another, similar, example that indents data for an organization's
employee list starting on Page 699 of Kalen Delaney's "Inside Microsoft SQL
Server 7.0" amd I presume in her next edition.
I hope this helps.
-- Dave

"Frank" <nospam@noreply.com> wrote in message
news:e977p1tn2inj0mbi82bvmbjeva7bbncku4@4ax.com...
>I have a table with the following structure:
> main_category| category| sub_category| answer|date
> Basically, the data will be along these lines:
> Neuro | LOC | Status | answer1|date
> Neuro | LOC | Status | answer2|date
> Neuro | LOC | Status | answer3|date
> Senso| Visi | Clarity | answer1|date
> Senso| Visi | Clarity | answer2|date
> etc...
> I am trying to query the db and present the user with the data in the
> following structure:
>
> Main Category
> Category
> Sub Category
> answer1
> answer2
> answer3
> ...
>
> Main Category
> Category
> Etc...
>
> There are literally 3 dozen main categories, categories, and
> sub-categories each with distinct answers.
> I could really use some help on a query to group the data in this way!
>
> Thanks in advance!!!
>
>
> Frank

[Back to original message]