June 12, 2002 at 8:25 am
Hello all-
I am _trying_ to put together an organizational chart for for an app, but I am having all kinds of trouble. Some of the basic questions I need to answer are...
Who's is Bob's boss? And that bosses boss?
Who reports to Bob? And who reports to those people?
I know that Oracle has a "CONNECT BY" operator that would work great, but have not found anything in SQL Server.
I am still in the early stages and have tried a few different models without success. Open to suggestions, idea or even better; examples.
Can someone point me in the right direction?
Thanks,
Doug
June 12, 2002 at 8:58 am
Hi there
Get hold of "Advanced Transact-SQL for SQL Server 2000" by Itzik Ben-Gan and Tom Moreau, published by apress (www.apress.com).
ISBN is 1-893115-82-8
Chapter 16 is all about Expanding Hierarchies which is exactly what you need I think.
Regards
Simon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply