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 |
|
abcd
Yak Posting Veteran
92 Posts |
 Posted - 2009-02-20 : 04:12:00
|
| hi all....I am here again to gain some help from you people...Suppose there is a main table named as CEO ,under that CEo some managers are present,under managers there are some zone managers and under them there are some clerks..Means there are 4 levels in all,from top to bottom...Now i want to design table for this information and there have to be no primary keys to be included...Also i have to calculate number of total persons under each level head..Output should be as ..NAME HEAD CEO NUll MNGR1 CEO Mngr2 CEO ZoneManager1 Mngr1 ZoneManager2 Mngr1 ZoneManager3 Mngr2 Clerk1 ZoneManager2 Clerk1 ZoneManager2 Clerk2 ZoneManager3 Please suggest me how to make tables according to the data and output desired?? |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-02-20 : 04:17:43
|
| don't post duplicateshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=120212 |
 |
|
|
|
|
|
help for table structure..