I am worried about the performance of the system...

see My idea is to give tree kind of manage employees screen. I will render all employees as tree and user can...

Hi Jeff

here is the answer for your question 😀 See In my database there are 2-3 such hierarchical sets. one is Employee-Manager kind of, another is location and sub-locations, organizational...

by the way this is also a very good link for nested sets

http://www.codeproject.com/KB/database/nestedsets.aspx

Can you explain bit more about it.

Thanks all.

I gone through nested sets options its really best one for high performance reads on such data. but update and insert is bit costly however I can afford it...

Thanks for the reply.

is there any way to do the transactional update in database. I mean i need to insert contactinfo first and then based on the identities returned need...

hey all thanks for your replies.

I tried to use CTE here but how to specify a specific depth in CTE query. In a heirarchy of depth 6 if i want...