RE: Recurrencing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 12/09/04 

Date: Thu, 9 Dec 2004 02:54:23 -0800

Hello again
Thanks to Itzik and Celko for help
The sample of Itzik works fine and Celko gave me a hint
how can I improve this querry with BOM

Regards
Adam

>-----Original Message-----
>First, you are making your question very unclear...
>How do you change your data from the upper to the lower
part, can you
>explain more....
>
>Ed
>
>"adam1225@poczta.onet.pl" wrote:
>
>> Hello everybody,
>>
>> I'am starting to programing sql so please forgive me
if
>> my question is "laming". First of all, I have looked
for
>> solution on the microsoft.public.sqlserver.programming
>> but I found nothing.
>>
>> I would like to do Bill Of Material (Recipie) from
data
>> which are stored in tabel:
>>
>> Parent Party qty
>> -------- ------ ----
>> A B1 1
>> A B2 1
>> A B3 1
>> B2 C1 1
>> B2 C2 1
>> B2 C3 1
>> B2 C4 1
>> B2 C5 1
>> C2 D1 1
>> C2 D2 1
>> C2 D3 1
>>
>> then I need lists all material which are belongs
to "A"
>> (on all levels)
>> Lev Parts Qty
>> --- -------------- ---
>> 0 A 1
>> 1 B1 1
>> 1 B2 1
>> 2 C1 1
>> 2 C2 1
>> 3 D1 1
>> 3 D2 1
>> 3 D3 1
>> 2 C3 1
>> 2 C4 1
>> 1 B3 1
>>
>>
>> I think that this could be done using recurrency or in
>> other way.
>>
>> I really don't know how to do this.
>>
>> regards
>> Adam
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>.
>

Relevant Pages

  • Re: Cannot open any page
    ... The hint works great. ... >> use other programs like ftp, telnet, ping, treaceroute they works all ... >> Kind regards, ... >> Martin Schweizer ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: "Sort Data" omits Row 1
    ... Sometimes that's enough to give excel the hint that that row is not part of the ... > the Sort Ascending button. ...
    (microsoft.public.excel.misc)
  • spider web type calculation
    ... corresponding wieght of 2 and calculate ... can you guys give me a hint how to program this? ...
    (comp.soft-sys.matlab)
  • testing BGP
    ... i want to do some testing on the BGP and may be other routing protocols. ... any hint on tools and info? ... regards / Mit freundlichen Grüßen ...
    (Pen-Test)
  • Re: Is there some methods to solve equations with MIN operation?
    ... Could anyone give me a hint about which part of mathematics does this ... problem belong to? ... Best regards, ...
    (sci.math)