Dear Sir

Is any possible solution for this sir..Please

Dear Sir

In real data It goes up to 11 level . I would say not more than 12.

I have tried this but this is wrong anyway. It updates only...

@v.collazos: I know it's quite frustrating since it doesn't have a relationship. You can introduce null in the another column define the relationship or some other ways if...

Dear Sir

The above query produces the required result even though 101 not appear in the parent Id since it is top level parent.

PIDCID

16

output :1/6

16

output : 101/1/6

Many Thanks Experts.

Dear Experts

I don't think we can use the same query.

In the first row we don't want output 101/1 for parentID=101,childID=1

Instead the output should be 101/1/6 in the first row...

Dear Experts

@luis Cazares\@Sean Lange: Thanks for your effort and indeed this is great piece of work ,Knowledge Sharing and outstanding support.

@luis Cazares: This is an excellent...

I have updated my post . please refer the comments above.

Many thanks for your contribution and support towards to me .