ATTN SQL Gurus: Data Roll Up

[Rich_Willmore]

The data: Department Name Sales Rich Marketing Tom Marketing Dave
Sales Gary The intended result Department Name Sales Rich<br>Gary
Marketing Tom<br>Dave This can be down with some looping, structures, and
arrays. It just does not seem very elegant to loop through the data more than
once. Is there a SQL statement that can give me the intended results above?
Some sort of Aggregate (sp?) function? We are using Oracle 8.1.7.4 -- Rich

[OldCFer]

It's pretty simple with cfoutput.

Select department, name from xxx order by department, name

<cfoutput query="yourquery" group="department">
#department#
<cfoutput>
#Name#
</cfoutput>
</cfoutput>

[Rich_Willmore]

You are very much correct. I keep forgetting about that attribute in CFOUTPUT.
Nesting CFOUTPUTs in any fashion just doesn't strike a cord with me I suppose.
Thanks for the reply. A friend of mine did offer a SQL server solution but it
was very 'loopy'. Too much work for something that can be accomplished with
cfoutput grouping. -- Rich

[Rich_Willmore]

*continuing to eat my shoe*. +1 for the GROUP attribute on CFOUTPUT. The code is so much cleaner and faster now.

-- Rich