Tagged Questions
2
votes
1answer
267 views
Displaying parent attributes alongside child attributes
SSAS - Parent Child hierarchy - displaying other Parent attributes alongside Child Attributes
For example:
Employee Table
+-----+-------+------+---------------+
| KEY | NAME | ROLE | MANAGERKEY ...
5
votes
1answer
161 views
How can I efficiently represent inheritance down a tree?
I have a database with three "levels" of objects: A, B, and C. Table A has around 100000 rows, B has 500000, and C has 2 million.
In a fit of stupidity, I designed the database to use joining tables ...
