[thelist] query help (ms sql 2000)

Brian Cummiskey brian at hondaswap.com
Fri Jan 12 08:53:59 CST 2007


Matt Warden wrote:
> <SNIP>
>
>
>   
> Untested:
Matt, 

Thanks, but that's not what I'm stuck on.  Perhaps I wasn't specific 
enough in my orig. posting.

That will give me rows (in this case, 4 with non-0 entries) with 
qty/price pairings based on item number.

What I need is the end result of 2 returned rows, grouped on price, but 
not on qty.

I've come to the conclusion that this cannot be done in sql server 
(without frontside scripting of those said 4 rows), due to having to 
also group by on qty along with price, thus not giving me the proper 
groupings i need for display.   Confirmed by Rudy on sitepoint as well. 
(http://www.sitepoint.com/forums/showthread.php?t=451056)

So, now i'm in asp loop hell, trying to account for all 9 cases of 
whether price(0) = price(1) and if so does price(1) = price(2) 
......     and that needs to be done 9 times...   fun is.  heh




More information about the thelist mailing list