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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-28 : 08:34:11
|
| Luqman writes "I normally use crystal report with sql server 2k for my various reporting needs, now I am trying to figure out, how can I display aggregate totals of boss and their subord. downwards.For example:-President Senior Manager Manager-1 Secretary Clerk Total of Manager-1 Manager-2 Secretary Asst. Secretary-1 Asst. Secretary-2 Total of Secretary Total of Manager-2Total of Senior ManagerTotal of PresidentBest Regards,Luqman" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-28 : 12:00:00
|
| One of the first things we need to know is which hierarchical (or tree) model did you use? There are at least three different ways of modeling this. If you would provide some DDL (CREATE TABLE statements) and some DML (INSERT statements) to provide us with some sample data, it will be a lot easier to answer your question.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
 |
|
|
|
|
|
using groups and aggregates in Hierarchical queries