Home Forums Database Design Design Ideas and Questions Design Question - Company, Clients, Branches, Departments RE: Design Question - Company, Clients, Branches, Departments
Toby Harman
SSCarpal Tunnel
Points: 4168
More actions
December 29, 2010 at 5:01 pm
#1267469
Collapse the structure to a single table and use a HIERARCHYID.
That way you can define a flexible heirarchy in this table and attach to specific points.