Click here to Skip to main content
15,885,885 members

Comments by CringTee (Top 12 by date)

CringTee 22-Aug-16 2:30am View    
Thanks Sir. I have updated the question as u recommended, If it has a fixed number of child data then yes your solution will help to solve the problem. But my data will have N number of child.
CringTee 22-Aug-16 2:29am View    
Deleted
Thanks Sir. I have updated the question as u recommended, If it has a fixed number of child data then yes your solution will help to solve the problem. But my data will have N number of child.
CringTee 18-Aug-16 23:19pm View    
Since it is a Hierarchy Table there will be n number of child or there may not be a child. The data in my question is just a sample data that may help to understand the question. n number of child data will have a level name(category) like in my example "objective, criteria, procedure, sub-procedure, etc". thus, we cannot do "ON C.ParentID = O.ID And C.Category = 'Criteria'", it should be dynamic.
CringTee 18-Nov-15 1:04am View    
Thanks for your solution.
Yes printcontrol.dll is three in the pass. still getting same error.
CringTee 30-Oct-15 2:36am View    
Thanks you so much sir. it has solved my problem