Hi,

Thanks for the response.

I tried creating a NC index on empid, it did helped in reducing the reads and scans but for column related thing (retrieval of N columns , as...

Yes , i agree.

1 Rough Purchase 0

2 Purchase Req.   1

4 Edit                 2

For your Reference consider the Label Edit with ID 4 and its parent id is 2

that means Purchase Req. which has...

hi,

Thanks

Even i was thinking the same, but somehow now able to write a performance oriented script.

I tired to write a recursive UDF that make uf Cursor, but it failed.

Can u...

Hi,

Yes i had already seen it , but it is talking about the situation when u have parent id and u wish to traverse all its child.

Hi,

I have removed the pics from the post and updated it with dml statements and sample data.

Please proceed as needed.

Regards