[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
Re: Re: UKHA Classified update - SQL Help!
- To: ukha_d@xxxxxxx
- Subject: Re: Re: UKHA Classified update - SQL Help!
- From: steve.cooper@xxxxxxx
- Date: Wed, 27 Mar 2002 10:14:53 +0000
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
>>across all lower level ProductTypes
Just to clarify before I have a look at this for you.
By the above do you mean a ProductTypeID that doesn't appear in the
ParentProductTypeID of any other Product Type. I would have thought in
your application you need a cascading count.
i.e.
Computer
- Hardware
A box
Another box
- Software
A lotus product
A microsoft product
A product that works
So when you put in Software you get an answer of 3 but when you put in
Computer you get an answer of 5, 2 Harware + 3 Software.
Is this correct?
S.
___________________________________________________________________________
The information contained in this message is confidential and may be
legally privileged. If you are not the intended recipient, please do not
read, copy or otherwise use it and do not disclose it to anyone else.
Please notify the sender of the delivery error and then delete the
message from your system.
Any views or opinions expressed in this email are those of the author only.
Thank you for your assistance.
___________________________________________________________________________
Home |
Main Index |
Thread Index
|