Help making 'outline numbers'

[jazerr]

I've got a SP that returns data like this:

Goal
Objective
Objective
Objective
Goal
Objective
Objective
Objective
Objective
Goal
Objective
Objective


Each objective is related to the goal above it in the recordset. What I need to return is:
Goal 1
Objective 1.1
Objective 1.2
Objective 1.3
Goal 2
Objective 2.1
Objective 2.2
Objective 2.3
Objective 2.4
Goal 3
Objective 3.1
Objective 3.2

Basically I need the outline numbers.

Any thoughts on how I might do this?

 

[donutman]

You can adapt the following to your situation. "How to add sequence number within groups of repeating values faq183-5021." You'll have to decide what comes after the 9th Objective.
-Karl

[red] Cursors, Triggers and User Definded Functions are part of the Axis of Evil![/red]