> I have a table (see below) where I want to combine the two totals below into > the 0304KZ6 total so that I can end up with something like the second example. > > current 0304KZ6 6786.11 > 0304KZ6RR 3750.41 > > desired 0304KZ6 10536.52 > 0304KZ6RR 0.00 > > Any help/direction is greatly appreciated. > > Thank you very much and have a great day!
GROUP BY on SUBSTRING? Won't be that fast out-of-the box on a huge table, but it might be improved by a function-based index. -- With regards, Thomas Steinmaurer http://www.upscene.com/
