SQL Challenge Urgent, Please help

Giganews Newsgroups
Subject: SQL Challenge Urgent, Please help
Posted by:  Dip (soumyadip.bhattachar…@gmail.com)
Date: 9 Aug 2006

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

Replies