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 - 2001-04-29 : 22:50:34
|
Melanie writes "Has anyone ever used an expanding hieararchy to explode a build of material list? I'm trying to take a finished goods list break it down into the build of material list that will break down into the smallest part. This means that it will loop through all the part numbers in that build of material list to see if they break down even further into subassemblies. After I break each level down I then will manipulate some calculations. Any help would be greatly appreciated. Thanks in advance.
Melanie
PS. I have already looked in the BOL and have expounded upon the example there but need just alittle more help. I am using SQL Server 6.5 and Windows NT SP 6." |
|
|
|
|
|
Expanding Hierarchies