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 |
|
cyrus_thevirus
Starting Member
5 Posts |
 Posted - 2006-08-29 : 16:00:13
|
| I've hit a snag on a project I'm working with here's the scenario.I have a list of health facilities. These health facilities exist in a physical location. The facilities can be grouped by counties, parishes, districts,or anything. The counties/group can be grouped into a higher grouping level e.g. Trauma Regions, Emergency medical Service regions or anything. Facilities can exist in more than one grouping. A Group can also be grouped by an infinite number of higher level groups e.g. State, Country, Province etc.Basically i want to be able to dynamically create an infinite number of groups for my facilities(note: groups can be grouped into multiple groupings).Does anyone know how to model this correctly and effeciently?Thanks in advance. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-29 : 16:15:44
|
>>> "infinite number of groups"You should reconsider this requirement. That's a very large number. You can do it, but it will take an infinite amount of time. CODO ERGO SUM |
 |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2006-08-29 : 21:57:13
|
| Group table - ID & name or whateverGroupGroup table containing 2 group ids (constrained that they are not the same)FacilityToGroup table -FacilityID, GroupID |
|
|
|
|
|
|
design/modelling