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

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

Get a copy of TREES & HIERARCHIES IN SQL for several diffrent ways to
model this kind of problem.