Viewing 15 posts - 1 through 15 (of 29 total)
Yes, this is it. Thank you.
(sorry for the duplicate thread , the server was not responding on SUBMIT - I probably clicked twice)
October 22, 2021 at 3:47 pm
Ok, I guess that I just had to learn about stored procedures and how to start them with VBA. Done.
September 11, 2020 at 2:00 am
I detailed the query above. I have shown the Excel pivot table. I know what is a script, but I don't understand what is your request here.
July 10, 2020 at 11:13 pm
UNION ALL didn't achieve what I am looking for. Please see attachment. There are two warehouses, S0 and LU. On the first line, we can see that activity was...
July 9, 2020 at 5:37 pm
I love it when it works the first time! Thank you.
May 21, 2020 at 10:33 pm
This way is quite new to me and it works (same numbers of records).
September 11, 2019 at 12:16 pm
They are datetime type. I guess that removing the apostrophes around the dates was required - it seems to work now without them
September 10, 2019 at 8:07 pm
Hello Jonathan, I still get the same results but I adapted your method to another table and so far, so good.
SELECT ...
September 10, 2019 at 6:04 pm
Now my best shot based on David's reply. It works via a temporary table, but it is a bit complex. If there is a way to simplify, I would...
September 10, 2019 at 2:56 pm
Hello Jonathan. I tried it, unfortunately, for part no XXX708, it selects 3 warehouses with no activity but there are 2 more with recent sales.
I would want XXX708 to not...
September 10, 2019 at 2:20 pm
Oh!... I apologize for the duplicate, it didn't pass through the first time (gateway error). :o( Please delete if possible.
September 10, 2019 at 2:06 pm
The CTE version did the trick, thank you!
Also using "-PAST" instead of "PAST" did put it first
June 14, 2019 at 1:14 pm
I copied and pasted from your reply and again, same result.
More specifically
Msg 207, Level 16, State 1, Line 41
Invalid column name 'DueDate'.
Msg 207, Level 16, State 1, Line 41
Invalid column...
June 14, 2019 at 1:08 pm
I tried it and got
Invalid column name 'DueDate'.
June 14, 2019 at 12:51 pm
Well I just did that - I used a temporary SQL table. Maybe not the most sophisticated query but it works. I thought that I could handle a temporary recordset...
February 13, 2019 at 9:37 am
Viewing 15 posts - 1 through 15 (of 29 total)