Viewing 15 posts - 16 through 30 (of 90 total)
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...
August 9, 2019 at 12:32 pm
Brilliant, thank you very much Scott.
August 30, 2018 at 10:06 am
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.
August 16, 2018 at 2:22 am
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.
August 15, 2018 at 8:01 am
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...
August 15, 2018 at 7:54 am
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...
August 15, 2018 at 7:06 am
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.
August 15, 2018 at 6:45 am
Ok Ben. Thank you very much for your time and explanation.
August 15, 2018 at 2:13 am
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...
August 14, 2018 at 8:37 am
Is there any way I can reference "Quantity" so that I can divide the "Price" by the "Quantity" to get the price per unit?
August 13, 2018 at 6:46 am
Ok, thank you for the information Drew.
August 9, 2018 at 1:56 am
Brilliant, thank you very much for you help.
August 8, 2018 at 9:40 am
Hmmm, it doesn't seem to like me using the square brackets when I'm doing a join. It says invalid column name
SELECT
[S.SERVICE],[V.VEHICLE],
count(*) as Quantity,
August 8, 2018 at 9:19 am
Oh, i've just realised all I have to do is put the '[' brackets around the vehicle as well as the service. Brilliant.
Thank you very much
August 8, 2018 at 9:13 am
Hello,
Thank you for you response.
It's close but the issue is it counts the job with ND16 service and NEXTDAY vehicle in with the rest of the...
August 8, 2018 at 9:09 am
Viewing 15 posts - 16 through 30 (of 90 total)