Here is the Data Defination and Data and how the tree should look like. What format the stored procedure should give the output data so it can be used in TreeView in stored Procedure ?

CREATE TABLE CO( Module nvarchar(20), KeyValue nvarchar(100), KeyLine int, RefModule nvarchar(20), RefValue nvarchar(100), RefLine int)

CREATE TABLE COLine( Module nvarchar(20), KeyValue nvarchar(100), KeyLine int, RefModule nvarchar(20), RefValue nvarchar(100), RefLine int)

CREATE TABLE Job( Module nvarchar(20), KeyValue nvarchar(100), KeyLine int, RefModule nvarchar(20), RefValue nvarchar(100), RefLine int)

CREATE TABLE Lot( Module nvarchar(20), KeyValue nvarchar(100), KeyLine int, RefModule nvarchar(20), RefValue nvarchar(100), RefLine int)

CREATE TABLE POLine( Module nvarchar(20), KeyValue nvarchar(100), KeyLine int, RefModule nvarchar(20), RefValue nvarchar(100), RefLine int)

insert into CO values ( 'CO', 'KB11-02916' , 0, null , null , null)

insert into COLine values ( 'COLine', 'KB11-02916' , 1, 'CO' , 'KB11-02916' , 0)

insert into Job values ( 'Job', 'J000503035' , 0, 'COLine' , 'KB11-02916' , 1)

insert into Job values ( 'Job', 'J000503035' , 1, 'Job' , 'J000503035' , 0)

insert into Lot values ( 'Lot', 'LOTJ5030350000' , 0, 'Job' , 'J000503035' , 1)

insert into POLine values ( 'POLine', 'PH00022127' , 1, 'Job' , 'J000503035' , 1)

insert into POLine values ( 'POLine', 'PH00022127' , 2, 'Job' , 'J000503035' , 1)

insert into Job values ( 'Job', 'J000503035' , 3, 'Job' , 'J000503035' , 1)

insert into POLine values ( 'POLine', 'PH00022137' , 1, 'Job' , 'J000503035' , 3)

insert into POLine values ( 'POLine', 'PH00022137' , 2, 'Job' , 'J000503035' , 3)

insert into LOT values ( 'LOT', 'PHL13938' , 0, 'POLine' , 'PH00022127' , 1)

insert into LOT values ( 'LOT', 'PHL13939' , 0, 'POLine' , 'PH00022127' , 1)

insert into LOT values ( 'LOT', 'PHL13940' , 0, 'POLine' , 'PH00022127' , 2)

insert into LOT values ( 'LOT', 'PHL13941' , 0, 'POLine' , 'PH00022127' , 2)

insert into LOT values ( 'LOT', 'PHL13100' , 0, 'POLine' , 'PH00022137' , 1)

insert into LOT values ( 'LOT', 'PHL13101' , 0, 'POLine' , 'PH00022137' , 1)

insert into LOT values ( 'LOT', 'PHL13102' , 0, 'POLine' , 'PH00022137' , 2)

Here how the tree should look like

CO KB11-02916

-COLine KB11-02916-1

--Job J000503035-0

---Job J000503035-1

----Lot LOTJ5030350000-0

----POLine PH00022127-1

-----Lot PHL13938-0

-----Lot PHL13939-0

----POLine PH00022127-2

-----Lot PHL13940-0

-----Lot PHL13941-0

----Job J000503035-3

-----POLine PH00022137-1

------Lot PHL13100-0

------Lot PHL13101-0

-----POLine PH00022137-2

------Lot PHL13102-0

------Lot PHL13103-0