RE: Re: UKHA Classified update - SQL Help!

["BUTLER, Tony, FM" <tony.butler@xxxxxxx>]

Another question I'm sure Steve meant to ask (!) is:
Can you have a product at the Computer level, or is it _just_ at the lowest
level - ie Hardware or Software in this example?

Tony
> -----Original Message-----
> From: steve.cooper@xxxxxxx [mailto:steve.cooper@xxxxxxx]
> Sent: 27 March 2002 10:15
> To: ukha_d@xxxxxxx
> Subject: Re: [ukha_d] Re: UKHA Classified update - SQL Help!
>
>
>
> >>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.
>
> ______________________________________________________________
> _____________
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> FIND OLD SCHOOL FRIENDS and OLD FLAMES
> Click here to start your search at Reunion.com today!
> http://us.click.yahoo.com/NFsLKA/Dn2DAA/ySSFAA/IBOolB/TM
> --------------------------------------------------------------
> -------~->
>
> For more information: http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>


********************************************************************
Visit our Internet site at http://www.rbsmarkets.com

This e-mail is intended only for the addressee named above.
As this e-mail may contain confidential or privileged information,
if you are not the named addressee, you are not authorised to
retain, read, copy or disseminate this message or any part of it.
********************************************************************