Ahhhh that's much better for me.

Thank you Chris.

Thank you Frederico.

Thank you. My intention was if any of the fields were =  40 then update them to zero. I used the single update statements as suggested by Mike in the...

Oh, I see. Haha, just me trying to be clever

Thank you for your help Mike. I'll go with the simple option.

Yes, thanks John. I've done that now.

Anyone have any idea how or why some columns ended up different collation to the others and to the default collation of the server...

Hi Crow,

I see, I didn't realise that. I got the script off the net,  I thought it would update the collation for me.

Thanks for the insight. I'll copy the results...

Brilliant, thank you very much Scott.

Thank you all for you help and replies. I've been speaking with my boss and he has suggested doing it a different way now.

I should add that the dates don't show up in the customers output.
They are only included in the view so that I can use them to filter it.

Well, the query is to find out what items the customer currently has in stock.

They choose a filter date and (if they wish) a product group and...

Hi Steve,

The only things I want to group by are Products.REFERENCENUMBER, products.PRODUCTGROUP,  Products.DESCRIPTION,  Customer.CUSTOMERNUMBER,     Stock.CustomerID, customer.name.

I need the dates in the query because it's...

Sorry Phil,

The fields I need to omit from the group by clause are the date fields (Stock.DATEANDTIMEIN and  Stock.dateout)

Thank you
Paul.

Ok Ben. Thank you very much for your time and explanation.

Brilliant Ben, thats done the trick. Thank you.

I don't understand how this line works though....

SUM(total)*1.0 / COUNT(*) AS Price_Per_Unit


How does it...

Is there any way I can reference "Quantity" so that I can divide the "Price" by the "Quantity" to get the price per unit?