Re: SQL Gurus - Producing 'Misc' row only when necessary ?

From: Richard Shea <richardshea_at_fastmail.fm>
Date: 26 Aug 2003 05:54:51 -0700
Message-ID: <282f826a.0308260454.72f8aa21@posting.google.com>

vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0308250445.4247b6ab_at_posting.google.com>...
> A wee correction to my posting.
>
> The flag is not really zero or one as I said.. it is actually zero or
> no-zero. Thus all the zero marked rows are below value X and get
> summed into the special MISC group and all non-zero marked rows get
> summed into their relevant group as indicated by that row.

Hi Billy and Anurag - Thanks for the idea, it works fine - I'm very impressed ! Took me a while to impelment in the real query but it's now working just fine. Thanks again.

richard. Received on Tue Aug 26 2003 - 07:54:51 CDT