Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Help on dynamic hierarchy sql server 2005

Author  Topic  lucawork Starting Member 1 Post Posted - 2008-08-22 : 11:04:26 i'm a newbie on sql server 2005, and i would need to know how i can settings tables or properties to using dynamic hierarchy. I try to explain me better: i've a school-DB of a general shop where i store history of employees with init data, end data, departement ecc. I would like to hold the history of these employees that can change departement, using dynamic hierarchy like events analysis. How i can do that with sql server 2005? i don't find the right properties to set and fix my problem. i know that exist 4 type of dynamic hierarchy: 1- All events are reported at the actual configuration of the hierarchies 2- All events are reported at the previously configuration assunts by hierarchies 3- All events are reported at the right configuration respect at the time we consider 4- It considers only the events are never changed. I hope someone can help me Thank you for your attention