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 - 2000-08-24 : 19:48:01
|
Brian writes "The problem I am having deals with a flavor of inheritance. Namely, I have two tables, one lists dimensions of standard components and the other table lists "changes" from the standard configuration.
To form an example I have table A:
A WI 6
A WH 4
A RI 4
A EX 2
B UD 1
B EX 1
Then I have a second table:
1 A WH 3
1 A RI 3
2 A EX 1
Which means a "standard" A component has dimensions WI=6,WH=4, RI=4, and EX=2 but in particular
component 1 (which is based off the A component) has dimensions WI=6, WH=3, RI=3 and EX=2.
So what I am trying to produce is a dataset that looks like:
1 WI 6
1 WH 3
1 RI 3
1 EX 2
2 WI 6
2 WH 4
2 RI 4
2 EX 1
Any advice on how to proceed?"
|
|
|
|
|
|
table Inheritance?