Query

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mike John SSCertifiable Points: 7216 More actions · Answer 1

Can you tell us the rules for why those rows are being returned and not others?

Also you will get the best replies if you post create table statements, plus a set of inserts to set up the test data.

Thanks

Mike John

peterausger Mr or Mrs. 500 Points: 544 More actions · Answer 2

Sorry for not creating the script.

This is what i am looking for..

For example, if user searches bb , the user expects following op. the reason is its hierarchical

so if its represented in a tree view, its easy for the user to understand the master child relationship.

5 bbb 0

6 bbbbb 5

7 bbbb 6

8 bb 7

13 bb 0

I will provide the scripts lil later

thanks

peter

Shadab Shah SSCarpal Tunnel Points: 4759 More actions · Answer 3

Hi Peter,

Could you help me understand why

14 bbbb 13

15 bbbbb 14

16 bbbbbb 15

are not in the result set and why the result set stopped at

13 bb 0

peterausger Mr or Mrs. 500 Points: 544 More actions · Answer 4

i am searching just bb

emp_id 8 and 13 has the value bb

the parentid of bb(8) is 7

and parentid of bbbb (7) is 6

and parentid of bbbbb(6) is 5

and parentid of bbb(5) 0

so in short i want to display parent id at the top like below

bbb(user clicks child is displayed)

-- bbbbb(user clicks child is displayed)

------bbbb(user clicks child is displayed)

--------bb(user clicks child is displayed)

bb(no child is displayed)

thanks

peter