Sorry I figured out what the issue is. It was stupid transaction issue.

Chris - Thanks works great.

Its a query only from classic asp code.

The SKU1 is updated with the heaviest sku in the list of SKU's.

The heaviest SKU is predetermined in SKUVAL, the weights are hidden.

So essentially it looks through the list and...

Thanks,

I will try out the new query this afternoon. Just so that eveyone knows this process is to update the 1st SKU with the heaviest SKU. When...