Posted by Kart on 08/09/06 09:47

Look at "Expanding Hierarchies" in SQL Server 2000 BOL. I think that
should help

Dip wrote:
> Hello Expert,
> Here I am asking your help.
> I have a table with following data:
> TaskID ParentTaskID TaskName ProjectName
> 1 1 BA Rail
> 2 22 FA Financial
> 3 1 BA.1 Rail
> 4 1 BA.2 Rail
> 5 22 FA.1 Financial
> 6 22 FA.2 Financial
>
> Now I want the following format:
>
> ID ParentID Name
> 1 1 Rail
> 2 1 BA
> 3 2 BA.1
> 4 2 BA.2
> 5 22 Financial
> 6 5 FA.1
> 7 5 FA.2
>
> I need to create following hierarchy if I could tranform the data the
> above way in the Project Dimension:
> Rail
> --BA
> ----BA.1
> ----BA.2
> Financial
> --FA
> ----FA.1
> ----FA.2
> Please help and thanks in advance,
> Soumya

• Next in forum: Re: How to restrict evil create scripts?
• Prev in forum: SQL Challenge Urgent, Please help
• Thread view: Re: SQL Challenge Urgent, Please help

[Reply to this message]