Re: UKHA Classified update - SQL Help!

[graham@xxxxxxx]

BUTLER, Tony, FM writes:

> Graham,
>
> I have run out of time on this, as I left the office about 20 minutes
ago
> (!) but run the stuff below in I/SQL which should help you.
> Basicaly, #sp_prod_list retrieves a list of all products under a given
> product type, all the way down the tree (well, depends on your version
of
> SQL - earlier ones can only go 15 levels deep).
> It's not _quite_ the answer, but a starting point.
> You just need to roll up the data to the appropriate level.
>
> Note: I am using temporary procs and table for convienience - obviousy
you
> would have permanent ones in the final results.
>
> Back in tomorrow so feel free to ask any questions if more details
required.
>
> HTH,
>
> Tony
>
Thanks Tony, I'll try to play with this tonight.

<big snip>