Posted by Jason Kester on 08/10/06 14:16

Dip wrote:
> Hi Expert,
> How do I flatten a Parent Child hierarchy to regular flat data: please
> provide some SQL code:
>
> I want to have:
>
> Level1 Level2 Level3
> Project Management Costing Task1
> Project Management Costing Task2
> Project Management Estimating Task3
> Project Management Estimating Task4
>


Sounds pretty straightforward, joining the table into itself as many
times as you need to get the depth you want. What have you tried so
far, and what is the specific issue you're coming up against?


Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

---
Get your own Travel Blog, with itinerary maps and photos!
http://www.blogabond.com/

• Next in forum: Re: Database design question
• Prev in forum: Re: How to switch off automatic blanking of table views in enterprise manager ?
• Thread view: Re: Flattening Parent Child Hierarchy: Urgent please help

[Reply to this message]