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 |
tonysoeun
Starting Member
1 Post |
Posted - 2012-09-07 : 23:19:58
|
Hi all experts,i create one sales quotation with 3 finish goods,in each finish goods was created by alot of material and some material was created by other material.My question is:How can i display all item?TONY |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-08 : 00:48:16
|
Give us your schema and expected results.-Chad |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-08 : 06:54:45
|
There is a pretty good article here: http://msdn.microsoft.com/en-us/magazine/cc794278.aspxIt is a little long, but helpful. Also, you need to be on SQL 2008 or higher to use it. There are other ways without using the hierarchyID data type - if you google for "hierarchies in SQL" you will find useful links. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-08 : 17:01:27
|
quote: Originally posted by tonysoeun Hi all experts,i create one sales quotation with 3 finish goods,in each finish goods was created by alot of material and some material was created by other material.My question is:How can i display all item?TONY
how are finish goods and materials stored? is there kind of hierarchial relationship?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|