I have used the below query for the getting different dense rank
select ROW_NUMBER() OVER (ORDER BY column2,column84,column21) ID,
RANK() OVER (...
I Dont want the level index,i want as like the previous result of wt u hv given(Parent-Child). I am running out of time FrankKalis...
My Requirement is that,I need to display the data it in hierarchical form i.e I want to bind it to the treeview.so that my treeview look like...
Thanks a lot but i need a favor.
If I have one more column
ID Column1 Column2 Column3...
I have a Table as below,
ID Column1 Column2 Column3
1 ABC ZXC...
Separate names with a comma.