Viewing 3 posts - 1 through 4 (of 4 total)
'doesn't work' : The query doesn't execute. Does not return a value for USER.
March 15, 2011 at 11:54 am
Lowell (12/22/2010)
SELECT #mx.bid_price_old, #mx.* FROM #mx
LEFT OUTER...
December 23, 2010 at 7:12 am
Sean Lange (12/22/2010)
try something like this.
select item_num, pack, item_size, old_desc1, manufacturer_item_nbr, brand_name, opco_desc, flag, COUNT(distinct bid_price_old) as bidCount
from #mx
group by item_num, pack, item_size, old_desc1, manufacturer_item_nbr, brand_name, opco_desc, flag
This is...
December 22, 2010 at 1:58 pm
Viewing 3 posts - 1 through 4 (of 4 total)